by John MacDougall | Feb 10, 2017 | Tips
7 great keyboard shortcuts for selecting cells quickly. Shift + Arrow Keys – Expands the selected range in the direction of the arrow key. Shift + Spacebar – Selects the entire row or rows of the selected range. Ctrl + Spacebar – Selects the...
by John MacDougall | Feb 8, 2017 | Tutorials
What Is A Worksheet? A worksheet is a collection of cells where all your data and formulas are stored. Each cell can contain either data (numeric or text) or a formula. Cells are arranged in rows and columns in the workbook. Rows are labelled with...
by John MacDougall | Feb 7, 2017 | Tips
If you’ve ever had a long list of inputs/outputs in your workbook and wanted to give them defined names based on their labels, then this is a tips you’ll definitely want to learn as it’s a lot quicker than naming them individually using the...
by John MacDougall | Feb 6, 2017 | Tutorials
What Is The Formula Bar? The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its...
by John MacDougall | Feb 4, 2017 | Tips
Did you know you can change formatting for individual characters in a single cell? You can change formatting such as the font type, font style, font size, underline, strike-through, superscript, subscript or font colour for any part of the text in a cell. ...