From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Renaming, inserting, and deleting sheets

Renaming, inserting, and deleting sheets - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Renaming, inserting, and deleting sheets

We're using the workbook 09-02-RegionalSales. The sheet names are appropriate except for Sheet3 and so changing the name of the sheet is something you want to be able to do quickly and easily. You can access many features related to sheet tabs simply by Right-Clicking a sheet and that brings up a menu. Here, of course, is a choice for Rename. It's much faster, however, simply to Double-Click a sheet tab. This Sheet3 for example contains Annual Performance Scores. It contains some sparklines in column H . Let's just change the name of it by Double-Clicking and we could type anything we want. Why not Annual Scores? You can have spaces in sheet names. They can be up to 31 characters. Simply type in the name you wish and press Enter. If we need to add a new sheet, we can simply Right-Click and we're about to insert a new sheet. If we choose Worksheet here and then OK, a worksheet just to the left of the sheet that had been selected. But there are two faster ways, if we want a new sheet to…

Contents