excel consultant - zoom

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

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

excel consultant - Zoom

resolvedResolved · Low Priority · Version 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.

 

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:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Server loaded in 0.11 secs.