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

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.1 secs.