Excel training
First written: Feb-2024
last changed Mar-2024
last changed Mar-2024
Add a Column to hold Names
- Mouse right-button click on cell
B1
(or any B cell) - Select Insert... from the floating menu
- Alternatively you could right-button click on the column header
B
at the top of the column and select Insert- Select Entire column from the selected Insert menu
- Type in some names into the new column (the actual names are not important, but you can clipboard the following list and paste them in if you wish)
- Eddie
Matthew
Richard
Martin
Jamie
Callum
Luke
Tom
Trevor
Alex
Charlie
Ellis
Jonny
Mario
Courtney
Lewis
Joe
George
Sam
Kyle
- You can make the formatting on this new data by clicking on the
A1
cell, and then the Format Painter (paintbrush) icon from the Clipboard ribbon .... then swipe (hold the left mouse button onto cellB1
and then drag) this from cellB1
toB20
chevron_leftStep-3-add-column-totals
Step-5-add-column-headerschevron_right
Comments
New Comment