OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topic VLOOKUPsAdvanced Topics Pivot Tables
Excel training
First written: Feb-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

  1. click on G2 and type "Lorem Ipsum Delor Sit Amet"; note the resulting cell formatting.

  2. Undo this using [CONTROL]-Z

  3. click on the input field at the top of the worksheet and type in "Lorem Ipsum Delor Sit Amet"; note the cell formatting

  4. Drag this cell value down so that all rows (G2 to G21) are the same

  5. 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.

  6. 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.

square