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

excel consultant - zoom

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Zoom

excel consultant - Zoom

ResolvedVersion Standard

Ludmila has attended:
Excel Intermediate course

Zoom

how to zoom in and out on a large worksheet and using the freeze panes command

RE: Zoom

Thanks for the question Ludmila. If you have a scroll wheel on your mouse try this; To zoom in and out quickly press and hold the CTRL key and then use the scroll wheel to zoom in and out. Hope that answers that part of the question.
Not too sure what you want on the freeze panes command, but to freeze an area you would choose a point on the spreadsheet where you wish to freeze the columns or rows to the left or above the chosen cell and go to the Window Menu command and choose Freeze Panes, to remove the Freeze, Go to Window, UnFreeze Panes. Hope that helps.

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

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