You're preparing for a meeting and have a report that could fit on a single page, but it doesn't. You need to reconfigure the report so that it does fit on a single sheet.
- [Instructor] You and I are about to go into a meetin'…with some important clients to discuss these projects,…and we've gotta share this report.…Make sure this sheet can be printed legibly on one page.…Use print preview, wrap text,…row height and column width, scale,…and then it's your choice…if you want this portrait or landscape.…Pause the video now,…get this sorted out so that it can print on one page…and we look professional,…come back,…and I'll show you a solution.…
Okay, let's get into this.…First of all, let's verify how this would print out.…Let's go to File, Print.…It's a good thing we caught this,…because we can't go in there.…This is on five different pages.…What's the first thing?…Wrap text.…Where we really need the text wrapped is in column F,…so I'm gonna highlight that…and go to Home tab, wrap text.…
Bring that column in a bit.…Highlight this corner…so that I can select the entire worksheet,…and then double click any row.…Let's look at the preview again.…Print.…Now we're on four sheets.…Next we can go to scaling…
AuthorOz du Soleil
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Beginner
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
New This Week
The expense report is wrong2m 18s
- 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.