In this video, learn how to use freeze panes to freeze on columns and/or rows to ensure you're always able to see necessary labels or data as you scroll through large amounts of data, or when you're zoomed into data that no longer fits on a single screen.
- [Instructor] You may recall from an earlier movie…that every sheet in your Excel workbook here in Office 365…has over one million rows…and over 16,000 columns of space to work with,…and you may never fill up a sheet…but there will be times when you have too many rows…or columns to view on one screen…and you'll need to use your scroll bars…to scroll left and right and up and down,…which can make it difficult to line things up.…For example, if you have labels like we do here…in our Red30 Projected Revenues sheet…and down the left hand side,…if we're not able to line those up,…it's difficult to know what we're looking at…and that's why this next feature comes in so handy.…
It's called freeze panes.…It also comes in handy when you're zoomed in.…Our Red30 Projected Revenues workbook here,…R30Revenues0205, if you're catching up…is not all that extensive,…but if we go down to the zoom slider…and click the plus sign a few times…up to 150, for example,…we can no longer see those labels down the left…for our location so we're not really sure…
- Explore efficient methods for adding functions and formulas.
- Format text, numbers, dates, and times.
- Save, share, and print your workbooks.
- Recognize how to freeze panes to control your view.
- Recall methods for protecting documents.