Excel C1L2 Formatting

  1. Open Excel and start a new blank workbook
  2. Save your file as ExcelC1L2yourname in OneDrive.
  3. Select the range A1:E1
  4. Merge and center A1:E1. Click Home -> Click merge and center Merge and Center
  5. Type in the merged cell Backpacking Menu
  6. Change the Backpacking Menu cell to the Heading 1 style
  7. Select cell A3 and type Students Total and hit Enter
  8. Select cell A4 and type Staff Total and hit Enter
  9. Select the range A3:A4 and change it to the heading 4 cell style
  10. Select A6 and type the following data:
  11. Picture of Excel
  12. Select the range A6:B6 and merge and center it
  13. Select All of the data you typed and change to the heading 4 cell style
  14. Select A6 and change to the heading 3 cell style
  15. Select the range A12;B12 and merge and center it
  16. Select A12 and change to the heading 3 cell style
  17. Select the range A19:B19 and merge and center it and change it the heading 3 cell style
  18. Type in the following Data starting in cell A26:
  19. Picture of Excel
  20. Select All of the data you just typed and change it to the heading 4 cell style
  21. Select the range A26:B26 and merge and center it and change it to the heading 3 cell style
  22. Select the range A32:B32 and merge and center it and change it to the heading 3 cell style
  23. Autofit the width of column A
  24. Autofit the width of column B
  25. Make the width of Column C 2
  26. Select E3 and type Total People
  27. Select E3 and change to the heading 4 cell style
  28. Select the range D6:E6 and merge and center it and type Total
  29. Select D6 and change to the heading 3 cell style
  30. Type in the following data:
  31. Picture of Excel
  32. Select your data you just typed in and change it to the heading 4 cell style
  33. Save your changes and turn it your Excel File



COPYRIGHT © 2023-2024 LEARNSOFTWARETODAY.COM