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.

Image 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 ...

Get Office 2013 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.