Hiding ABC and 123

  • Thread starter Thread starter Guest
  • Start date Start date
Hi!

Tools>Options>then uncheck row and column Headers.

Note: its effect only extends to the sheet which is active when you d
it. AFAIK it can't be made to do the whole workbook. Wish it could
sometimes.

Al
 
AlfD > said:
... AFAIK it can't be made to do the whole workbook.
Wish it could, sometimes ..
Click to expand...

Try this sub to do it for the whole workbook:

Sub RemoveRowColHeaders()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ActiveWindow.DisplayHeadings = False
Next
End Sub
 
Thank you
-----Original Message-----
Click Tools > Options > View tab
Uncheck "Row & column headers" > OK

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----



.
Click to expand...
 
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

Hiding Header Columns abc... in 2007 1
How to change the column headers from ABC to 123 2
How to export table from outlook into ms access table? 0
Changing column heads from ABC to 123 2
Headings 1
How to split number and text string to separate cells? 5
EXCEL read a text string as scientific notation 7
lookup duplicate value 7

Back
Top