frozen panes
How do I make my frozen panes/rows print at the top of each page?
|
frozen panes
FilePage setupSheetRows to repeat at top
-- Kind regards, Niek Otten Microsoft MVP - Excel "jmack" wrote in message ... | How do I make my frozen panes/rows print at the top of each page? |
frozen panes
Hi,
Do the following: 1. On the File menu, click Page Setup. The Page set up dialog appears. 2. In the Page Setup dialog box, click the Sheet tab. 3. Under print titles, click the Rows to repeat at top box and then click the row numbet to the left of the worksheet. Note: [Optional] You can press the Ctrl key and click more than one row to repeat on the top. 4. Click OK. Challa Prabhu "jmack" wrote: How do I make my frozen panes/rows print at the top of each page? |
All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com