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
You can move to the Taskbar in Windows by pressing Windows key + T. Once focused on the Taskbar, press Alt + Enter and this will take you straight to the settings page for the Windows Taskbar. This is particularly … Read More
An easy way to insert and delete rows or columns in Excel: Press Control + Plus (Control + Shift + Equals) to bring up the Insert dialogue. Press Control + Minus to bring up the Delete dialogue. If you select a column or row … Read More