How to Format Excel Sheet ToShowRowNumbers but not the column alph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Remove date format? 3
data to summary sheet for a dummy 0
"cannot shift objects off sheet" error 8
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Transpose large column 3
rows and columns on worksheet 1
Transpose, but how? 0

Back
Top