Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Freeze panes

microsoft excel courses - Freeze panes

ResolvedVersion Standard

Thu 26 Apr 2007, 09:46 Delegate Sarah said...

Sarah has attended:
Excel Intermediate course

Freeze panes

How do I use the Freeze Panes command?

Thu 26 Apr 2007, 10:58 Trainer Tracy said...

RE: freeze panes

Hi Sarah,

Thanks for the question.

For the freeze pane command it will depend on where your cursor is on the spreadsheet as to which section the computer freezes. If you highlight a row, Excel will freeze everything above the row, if you highlight a column Excel will freeze everything to the left of the column. If however you highlight a cell Excel will freeze everything above and to the left of the column.

Hope that helps, if there is anything else please let me know

Enjoy your training

Tracy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

microsoft excel courses - Freeze panes

Freeze panes

RE: freeze panes

Excel articles

Excel tip:

Hide data in Excel Worksheets