Great. A skill that every user needs. Good page layout is as both an art as a skill--jt requires both. In addition I find CHOOSECOLS a great way to select not-necessarily-contiguous columns when laying out a report and then finding the page breaks. I can then adjust the width of the report by simply adding,deleting or substiuting column index values in the CHOOSECOLS function. Plus its a very easy function for beginners!
@ashwinsrk1
Жыл бұрын
Thanks Chris for your insightful videos! Keep them coming! ✨
@ChrisMenardTraining
Жыл бұрын
Will do. Thank you.
@SamiSheikhOfficial
Жыл бұрын
Informative content with easy Steps. Thanks
@ChrisMenardTraining
Жыл бұрын
Thanks, Sami.
@bethkoch11
Жыл бұрын
Very useful information!
@ChrisMenardTraining
Жыл бұрын
Thanks, Beth!
@iamabeinginsearchofmeaning
Жыл бұрын
Thanks a lot
@ChrisMenardTraining
Жыл бұрын
Welcome
@jot0848
10 ай бұрын
Hi Chris, thanks for this video. Is it possible to set a page break per the printing page size? I received a sheet with multiple tabs. Going through each tab and changing the page breaks is a tedious task , which i am willing to do but i am not sure if the final print be suitable for letter size or not.
@ezrabrathwaite1359
9 ай бұрын
Sorry Chris, but I did exactly what you showed in terms 'reseting' page breaks and it got of most of the extra pages, but some of the 'breaks' are still visible and just won't go away even when dragging the these page break lines.
@ChrisMenardTraining
9 ай бұрын
By chance are those the page breaks that Excel is automatically adding?
@ezrabrathwaite1359
9 ай бұрын
@@ChrisMenardTraining Yep, for some reason, I would close a file and reopen the same file at a later date, and then the tab would have like a 'million' page breaks that I never initiated myself. Its weird why Excel does this automatically when reopening a file.
Пікірлер: 16