#1   Report Post  
Breny
 
Posts: n/a
Default assigning rows

How would I assign a row to appear at the top of every page? For instance, I
have data in row 1 and I would like it to appear at the top of every page as
a master of kinds.
  #2   Report Post  
bpeltzer
 
Posts: n/a
Default assigning rows

To have the top row(s) remain visible while you're working, select the next
row and Window Freeze Panes. To have the top row(s) print on every sheet,
goto File Page Setup, select the Sheet tab and choose the rows in the entry
'Rows to repeat at top' (the entry will read something like $1:$1).


"Breny" wrote:

How would I assign a row to appear at the top of every page? For instance, I
have data in row 1 and I would like it to appear at the top of every page as
a master of kinds.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM
REALLY miussing rows in Excel2000 Geoff Lambert Excel Discussion (Misc queries) 2 July 21st 05 03:20 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"