I have 2 quick announcements & 1 Excel tip for you.
- Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
- 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.
When you print a long report, notice how Excel chops it in to pages? Sometimes, you don’t like how the pages are broken and want to insert page breaks where you want.
Here is how you can insert page breaks:
- If you want to insert a break after Row 7
- Select the row 8
- Go to Page Layout > Breaks
- Select Insert Break
PS: If you use Page Break Preview mode (from view ribbon), you can manually drag and resize pages until everything looks the way you want.
PPS: If you want to learn Excel (and dashboards), consider joining Excel School. If you hurry up, you can even get 20% discount. Click here.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« How Companies Can Manage Spreadsheet Risk [Part 2 of 4]||Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip] »|