ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Format Excel Sheet ToShowRowNumbers but not the column alph (https://www.excelbanter.com/excel-discussion-misc-queries/26119-how-format-excel-sheet-toshowrownumbers-but-not-column-alph.html)

Debie Schilling

How to Format Excel Sheet ToShowRowNumbers but not the column alph
 
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

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

"Debie Schilling" wrote:

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



All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com