If you have several worksheets in an Excel workbook, you will need to switch between them to view your data. To focus on a different worksheet, press Control + PageUp for previous sheet, or Control + PageDown for the next sheet.
To move or copy a worksheet, position on the worksheet and press Alt + H, then O, then M for Move. Use the Up and Down Arrow keys to move to the new position (choose the sheet that will be after … Read More
A worksheet is a collection of cells within an Excel file. Worksheets allow you to organise and manipulate different sets of data. Each Excel workbook can contain multiple worksheets. For example, you could have a worksheet showing data for each … Read More
A worksheet is a collection of cells within an Excel file. Worksheets allow you to organise and manipulate different sets of data. Each Excel workbook can contain multiple worksheets. For example, you could have a worksheet showing data for each … Read More
You can get Excel to recalculate formulas and functions in all open workbooks, or just in one worksheet in a workbook. Press F9 to recalculate formulas in all open Excel workbooks. Press Shift + F9 to recalculate formulas in the active worksheet. … Read More
The formula bar in Excel is above the spreadsheet, under the Ribbons. It displays the contents of the current cell. If the current contents is a result of a formula/function, it actually displays the formula/function. If there is a lot … Read More
When using formulas (and functions) in Excel, the result is displayed in the cell, as opposed to the details of the formula/function. You can change this by pressing Control + Grave (`). The Grave key is next to the number 1 … Read More
You can get help putting together a function by pressing Shift + F3. This gives you the Insert Function dialogue box where you can search for a function, choose the function and put in the details. Use Tab to move … Read More
One of the most powerful aspects of Excel is the ability to do formulas and functions. And the most popular function has to be SUM. SUM is used on a range of cells, in a row or column, to calculate the … Read More
It can be very fiddly to manually adjust the height and width of a cell in an Excel spreadsheet with the mouse, and pretty much impossible with the keyboard. It is also difficult to know what the size of a cell should … Read More