ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formatting (https://www.excelbanter.com/new-users-excel/83404-formatting.html)

fwt,

formatting
 
Hi,

I had problem in excel, i am new to the excel , i had one problem in my
excel work sheet i had given format to first row of the sheet, while printing
it should print second page and rest of the pages in the same sheet. so
please help me. i hope that you understood my problem i am poor in english.

Thank you.

Debra Dalgleish

formatting
 
To print the first row on each printed page:

Select the worksheet
Choose File Page Setup
Select the 'Sheet' tab
In the 'Rows to repeat at top' box, type: $1:$1
Click OK

fwt wrote:
Hi,

I had problem in excel, i am new to the excel , i had one problem in my
excel work sheet i had given format to first row of the sheet, while printing
it should print second page and rest of the pages in the same sheet. so
please help me. i hope that you understood my problem i am poor in english.

Thank you.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 07:02 AM.

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