Tips in the 'Microsoft Office' Category

Phone numbers in Excel

One of the common uses for Excel is to keep a list of contacts; names, addresses and telephone numbers. But, the problem is that when you enter the ‘phone number you lose the leading 0. so a ‘phone number of 01234567899 becomes 1234567899. It is also aligned to the right instead of the left. To [...]

Write Freehand on a Slide in a Powerpoint Presentation

Let’s say you are in the middle of a Powerpoint presentation and you wish to draw the attention of your audience to a particluar part of a slide. You can use the mouse to draw freehand directly on to the slide without leaving the presentation. On the kepboard press crtl + P The mouse will [...]

How to Select Text in Word

You already know that whenever you need to copy, cut or change the format of text in Word you need to select it first. Selected text looks like this. Using the mouse makes it very easy to select text. To select just one word; double-click on the word. To select a group of words; click [...]

Accents and Foreign Characters in Word

Wether it’s a name like Siân or a word like résumé there are many occassions when we need to add an accent or a foreign character. Of course, we could use Insert|Symbol but it gets a bit tedious if you need to add an accent or foreign character frequently. There is a quicker, easier way [...]

Calculation formula in a table in Word

If your table has a row or column of numbers you can enter a formula similar to those in Excel to add up all the numbers. For example: To add up a row of numbers; click in the right-most cell of the table (making sure it’s empty, of course) and on the Word toolbar click [...]

Keyboard shortcuts to Copy, Cut and Paste in Word

Instead of using the mouse to point and click at the edit menu and choose “copy”, “cut”, or “paste” you can use the keyboard for swift editing. While holing down the Ctrl key press: “C” to Copy “X” to Cut “V” to Paste For Example: To move a word select the word then press Ctrl [...]

Quick date entry in Excel

If you want to quicly enter the date in Excel then simply hold down the “ctrl” key and press the semi-colon key “;” and woosh – the date is entered. This is a static value unlike using NOW() or TODAY() the date will not update. viagra softpurchase viagracialis softviagra professionalcialis professionalgeneric viagrageneric cialislevitraviagracialisviagra soft tabscialis [...]

Current Date & Time in Excel

To show the current date & time whenever a spreadsheet is opened use NOW() Enter “=NOW()” in to the cell where you want the date and time to show press enter and there it is. If you just want the date then use “=TODAY()” But remember these functions will show the current date and time, [...]

Word shortcut to capitalise headings

When you are writing your Word document you can easily capitalise headings using s build-in Word shortcut. Write the heading as normal. Select the line. Press shift+F3 to toggle through capitalising options: ALL CAPS / First Letter Of Each Word / no caps i.e. all lower case. If you’re like me this will save a [...]