Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Lets take a closer look at the View menu, to help you navigate the view of your spreadsheet while you're entering, reviewing or presenting data. To access the View menu, click the word View in the upper menu above the Google Sheets toolbar. You'll see a drop-down menu up here with several options listed. Let's walk through each of these selections to get a sense of how they're used. The first two options are Freeze Rows and Freeze Columns. Freezing Rows and Columns is useful if you want to keep a row or column header or label visible as you scroll through a large spreadsheet.
You can freeze up to ten rows or five columns per sheet. The next option is Gridlines. Gridlines are those light gray lines between rows and columns. By default, gridlines are shown. If you'd like to turn off gridlines, uncheck it. Check Gridlines, and they'll appear again. The next option is Protected Ranges. This is only relevant if you've set up some areas of your spreadsheet that you don't want others to revise or edit. If you've set up any protected ranges, you can uncheck this selection to turn off the protection. The next option is Formula Bar.
This is turned on by default. This is the bar right here that displays the formula for any calculated cells. Let me show you one on this Sunshine & Location Chart. I've entered a formula here in cell E5. When I click it, the calculation of the formula appears in cell E5, but the formula appears in the Formula Bar. On the View menu, I can uncheck Formula Bar to hide it. This could be handy if I'm presenting, and I don't want to display extra information. Turn it back on, simply check it again.
Under the View menu, if I check All Formulas, all the formulas that I've entered on the spreadsheet will change from calculations to formulas. You can see now that all the formulas I've entered in column E display the formulas, rather than the calculations. I can uncheck it, and the calculations appear again. If I've hidden any sheets on my spreadsheet, the Hidden Sheet selection will be active. I can select that and review or unhide any hidden sheets on my spreadsheet. I can also change the way that I view menus in toolbars.
I can select Compact Controls if I want the menu and toolbar to be displayed in a more compact view. I can deselect it to return to the Standard Controls view. I can also move to a full screen view of my spreadsheet without any controls by selecting Full Screen view. This can be great for presenting your spreadsheet. To go back to the controls view, I'll press the Esc key on my keyboard. The View menu can be really helpful when you're sharing your spreadsheet in a presentation. You can alter the view of the data, so that it's easy to present and focus on the content.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91106 Viewers
80 Video lessons · 138156 Viewers
59 Video lessons · 56972 Viewers
52 Video lessons · 70605 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.