Web site scrolling – tired of using a mouse?

• Press the SPACEBAR to go Down one page
• SHIFT + SPACEBAR to go Up a page

Works on all web browsers!

Web Browser keyboard shortcuts a full comparison chart – Excellent stuff!!

Microsoft Word Tips

1. Hold Ctrl and press Backspace – delete entire words at a time

2. Type three hyphens and press enter and you get a horizontal line

3. Shift + F3 to change case between lower/upper/capital

4. File, Protect Document, Mark as final, makes it read-only

5. Ctrl + E – Center paragraph

6. Shift+F5 – Switch to where the cursor was last time you saved a document

7. Select vertical text – press/hold Alt before you click and drag!

8. Ctrl + Spacebar – Remove All Formatting

Excel Tables will override local formatting however local formatting is preserved by default even if you apply a style.

You can override this by: Right-click any style and choose “Apply and Clear formatting“.

Excel – To create tick marks and crosses quickly type in the following:

Capital O = cross

Capital P = tick

Then format both the O & P to Wingdings2 font.

Colour the tick green and the cross red – Job done!!

Excel – Hide formulas
Home, Format, Format Cells, [Protection] tab, tick Hidden box, OK.
Home, Format, Protect Sheet, apply password if needed, OK.