delete column heading for print

[Guest]

I need to know how to delete the (ABCDEF........) headings when we print but
keep the (123456.....) Row heading in the print screen. Can you help and can
it be done?

 

[Gord Dibben]

Daffy

You cannot hide the column headers ABCDEF without also hiding the row headers
123456

Workaround..........

Insert a column left of current column A

In A1 of the new column enter =ROW()

Drag/copy that down as far as you wish.

Now File>Page setup>Sheet. Uncheck row and column headers.


Gord Dibben Excel MVP