cpt 1

• Autofit


  • Enables the column width to automatically fit the contents
• Wrap Text command


  • Places the text into multiple lines in a single cell
• Merge command


  • Combines the contents of the selected cells in a new larger cell
• Merge & Center drop-down options

  • Merge & Center
  • Merge Across - merges selected cells in the same row into one (1) larger cell
  • Merge Cells
  • Unmerge Cells - splits the current cell into multiple cells
• Auto Fill feature


  • Used to fill cells with data that follow a pattern or are based on data in other cells
• Static date/time


  Does not change when the worksheet is recalculated or opened
• Dynamic date/time


  Updates when the worksheet is recalculated or opened
• Inserting a static date

  Press Ctrl + ; (semi-colon)
• Inserting a static time

  Press Ctrl + Shift + ; (semi-colon)
• Inserting a dynamic date

  Type =TODAY() in the formula bar
• Inserting a dynamic date and time

  Type =NOW() in the formula bar
• Formatting date or time


  • Choose from a list of date formats
  • Create a custom date format
• Comments


  • Used to add notes to individual cells and give reader additional context for the data it contains
• Comment indicator


  • A red indicator appears in the corner of the cell when a cell has a comment
• Comment actions

  • Add, edit, and delete a comment
  • Format a comment
  • Change the shape of a comment
  • Move or resize a comment
  • Copy comments to other cells
  • Display or hide comments and their indicators
  • Change the default name that is displayed in new comments
  • Review all comments in a workbook
  • Print comments
• References: Parsons, J., Oja, D., Carey, P., and DesJardins, C. (2017). New perspectives Microsoft Office 365 & Excel 2016. USA: Cengage Learning.
• References: Office 365 Training Center. (2018). In Microsoft Office. Retrieved from https://support.office.com/en-us/office-training-center