Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using Freeze Panes

Using Freeze Panes

ResolvedVersion 2007

Thu 10 Nov 2011, 17:39 Delegate Karen said...

Karen has attended:
Excel Intermediate course
Excel Advanced course

Using Freeze Panes

Help! Its only a day after my course and I've forgotten how to complete no. 2 of Unit 1 Practice Activity. I manage to freeze rows 1-5 but when freeze column A, rows 1-5 unfreeze and vice versa.

Fri 11 Nov 2011, 13:53 Trainer Anthony said...

RE: Using Freeze Panes

Hi Karen, thanks for your query. Try selecting cell B6 and then freezing the panes. Here's all the information you need about freezing those panes!

http://spreadsheets.about.com/od/exceltools/ss/81027freezepane.htm

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Using Freeze Panes

Using Freeze Panes

RE: Using Freeze Panes

Excel articles

Excel tip:

Transpose text