From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use shrink-to-fit options to adjust the display of cell content and compress printed output

Use shrink-to-fit options to adjust the display of cell content and compress printed output - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use shrink-to-fit options to adjust the display of cell content and compress printed output

“

- [Instructor] The term Shrink to Fit appears 2 in at least one Excel command sequence, 3 but the idea of shrinking data, 4 either to fit on the screen or on the printed page, 5 comes up at different times as we work with Excel. 6 I've got a budget list here. 7 I'm scrolling up and down to see all the rows. 8 I'm also scrolling left to right to see all the columns. 9 And at different times, of course, 10 I'll hold down the Control key, 11 roll that mouse wheel to zoom in and out. 12 Of course, we can also do this with Control + Alt + Plus 13 or Control + Alt + Minus. 14 There could be times, though, 15 when I want the screen to remain stable, 16 and I want to see all the data. 17 I don't need rows 1 and 2. 18 So I'll be highlighting all the data here first, 19 and then using a feature found on the View tab 20 in the ribbon under Zoom, Zoom to Selection. 21 "Zoom the sheet 22 so the selected range of cells fills…

Contents