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

excel training courses - freeze cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Freeze Cells

excel training courses - Freeze Cells

ResolvedVersion Standard

Matthew has attended:
Excel Advanced course

Freeze Cells

Can you freeze more than one set of cells when moving around a worksheet? ie a Header row but also a seperate coloumn?

RE: Freeze Cells

Hi Matthew

Thank you for your question.

To the best of my knowledge, the Freeze Panes option can only be used at one location/position in a spreadsheet, you cannot have multiple Freeze Panes.

Amanda

Excel tip:

Quick Zooming in Excel with rollerball mouses

To zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time.

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.