excel in courses - excel intermediate

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Excel outlines

excel in courses - Excel outlines

resolvedResolved · Low Priority · Version Standard

Emily has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

Excel outlines

Outlines, why use them? When you could maybe hide or freeze?

RE: Excel intermediate

Hi Emily

Thank you for your question.

To explain the difference between some of these features:

Freeze panes is used when you want sections of your screen to remain in place when you scroll through your spreadsheet (for example, you want to be able to see headings for your rows or columns when you scroll).

Hiding is used to temporarily 'hide' columns or rows of data from your spreadsheet. This may be for viewing or printing purposes, e.g. if there are only certain columns of the spreadsheet that someone wants a print out of.

To bring hidden columns or rows back, you can 'unhide' them.

Outlining also allows you to hide and unhide columns or rows of data, but instead of selecting the columns or rows and selecting the Hide or Unhide option, it gives you a little symbols and numbers that are visible at the top and left side of the screen that you can use to control the visibility of data. So using an outline is sort of like a shortcut to hiding and unhiding data.

I hope this makes sense.
Amanda

RE: Excel intermediate

Hi Amanda,

Thanks for your reply. I tried to print out the notes from the CD this weekend but there does'nt seem to be anything on the cd? Did anyone else have that problem?

RE: Excel intermediate

Hi Emily

I haven't heard from anyone else who has had the same problem, but I can either send you a zipped folder which contains the CD content, or I can arrange to have another CD mailed to you. Which would you prefer?

Amanda

RE: Excel intermediate

Thanks for your reply. I would love to have the CD mailed to me, if thats ok?

My address is 13c Healey Street, London NW1 8SR.

Thanks for all your help.

Emily

RE: Excel intermediate

Hi Emily

No problem I will arrange to have this done.

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:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Server loaded in 0.12 secs.