excel

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

Guest

Could you tell me how on an excel sheet, I could remove the column headings,
but keep the row numbers?

Thanks
Aamir
 
You can't. You can turn both columns headings and row numbers on
or off together, but not separately.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Aamir said:
Could you tell me how on an excel sheet, I could remove the column headings,
but keep the row numbers?

Thanks
Aamir
Click to expand...
Fake it!
Put the row numbers in column A with a bold font and gray(or whatever)
background. Be sure not to delete or insert any rows, though.

Bill
 
Good thinking Bill,
But we can get the row numbers to be correct even if rows are deleted by
putting the formula for the row instead of the value.
So in the column A, I would put " = ROW() " .
Should werk.
said Xerk
 

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

numbering pages of worksheets in one workbook 3
excel data sheet 1
Red cell for negative numbers in Excel 1
page numbering 1
grayed area 1
copy custom header from one worksheet to another in same workbook 3
Excel copy and paste 1
Changing the positions of certain sheets in excel 3

Back
Top