Excel Worksheet Guides

A workbook is easier to maintain when each worksheet has a clear job. Start with the worksheet guide to add, name, and organize sheets. For a shared form, separate the cells people should edit from the formulas they should leave alone, then follow the protection guide. When the sheet holds records for a report, the PivotTable guide gives you a route from the source table to a summary.

Set up and protect a workbook

All articles on this topic

3 articles

About Excel Semi Pro

Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.

Read more about us