Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Editing Worksheets

This guide will show you the basics of editing sheets such as changing names and copying sheets.

Renaming

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To rename a sheet, right-click the sheet name.
  3. Select Rename from the pop-up menu.
  4. Type in the new name. Press Enter.

Inserting

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To add a sheet to the right of the sheets, select the + sign.
  3. To add a sheet to the left of any of the sheets, right click the sheet which should be pushed to the right.
  4. Select Insert Sheet from the pop-up menu.

Deleting

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To delete a sheet, right click the sheet.
  3. From the pop-up menu, select Delete.

Moving

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To move a sheet, right click the sheet name.
  3. Select Move or Copy.
  4. Select the target destination. This can be in the same workbook or another workbook.

Copying

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To copy a sheet, right click the sheet name.
  3. Select Move or Copy.
  4. Check the checkbox by Create a Copy.
  5. Select the target destination. This can be the same workbook or another workbook.

Grouping

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To group sheets, Shift + Left-click the sheet names which should be grouped.
  3. When sheets are grouped, any change made to one grouped sheet will occur in the rest of the grouped sheets. 

Ungrouping

  1. Navigate to the worksheet list at the bottom of the Excel window.
  2. To ungroup, right-click on the sheet name.
  3. Select Ungroup Sheets from the pop-up menu.



If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or helpdesk@uwosh.edu




Keywords:sheets, "Workbooks & Worksheets", "Deleting sheets", "Renaming sheets", "Inserting Sheets", "Copying Sheets", grouping, ungrouping   Doc ID:65958
Owner:William W.Group:UW Oshkosh
Created:2016-08-10 14:12 CDTUpdated:2016-08-10 14:57 CDT
Sites:UW Oshkosh
Feedback:  0   0