Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kawasaki
 
Posts: n/a
Default How do I get my header in Exell to follow me down a spread sheet

As I move down my spread sheet how can I get the header titles to follow me
down as I make my entries?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
damorrison
 
Posts: n/a
Default How do I get my header in Exell to follow me down a spread sheet

Hi Kawasaki
if you select row 2 and then go to the windows menu at the top of the
screen
and select freeze panes, that shoud do it

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bill Kuunders
 
Posts: n/a
Default How do I get my header in Exell to follow me down a spread sheet

one way
select the first cell under your headings and use the menu "Windows" and
select Freeze panes.

the other way,
With a normal window without froozen panes, move the mouse pointer to the
top right corner just above the up arrow. The pointer will change to an up
and down arrow.
Left click and drag down to create enough room for your heading.
You now have two seperate windows of your sheet.
--
Greetings from New Zealand
Bill K



"Kawasaki" wrote in message
...
As I move down my spread sheet how can I get the header titles to follow
me
down as I make my entries?



  #4   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default How do I get my header in Exell to follow me down a spread sheet

Hi Kawasaki,
You will also want to keep the column titles at the top of each sheet
when you print. File, Page Setup, Sheet, rows to repeat at top: $A:$A

More information both Freeze and Rows to Repeat and similar things in
http://www.mvps.org/dmcritchie/excel/freeze.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bill Kuunders" wrote in message ...
one way
select the first cell under your headings and use the menu "Windows" and
select Freeze panes.

the other way,
With a normal window without froozen panes, move the mouse pointer to the
top right corner just above the up arrow. The pointer will change to an up
and down arrow.
Left click and drag down to create enough room for your heading.
You now have two seperate windows of your sheet.
--
Greetings from New Zealand
Bill K



"Kawasaki" wrote in message
...
As I move down my spread sheet how can I get the header titles to follow
me
down as I make my entries?





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
Master spread sheet to manage then show info on seperate tabs Little pete Excel Worksheet Functions 1 January 25th 06 02:28 PM
I'm creating a simple spread sheet Jan in Excel Excel Discussion (Misc queries) 2 January 2nd 06 07:48 PM
Can I add more columns to a spread sheet or is limit 256 columns Piper Excel Discussion (Misc queries) 4 October 9th 05 08:27 PM
Excel Slow to open Spread Sheet from Explorer Charles Welty Excel Discussion (Misc queries) 0 October 5th 05 02:16 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 11:19 AM.

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"