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

excel training onsite - freeze panes

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Freeze Panes

excel training onsite - Freeze Panes

ResolvedVersion Standard

Mike has attended:
Excel Intermediate course

Freeze Panes

How do I freeze an amount of rows in the middle of a worksheet, so not including all rows to the top of the worksheet?

RE: Freeze Panes

Hi Mike

Thanks for your question.

Would creating a split in the Excel window help? If you select the cell in column A in the first row that you wish to remain static on your screen, then go to Window - Split....does this help?

Amanda

 

Training courses

Training information:

See also:

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.

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.28 secs.