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
- Organize Excel worksheets
Work with sheets and arrange your workbook around its tasks.
- Lock formulas and keep inputs editable
Protect an order form while leaving the entry cells available.
- Summarize a worksheet with a PivotTable
Turn a table of records into a report you can explore.
All articles on this topic
3 articles
How to Lock Cells in Excel and Keep Input Cells Editable
Unlock the input cells, leave formulas locked, then protect your Excel worksheet. Follow an order-form example with Windows, Mac, and web instructions....
Excel Worksheets: A Beginner's Guide
Want to start using Excel worksheets? With this guide, you can get a basic understanding of what worksheets are and how to make them work for you....
Pivot Tables (PV Table): Everything You Need to Know
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...
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