ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   delete column heading for print (https://www.excelbanter.com/excel-worksheet-functions/59810-delete-column-heading-print.html)

Daffy

delete column heading for print
 
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

delete column heading for print
 
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 FilePage setupSheet. Uncheck row and column headers.


Gord Dibben Excel MVP

On Sat, 10 Dec 2005 11:16:02 -0800, "Daffy"
wrote:

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?



All times are GMT +1. The time now is 12:22 AM.

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