In order to add a hyperlink while writing in Word (or similar word processing software), highlight the word you want hyperlinked and use CTRL+K on your keyboard. More on hyperlinks to come.
Quickly indent text using the keyboard: Ctrl+M. To remove the indent Ctrl+Shift+M.
To hide a column(s) select and press Ctrl+0; to hide a row(s) select and press Ctrl+9. To hide data within cells: Change the font colour to white.
Insert a picture of any program that is not minimised: Insert > Screenshot.If you want a selective screenshot of a particular area, select the Screen Clipping link at the bottom.
Ctrl+RightArrow moves your curser to beginning of next word. Ctrl+LeftArrow moves your curser to beginning of previous word.
Ctrl+DownArrow moves your curser to beginning of next paragraph. Ctrl+UpArrow moves your curser to beginning of previous paragraph.
Firstly select all cells containing formulas in a worksheet:1. Press F5.2. Click Special, and then select the Formulas option.3. Click OK. Secondly validate data:1. Ensure cells remain selected (e.g. don’t click in the worksheet to deselect).2. From the Data tab (menu), select Data Validation or Validation…3. Select the Settings tab, and select Custom from the […]
CTRL+SHIFT+A Toggles selected text between capital letters and original case.
The 2010 Layout Quick Access Toolbar This gives quick and easy access to regularly used commands. You can add and remove commands from the Quick Access Toolbar. The RibbonThe Menus and Toolbars from earlier versions of MS Office have been replaced by ‘The Ribbon’. The Ribbon organises the buttons into Tabs and Groups. The Tabs […]