How to Format Excel Sheet ToShowRowNumbers but not the column alph

D

Debie Schilling

How to you format the Excel Sheet to show the row numbers but not the column
alpha A, B, C, D, etc.?

It appears that it makes you show both, but we only want the row numbers to
show and when we insert another row the excel sheet will numerically adjust
to any additional rows.
Thanks
 
P

Peo Sjoblom

You can't, you could remove both (row/column headers) and create your own row
numbers and using a macro that would adapt to inserted rows


Regards,

Peo Sjoblom
 
Top