cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cells

Cells

resolvedResolved · High Priority · Version 2007

Abdur has attended:
Excel Introduction course
Excel Intermediate course
Word Intermediate course

Cells

how to freeze cells?

RE: cells

Hello Abdur

Thank you for your question and welcome to the forum.

I am assuming you are referring to using freeze panes?

To use the freeze panes in Excel 2007, go to the View tab, and click the Freeze Panes button within the Windows group of buttons.

You have three options:
Freeze top row (freezes first row only)
Freeze first column (freezes left most column only)
If you have selected a cell at the intersection of the rows and columns you would like to freeze, then select Freeze Panes to freeze both rows and columns.

I hope this helps.

Kind regards
Amanda

Tue 26 May 2009: Automatically marked as resolved.


 

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

View all Excel hints and tips


Server loaded in 0.12 secs.