MS Office Tips & Tricks
This page will provide useful tips and tricks in MS Office and other applications.
You could also subscribe to our Tips and Tricks RSS feed. Select your preference below
Closing all your Excel files down in one go in Excel XP and 2003Hold the [Shift] key down and select the file menu. Menu changes from Close to Close All |
|
 |
|
Moving between Open Documents in Excel, Word, PowerPoint, Visio and Project.Control [F6] cycles through the documents. If you miss your file just choose Shift Control F6 to go backwards |
|
|
|
Question: What was the first Number plate in the UK?Answer : it is widely thought to have been A1. the first number plate issued in Britain. Although undoubtedly the first alphanumerically, and certainly the first issued by London, evidence shows that other authorities started issuing registrations slightly earlier than London.Earl Russell, amongst others, queued all
night outside the London County Council
offices in the hope of having A 1 assigned
to his vehicle. |
|
|
|
Question:Who is allowed on the public highway in the UK without a car registration?Answer:<br />The Royal family |
|
|
|
Short Key for Chart in ExcelHighlight the information you want to include and then Press [F11] |
|
|
|
Short Key for Spell Check in All Microsoft ApplicationsJust Press F7 General information about the company, it's suits etc. Use the button to Add another software group |
|
|
|
Quick Copy TechniquesIn almost all MS Office and Windows applications, you will be able to create a copy of something by using the drag and drop technique. This simply involves keep the CTRL key down when dragging.Excel Exmaple : To make a copy of a worksheet in Excel, keep your CTRL down and drag and drop the worksheet to it's new position. PowerPoint Example: On a PowerPoint slide, keep your control down when dragging a shape or text box. Word Example : Select a text paragraph. Keep CTRL down and drag the selection to it's new position in the document. This will create a copy of the paragraph MS Windows Example: When moving files using WIndows Explorer , keep CTRL down when dragging the file to it's new folder or even the same folder. This will create a copy of the file. |
|
|
|
Closing down MS Office filesTo close down a file in MS Office, press CTRL+w or CTRL+F4 |
|
|
|
If you would like to select all cells on a spreadsheet of a certain type, e.g. All cells that contain a formula or all cells that contains text, you should make use of the GoTo Special feature in Excel. |
|
|
|
Excel Selection - Finding Special Cells
Our Training Services
