Office 2013 In Depth

Working with Worksheets

We had the opportunity to look at the various views that can be used when you are examining a sheet in Chapter 11, “Requisite Excel: Essential Features.” There are also some other tricks related to viewing sheets that can help you when you are working with large sheets that contain many columns or rows or in cases when you want to see two disparate parts of the same large sheet at the same time. As with columns and rows, you can also hide sheets if needed.

For more information about viewing Excel worksheets, see “Viewing Worksheets,” p. 323.

Freezing Rows and Columns

Adding data or just viewing the data can be problematic ...