ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing Headers (https://www.excelbanter.com/excel-discussion-misc-queries/19283-printing-headers.html)

[email protected]

Printing Headers
 
How do I print the headers of each column at the top w/o printing the row
numbers on the left hand side and the ABCs at the top?

Kassie

I take it you want to print your headings, such as maybe Date, Qty, Price etc.
If this is the case, click on File|Page Setup and then on Sheet. You can
select the row or rows you want to repat on each page.

" wrote:

How do I print the headers of each column at the top w/o printing the row
numbers on the left hand side and the ABCs at the top?


Gord Dibben

FilePage SetupSheet.

Uncheck "row and column headings" and then set "rows to repeat at top" to
$1:$1


Gord Dibben Excel MVP

On Fri, 25 Mar 2005 11:11:03 -0800, "
wrote:

How do I print the headers of each column at the top w/o printing the row
numbers on the left hand side and the ABCs at the top?




All times are GMT +1. The time now is 09:36 AM.

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