A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Get column headings to float when scrolling down?



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 03:13 PM posted to microsoft.public.excel.worksheet.functions
Wendy
external usenet poster
 
Posts: 255
Default Get column headings to float when scrolling down?

How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?
  #2  
Old May 28th, 2010, 03:25 PM posted to microsoft.public.excel.worksheet.functions
tim m
external usenet poster
 
Posts: 418
Default Get column headings to float when scrolling down?

Put your cursor just below the lines you want to float and then 'freeze
panes' (I'm not sure which version of excel you are working with.)

"Wendy" wrote:

How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?

  #3  
Old May 28th, 2010, 03:29 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Get column headings to float when scrolling down?

Let's assume you have column headers in A1, A2 and A3.

Select cell A4
Goto the menu WindowFreeze Panes

--
Biff
Microsoft Excel MVP


"Wendy" wrote in message
...
How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?



  #4  
Old May 28th, 2010, 03:32 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Get column headings to float when scrolling down?

Select A4 and WindowFreeze Panes.

Rows 1 to 3 will remain in view as you scroll down the sheet.


Gord Dibben MS Excel MVP


On Fri, 28 May 2010 07:13:01 -0700, Wendy
wrote:

How do I get the first three or four lines where I have typed in my column
headings to "float" down as I'm entering information in the lines below?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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