Excel training
First written: Feb-2024
last changed Mar-2024
last changed Mar-2024
Adding calculations
Here we will add a column D to multiply cells in C with those in A
- on cell
D1add the heading label "Salary" - Click on
C1, then click on the paintbrush icon to copy the formatting from the selection - then click onD1 - In
D2type in=A2*C2 - Drag the bold green dot seen in the cell border from
D2toD21
This results in a table that may not have enough space to show the values in column D - the value ###### is shown where the number does not fit....

- Move the mouse cursor to over the right side of the column D header so that the icon changes to
; then double click at this point to auto-fit the column width replace any ### values in the column with the actual value. 
chevron_leftStep-7-freeze-the-column-headings
Step-9-add-a-conditional-formulachevron_right
Comments
New Comment