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

Freezing rows

Here we are using the View toolbar menu to freeze the top row of the sheet - making that row stay in place regardless of how you scroll down the window.

  1. Select the first heading row by clicking on the row number 1 (you should see the whole row selected in a grey and with a green border.

  2. Select the View menu ribbon

  3. Select Freeze Panes on the Window tab of the View ribbon

  4. Select Freeze Top Row on the given menu

square