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

excel

ResolvedVersion 2007

Marlene has attended:
Upgrade to Office 2007 course

Excel

how do you freeze panes

RE: Excel

Hello Marlene

Thank you for your question and welcome to the forum.

To freeze panes, go to the View tab, then click the Freeze Panes button. You have options to freeze the top row, or first column, or at a desired point in the spreadsheet where you can view both rows and columns when scrolling.

Kind regards
Amanda

Mon 23 Feb 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Copying From Websites

If you find some interesting text on a website that you wish to use and adapt in your wordprocessor or other package, highlight and copy in the normal way first.

When you paste though, use the Paste Special option to insert as unformatted text. That cuts out all the fancy formatting and hyperlinks that may be embedded.

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.