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.

All Joined Up in Excel - Great for your database

In Excel, to place in one cell a forename and surname stored in two separate cells, click on a separate cell and type in the cell references of the two names to be joined. For example,to join a
forename stored in cell B2 to a surname stored in cell A2,use the formula:‘=B2&”“&A2’. Do include the double quotes but not the single quotes (see screenshot below). Also, be sure to put a space between the double quotes if a space is needed between the words. More names or words can be added to the same cell from other cells if need be.

Collaborate, Track & Review

Click on the link below to see how you can easily work together with colleagues and others, to all contribute to and update the same document.

Collaborate, Track & Review
(Word 2003)

Typed a list in Word and can't get it to line up?

Transform tedious lists attractively with a few mouse clicks using Word 2003

Open a blank Word document and type in a list of some description – it doesn’t matter what kind of list it is, but each entry should have at least two elements in it, such as the club membership fees shown here. Separate the items with a dash (‘–’) or a Tab to open a gap between each one, as shown in the example below. As you can see, the result doesn't look very good and is hard to read. Let’s sort that out by highlighting the list and the heading, clicking the Table menu, choosing Convert and then Text to Table.

When the dialogue box opens, increase the number of columns – here it’s two – and then tell Word at what point each line should be divided into columns. It’s possible to use paragraph breaks, commas and tabs, or specify a particular character by typing it into the box. We’ve used the Tab key, so we’ll select that. To make the table look nice, click the AutoFormat button and choose a design from the list. If necessary, remove any special formats and then click OK twice to continue.

It may be necessary to fiddle slightly with the resulting table to make it look nice. For example, highlight the top line, open the Table menu and choose Merge Cells to change the top row from two columns to one. You could also use any of Word’s Table commands to change the background of rows and columns or the formatting of the text inside them. Alternatively, you could change your mind, highlight the whole thing, open the Table menu, then choose Convert and Table to Text to transform the table back into text!

Can't Open a Word 2007 Document?

Are you receiving documents with a file extension .docx? These .docx files are created by a newer version of Word - Word 2007. In order to open them, you will need to install an extra Microsoft Compatibility Pack - which is free. Click on the link to download.

Print A5 Folded Booklets from A4 Paper

You can achieve this functionality in Word with the help of a free macro. Click to download the template "Bookletsample". To use the template, click the BookletSample zip icon and download it to your pc. Save or copy this to your Documents and Settings\(Username)\Application Data\Microsoft\Templates, alternatively you should be able to do this by opening the document and then from the File Menu, select "Save As" and in the drop down window at the bottom select "Document Template". If you have any problems email: info@theawaypa.eu

For Word 2003 users, launch Word and then from the Standard Toolbar at the top, select "View" and then "Task Pane". Click on the drop down arrow and select "New Document" and then underneath "Templates" click on "On My Computer". A window will open with the new template.

Alternatively, press the start button in the bottom left hand corner of your screen and select "New Office Document". A window will appear containing the new template.

For Microsoft Word 2007 users, pick "My Templates".

Click on the template and you will see a 4 page document appear. The pages are numbered consecutively but please note that page 1 is in essence the back page of the booklet and page 2 the front page. Pages 3 and 4 are the inside pages. If you need to increase the pages, they must be in muliples of 4.

Useful Windows Shortcuts

Here are some keyboard shortcuts to improve your speed when working in Windows:

Ctrl+b = applies bold formatting to selected (highlighted) text
Ctrl+i = applies italic formatting to selected (highlighted) text
Ctrl+c = copy selected (highlighted) text
Ctrl+v = paste selected text
Ctrl+p = send document to print
Ctrl+n = start new document
Windows key+m = minimise all open windows | Windows key+Shift+m = restores all windows
Windows key+d = return to desktop

Access Hotmail in Outlook

Webmail accounts are convenient but there are times when you want to use a proper email program. Windows Live Hotmail and Office Live Mail accounts cannot be accessed in this way without a paid subscription, unless you download the Outlook Connector for Outlook.

Installation is simple, although you will need to validate your copy of Office (this tool now works with both Internet Explorer and Firefox). Once installed, it appears as an extra menu in Outlook. Enter the account details as well as the name you want to appear on the emails and Outlook will download the emails. It is possible to set up several accounts.

Click on the Outlook Connector menu and then on Add a New Account. Enter the email address and the password used to access it. It is also a good idea to put your name in the text box below as this is what people will see rather than an address that might not be very descriptive. Click on the OK button and Outlook can now read your Hotmail or Live account.

DOWNLOAD OUTLOOK CONNECTOR

Translate with Word

There is no need to pay for translation software if you already have Word 2003 as it can translate into 14 different languages.

When you have finished your document, select all the text by pressing Ctrl and A together. Press shift and F7 together to open the Research Task Pane Click in the down arrow in the second text box down and select

All Reference Books

Click on the small plus symbol next to Translation and then select a different language in the To section.

A translation appears below and this can be copied and pasted into another document. Alternatively, click on the Green Arrow in the Task Pane to see the translation in a web browser window.

NICE PAD

It's possible to make "Notepad" (you'll find it in your Windows Programs) add timestamps to information. This is a useful feature to keep track of messages or notes while surfing.

Begin by launching Notepad (from the Start Button, point to "All Programs" then "Accessories" and click "Notepad".
Now, in the first line type a full stop followed by LOG (in capitals) and press Return. Save the file with a suitable name, eg "Mynotes" and place a shortcut on the Windows Desktop or Taskbar for future use.

When the file is next opened the date and time will be added to the end of the log, which serves as a timestamp for the next entry!

Attach Extra Details to Digital Photos

It can be very useful to have some information on a digital photo, such as the date it was taken, it's title and the name of the photographer. Microsoft Pro Photo Tools is a program that makes it possible to edit and create metadata (information that can be added to digital photos). This is free and can help to organise a large image collection. To download the tool from Microsoft CLICK HERE

If you need any help with learning how to use the program, go to: WORKSHOP