#how to add #auto serial no and cell border in #excel | #exceltricks | Most powerful #exceltutorial

preview_player
Показать описание
#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
Рекомендации по теме
Комментарии
Автор

It's really awesome very helpful viedo thanks for sharing

stbartvlogs
Автор

Very Nice Anna Explanation *Thank You So Much* 😀😀😀

aarjunshinde