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
D1
add the heading label "Salary" - Click on
C1
, then click on the paintbrush icon to copy the formatting from the selection - then click onD1
- In
D2
type in=A2*C2
- Drag the bold green dot seen in the cell border from
D2
toD21
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