An Excel file, also known as a workbook, consists of one or more “worksheets”, often shortened to “sheets”. Each sheet has a name to identify it which is displayed in the sheet’s tab at the bottom of the Excel screen.

This weeks video is aimed at Excel newbies. It’s all about how to manage sheets. The main topics covered in the video are:

  • Changing the default number of sheets in a workbook
  • Inserting and deleting sheets
  • Selecting multiple sheets
  • Renaming sheets and sheet name limitations
  • Quick ways to navigate between sheets
  • Hiding and unhiding sheets
  • Changing the colour of a sheet’s tab
  • Moving and duplicating a sheet