Microsoft® Excel® 2010 Plain & Simple

Chapter 5. Managing and Viewing Worksheets

In this section:

• Viewing and Selecting Worksheets

• Renaming Worksheets

• Moving Worksheets

• Inserting and Deleting Worksheets

• “Inserting and Deleting Columns, Rows, and Cells”

• Hiding and Unhiding Columns and Rows

• “Freezing Worksheet Rows and Columns”

• “Splitting a Worksheet into Independent Areas”

• “Saving Custom Worksheet Views”

After you build your workbook, you can reorganize it as needed. If you use data in a specific worksheet often, you can move the worksheet to the front of the workbook. Similarly, if you often switch between two worksheets, you can put their sheet tabs next to each other so that you don’t have to spend as much time moving from one worksheet to the other. Another way you can ...