how to add borders automatically to cells in excel
How To Add Borders Automatically To Cells In Excel
STEP:
1: Select the entire range you might or might not be using.
2: Click on “Conditional Formatting”
3: Click on “New Rule”
4: Click on “Select Formula to Determine Which Cell to Format”
5: Write this Formula
6: Now Click on Format
7: Go to Border and Select Outline.
8: Click ok and ok again.
Done.
Now whenever you write something conditional formatting will add borders automatically for you.
This will create a dynamic border for you and you won’t need to insert border manually again.
#Excel #border
#Border #Automatically #advanceexcel