Web site scrolling – tired of using a mouse?
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.