Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Standard toolbar and click the Print icon, but note within the Microsoft Office Suite, that icon goes immediately to the printer and doesn't give you a chance to configure your print job. If you go up to the File menu and down to Print, that gives you an opportunity to print a range of pages, maybe only the active worksheet, which is by default selected, or you can change that to your entire workbook, the list that you currently have selected. You can access Print Preview from here and, if you increase the number of copies that you want to print, you make sure that you have Collate on so that the printer does all work for you and your jobs come out in bunches ready to go. Let me cancel that.
Another option that you may want to exercise when you're printing or even if you're just displaying this on screen is to hide certain elements of data. You can hide data by selecting your range, right-clicking and choosing Hide. That's an easy way to get to it from the quick menu. If I want to bring that back again, I can select a range of cells that encompass the hidden range and right-click and choose Unhide, or if I right-click here, choose Hide, I can go up to the Format menu, down to Column, say Unhide. Be warned if you've hidden rows, let me hide these three rows together, you cannot go up to the Format menu, down to Columns and say Unhide. If you do, it'll be ineffectual. You need to go to the Format menu > Row and say Unhide. So you have to be somewhat aware of what's hidden within a spreadsheet before you can accurately unhide it.
Before we do unhide that information, let's go and take a File > Print Preview, and you'll see that those three pieces are missing from our final printout.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73572 Viewers
80 Video lessons · 129279 Viewers
52 Video lessons · 63653 Viewers
59 Video lessons · 49415 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.
Your file was successfully uploaded.