Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crazy4Dogz
 
Posts: n/a
Default How do I make a header row appear at top of each page (not cell#)

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I make a header row appear at top of each page (not cell#)

For printing:
File|page setup|sheet tab|rows to repeat at top

For viewing:
Select A1 (just to make sure it's visible)
select a cell (say B2)
window|freeze Panes

Everything to the left of that selected cell (b2 in my sample) will be frozen.
Everything above that cell will be frozen.



Crazy4Dogz wrote:

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default How do I make a header row appear at top of each page (not cell#)

File -- Page Setup -- Sheet tab

You should see a field called "Rows to repeat at top"

Fill in, or select, your rows here.

HTH,
Elkar


"Crazy4Dogz" wrote:

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?

  #4   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf
 
Posts: n/a
Default How do I make a header row appear at top of each page (not cell#)

When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help?


One way:

File Page setup Sheet Rows to repeat at top
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
How to display current page number in any cell of that page. Laljeet Excel Discussion (Misc queries) 8 February 2nd 08 01:31 AM
Excel: can I refer to cell reference in page setup header nikos Excel Worksheet Functions 0 February 21st 06 06:23 PM
how to get a cell on a page to equal the bottom most cell on dif Learning Assisstant in need of help Excel Worksheet Functions 1 May 24th 05 09:50 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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

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

About Us

"It's about Microsoft Excel"