Excel training
First written: Feb-2024
last changed Mar-2024
last changed Mar-2024
Adding a text to cells
Here we will add a new column f text values, with a heading cell value of “Text”, and on every cell on this column (below the heading) we will have text reading [something like] “Lorem Ipsum Delor Sit Amet”
- click on
G2
and type "Lorem Ipsum Delor Sit Amet"; note the resulting cell formatting. - Undo this using [CONTROL]-Z
- click on the input field at the top of the worksheet and type in "Lorem Ipsum Delor Sit Amet"; note the cell formatting
- Drag this cell value down so that all rows (
G2
toG21
) are the same - Make this column have “wrapped text” enabled by mouse right-clicking on the selected cells, then select Format Cells... from the popup menu; then select the Alignment tab and the Wrap text checkbox.
- Double click on the right of the
G
column header to auto-adjust the width to fit the content - then add drag the column width slightly wider to add a few centimetres to the adjusted size.
chevron_leftStep-12-applying-Conditional-Formatting
Step-14-adding-an-AVERAGEchevron_right
Comments
New Comment