The Code Cage - Microsoft Office help Free Microsoft Office Help for all Applications!
Technical Support
Dish Network Satellite TV
 

To stop seeing these ads and get other benefits check This page!

Go Back   The Code Cage Forums > Newsgroups - Microsoft Topics > Newsgroup - Excel Forum > Excel Miscellaneous

Custom Search
Translate this Page!
Chat In Use Now! Microsoft Office Chat Online now!


Excel Miscellaneous Post questions in this forum if they are related to using Microsoft Excel that doesn't quite fit in any other category e.g quirks, Formulae or built in functionality etc.

Hey there!

It looks like you're enjoying but haven't created an account yet. Why not take a minute to register for your own free account now? As a member you get free access to all of our forums and posts plus the ability to post your own messages, communicate directly with other members and much more. Register now!

Already a member? Login at the top of this page to stop seeing this message.


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 19th March 2010, 04:06 AM
jls3
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Chats:
Default RE: How can I choose which lines are frozen using "freeze pane"?

------ Register to get rid of these "In Post" ads! ------


From the Microsoft Quick Reference Card at:

http://office.microsoft.com/training...RC011212161033

Freeze panes
Keep titles in sight as you scroll through worksheets. To freeze titles,
make a selection in the worksheet, and then click Freeze Panes on the Windows
menu.

To freeze titles, do not select the titles themselves. To freeze:

Column titles only Select the first row below the titles.
Row titles only Select the first column to the right.
Both column and row titles Select the cell that is both directly below the
column titles and to the right of the row titles.
To unfreeze panes, on the Window menu, click Unfreeze Panes.

Tip You can freeze panes anywhere, not just below the first row or to the
right of the first column. Click the row below, or the column to the right,
or the cell that is both below and just to the right of whatever information
you want to freeze.



"emilyp" wrote:

> I've tried highlighting the row I would like to freeze, usually just the
> first row, but it always freezes it after the 16th row. Any suggestions!?
> This is really frustrating!

Reply to this post


Did you find this post helpful? Yes | No

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
Reply

Bookmarks

Tags
choose, freeze pane, frozen, lines


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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

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

Forum Jump

The Code Cage Affilliates


To stop seeing these ads and get other benefits check This page!



All times are GMT +1. The time now is 01:39 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.5.0
No part of this board may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application the represent