C
- Cell Navigation Pane
- The cell navigation pane is a little area to the left of the formula bar and above the columns headers. It shows which cell you have currently selected. If you would like to navigate to a specific cell further away from the cell you are currently in, click into the cell navigation pane, enter the cell name and press enter. Excel will automatically bring you to that cell. See post The Different Areas of a Spreadsheet
- Cells
- The cells are the rectangles with the light grey borders you see across every spreadsheet. This is where the action takes place as those are the areas that contain all the content a user puts into the spreadsheet.
Each cell has a unique name containing the column header letter and the row number. See post The Different Areas of a Spreadsheet
- Columns
- Columns go vertically across the screen from top to bottom. On the top you’ll see the column headers, labelled alphabetically with capital letters. Once the alphabet is exhausted, the columns continue with two letter names, followed by 3 letters. Currently there are 16,384 columns, with XFD being the last one to the right. See post The Different Areas of a Spreadsheet
F
- Formula
- In Excel the term formula is used for any type of formula you make up manually. Formulas should still contain cell references as this will allow Excel to recalculate the result whenever you make adjustments in a cell. The counterpart of formulas are functions.
- Function
- Functions are build-in features in Excel (and other spreadsheet applications). Compared to formulas, functions allow for easier and more advanced spreadsheet manipulation. An example of a function is =SUM(), which will automatically sum up the numbers or cell references within the brackets. As long as you use cell references, Excel will automatically update the result.
R
- Rows
- Rows span across the screen horizontally, from left to right. On the left hand side of your screen you find the row numbers, starting from 1. At the time of writing this, Excel allows for a staggering 1,048,576 rows! See post The Different Areas of a Spreadsheet
S
- Sheet Tabs
- Each worksheet has its own tab which is located in the tab bar at the bottom of your Excel window. These tabs are used to navigate between different worksheets. See Posts with Tag Worksheet Tabs.
W
- Worksheet Tab
- Each worksheet has its own tab which is located in the tab bar at the bottom of your Excel window. These tabs are used to navigate between different worksheets. See Posts with Tag Worksheet Tabs