Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Microsoft Excel?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-18-2007, 12:02 AM
Junior Member
 
Join Date: Sep 2007
Posts: 15
Default Microsoft Excel?

Is there a way to display a columns heading no matter how far you scroll down in microsoft excel
Reply With Quote
Links
  #2 (permalink)  
Old 10-18-2007, 06:37 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

Place your cursor just below the column headings then go to the menu bar, click window, freeze panes. this should lock the pane above your cursor and allow you to scroll down while still seeing the column headers.
Reply With Quote
  #3 (permalink)  
Old 10-18-2007, 06:38 PM
Junior Member
 
Join Date: Oct 2007
Posts: 2
Default

click on the cell below the column, then click on "window" and select "freeze panes"
Reply With Quote
  #4 (permalink)  
Old 10-18-2007, 07:11 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

freeze the cells, then youll see the titles all the way down. to freeze them go to window and click "freeze panes"
Reply With Quote
  #5 (permalink)  
Old 10-19-2007, 09:10 AM
Junior Member
 
Join Date: Sep 2007
Posts: 26
Default

Yes, select the area and click View then "Freeze Panes". You might have to work with that for a little while before you get it, but thats how you do it.
Reply With Quote
  #6 (permalink)  
Old 10-19-2007, 10:19 AM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

Select a cell in the row just UNDER the row of column headers. Then go to "Window>Freeze Panes" in the drop down menus.
Reply With Quote
  #7 (permalink)  
Old 10-19-2007, 11:52 AM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

Let's assume your column headings are in rows 1 and 2, and your row headings are in column A. Go to cell B3 (basically go just below your headings and just to the right of the titles on the left) and select Window->Freeze Panes.

This will freeze everything above and left of the cell that you're in allowing you to scroll down or right as far as you'd like, but keep the headers and tltles in view.
Reply With Quote
Reply


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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 09:30 PM.