Shrink to Fit

It is very frustrating when your Word document is just too large to fit on one page. One solution is to adjust the page margins, but this can cause problems if you open the document on another computer. Luckily, Word has the answer.

Click on the File Menu and then on Print Preview. Left click on the 3rd icon from the right. If you are not sure which icon is the right one, hold your cursor over them in turn until you see the "Shrinki to Fit" tooltip.

Word will now shrink all the fonts in the document, hopefully making it fit on one page. It is possible to undo the change but only before you close the document. If the Print Preview toolbar does not appear in the window, right click an empty area to the right of the menus and then left-click on the Print Preview Option.

Popular Excel Shortucts

Click the image to view

Watch how to create a drop down list in Excel

..
Sample File

Using the "Spike Feature" in Word - Beyond Cut & Paste

One of the problems with the standard Cut and Paste functions in Microsoft Word is when there are multiple pieces of text to move. An answer to this problem can be found in the spike feature. This allows documents to be moved to a virtual ‘spike’, where they are stored in readiness to be pasted elsewhere. To move some text to the spike, first highlight the words and then hold down the Control (Ctrl) key before tapping F3. The text disappears to the spike. Now repeat for the other text passages that need to be moved. Next, position the text cursor at the point in the document where you want to put the spiked text, and hold down Shift and Control while once more tapping F3. All spiked items will be pasted en masse, in the order they were copied.

Mixed Cell Formatting in Excel

In Excel spreadsheets, it is possible to use more than one text size, colour or style in the same cell, to emphasise, show secondary information or just to save space. To achieve this, first click in the cell concerned and press the F2 function key to go into cell-editing mode. Now highlight only the text to be altered and from the Formatting Toolbar, select different style, size or colour. Press the Enter key to finish and check result. Repeat the process to change results. To force text onto a new line within a cell, hold down the Alt key and press the Return key.

The Magic of F4

In Microsoft Office, the F4 key can be used to repeat the previous action on another selected item. The computer remembers the last action you carry out so, for example, if you’ve just highlighted a word in bold and want to do the same to another one straight afterwards, simply click somewhere in the next word and press F4 to embolden it. This also works when formatting cells in Excel,
text or bullets in Word, or drawing objects anywhere across the Office workspace.

dot com control - web addresses on the quick!

When typing in website addresses beginning in ‘www’and ending in ‘.com’there is a useful
keyboard shortcut.

Instead of typing the whole web address,such as ‘www.msn.com’, just type ‘msn’and hold down the Ctrl (Control) key when you press Enter. In Internet Explorer and some other web browsers, the rest of the address will be filled in automatically.