From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Renaming, inserting, and deleting sheets
From the course: Excel 2016 Essential Training
Renaming, inserting, and deleting sheets
- We're looking at a workbook called 09 - 02 - RegionalSales. We're looking at an East sheet, I'll click the Midwest sheet, same layout. South, West, an empty Sheet1, empty Sheet2, and the Sheet3 which still has the generic name Sheet3. We can easily rename sheets. One way is to right click a Sheet tab and then Rename and at that point we can start typing. But it's simply faster to double click it. Let's double click Sheet3 and call it performance scores or annual scores. You can have spaces in a Sheet tab name. You can use up to 31 characters, Annual Scores. When you use formulas that refer to sheet names, those that have spaces in them, also use automatically imbedded single quotes. It might make some formulas look a little bit more complex but there's nothing really wrong with the space in a sheet name and sometimes it improves readability. Again, change a sheet name, simply double click and start typing. We can also insert a sheet at any time and there are some quick ways to do…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.