#howtomakemoneyonline to add #auto serial no and cell border in #excel | #exceltricks | Most powerful #exceltutorial
in this video explaining how to add auto serial number and cell border in ms excel
For Auto serial numbering:
=SEQUENCE(COUNTA(B:B)-1)
use above formula
For Auto cell border:
Goto Home tab - Style- conditional formatting - New rule - select use a formula to determine which cell to format
how to add borders in excel,how to add borders automatically to cells in excel,automatic border in excel,border in excel,auto serial number in excel,excel,how to add border in excel,how to make auto border in excel,how to add borders automatically in excel,excel tips and tricks,auto border in excel,excel add border if cell contains text,how to apply dynamic border in excel,microsoft excel,how to create dynamic border in excel without vba,excel border
Ещё видео!