ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want a title to print on every page of a worksheet; not a header (https://www.excelbanter.com/excel-discussion-misc-queries/69044-i-want-title-print-every-page-worksheet%3B-not-header.html)

DeltaPearl

I want a title to print on every page of a worksheet; not a header
 
I want the column headings for each column to print at the top of each page
instead of me having to copy and paste it at the beginning of each page.

Thanks!

Kevin B

I want a title to print on every page of a worksheet; not a header
 
Set the rrows to repeat at top from the sheet tab after selecting FILE, PAGE
SETUP and indicate which row or rows you want repeated.
--
Kevin Backmann


"DeltaPearl" wrote:

I want the column headings for each column to print at the top of each page
instead of me having to copy and paste it at the beginning of each page.

Thanks!


BekkiM

I want a title to print on every page of a worksheet; not a header
 
In Page Setup, click on the "Sheet" tab.

In the area titled "Rows to repeat at top", click in the box, then click on
the row(s) you want to have at the top of each page.

"DeltaPearl" wrote:

I want the column headings for each column to print at the top of each page
instead of me having to copy and paste it at the beginning of each page.

Thanks!



All times are GMT +1. The time now is 05:04 PM.

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