Word – Using the TAB key in Outline Numbering and Bullets When creating Multilevel and Bullet lists you can move up and down the levels using the TAB and SHIFT TAB keys. Bulleted List: Inserting the first bullet positions your list at Level 1 Pressing the TAB key demotes the list to Level 2 with […]
Excel does not have the same options as Word to change text case. However, it doesn’t mean you can’t change text case it just means you use a different method to do it and this is by using functions. PROPER Will capitalise the first letter of each word UPPER Will change all letters to upper […]
Find– Using wildcard characters You can use wildcard characters in the Find and Replace feature in Excel to search for particular numbers or text. Two of these are the asterisk (*) and the question mark (?). The asterisk (*) can be used to find any string of numbers e.g. 1*1 will find 101, 1231 and […]
Headers and Footers – Changing page numbering on page 2 to start at 1 (Word 2013) Open or create a document that contains, at least, 2 pages of text. Select the Insert tab and select the drop-down arrow next to Page Numbering. Hover the mouse cursor over “Bottom of Page” to display the layout options […]
If you require duplicate data entered into a number of cells that are adjacent to each other – you can do this quickly and easily.
When entering repetitive text in Excel there is a keyboard shortcut that can help speed up the process.