If your spreadsheet is small and difficult to read, there are a few options for magnification, allowing you to zoom in closer. This quick tip shows you how to zoom in and out and even select a section of your sheet to magnify a specific area.
(upbeat music) - [Narrator] If the text in your spreadsheet is too small to read, you can change the zoom to get a closer look. In the View Ribbon, click on the zoom button. Set the percentage you want to get a closer look at your sheet. Zoom to a smaller percentage to see the whole sheet at a glance.
Or, select the data that you want to look at and zoom to that selection. For even faster zoom control, use the zoom slider at the bottom of the window. Or, click on the percentage button to choose your specific zoom size.
- Working with references
- Freezing and locking
- Automatic data population
- Recovering lost work
- Finding named ranges
- Formatting cells and applying styles
- Applying international currency formatting
- Inserting hyperlinks
- Creating dropdown lists
- Hiding columns and rows
- Password protecting a workbook
- Restricting editing
- Adding headers and footers
- Locking cells
Skill Level Intermediate
1. Excel Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.