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

Set Print Area - Printing On One page

  1. On your worksheet, select what you want to print as a page

  2. Select the Page Layout menu option, followed by Print Area - then Set Print Area

  3. Select Print Titles from the same ribbon - then go to the Header/Footer tab and select your page numbering preference

  4. On the File menu, select Print - then set your page setup to Fit Sheet on One Page