Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

freeze panes

Status
Not open for further replies.
faxof

faxof

Programmer
Joined
Dec 5, 2001
Messages
272
Location
GB
when i try to freeze panes in excel i want the 1st row and 1st column to stay visible; i highlight cell A1 and choose Window>Freeze Panes. but it freezes from fow 7 and column F, it does it on most sheets i don't understand why - any ideas?


quizzed
faxof
 
Sort by date Sort by votes
Choose cell B2 before freezing, as the freezing starts above and to the left of the active cell.

Glenn.
 
Upvote 0 Downvote
i think i can gracefully take the "ultimate muppet" title now

cheers
 
Upvote 0 Downvote
LOL LOL LOL LOL LOL LOL
Nah - that belongs to Cookie Monster (may he never be de-throned)

[rockband] Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JMac19
  • Locked
  • Question Question
Freeze panes on a shared workbook
Replies
0
Views
158
JMac19
JMac19
PWD
  • Locked
  • Question Question
Word 2010 With Table of Contents "Freezes up". Size 166KB
Replies
5
Views
445
macropod
macropod
mart10
  • Locked
  • Question Question
feeze panes on both sides?
Replies
2
Views
116
mart10
mart10
ladyck3
  • Locked
  • Question Question
Excel 2007 - Protected Page/Shared Workbook Freeze Panes
Replies
3
Views
118
ladyck3
ladyck3
informer30
  • Locked
  • Question Question
Freeze Pane
Replies
6
Views
229
informer30
informer30

Part and Inventory Search

Sponsor

Back
Top