Can I freeze pane a whole sheet in Excel?

  Willow12 00:38 21 Jan 2006
Locked

I have an active excel spreadsheet for detailing my month by month poker ups and downs! ;)

In general terms I use a sheet for each month (11 sheets so far) but have a "notes" sheet as the first sheet for various reasons. Is there a way of "freezing" this sheet so that is does not disappear off of the left hand side of the screen when I am working on the current month. Just a way to save my having to kick all the way back to the beginning of the book when I jump between the two?

Quite a trivial matter I know but I would appreciate it if somebody could inform me if this is possible.

  VoG II 08:49 21 Jan 2006

If you right click in the arrows, bottom left you will get a pop up list of the sheets like click here

Does this help?

  mgmcc 13:16 21 Jan 2006

You can also "drag" the tab for the first "notes" sheet to move it next to the sheet that you are currently using.

  VoG II 13:23 21 Jan 2006

You can use Window|New Window then use the Window menu to swap between them - one window looking at one sheet and the other window a different sheet.

  Willow12 13:56 21 Jan 2006

Thanks guys enough there to stop me being completely lazy! Many thanks.

Willow12

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?