stillloud.blogg.se - How do i change print area in excel

HOW DO I CHANGE PRINT AREA IN EXCEL HOW TO
HOW DO I CHANGE PRINT AREA IN EXCEL CODE

If using the second method, select “ Fit all Columns on One Page” instead of “ Fit Sheet on One Page”. If you need all your columns within 1 page, but don’t mind splitting the rows to 2, 3, or how many ever pages needed, then leave the Height option blank if using the first method.If you have too much data in too many columns, your printout might turn out too tiny and look illegible. If everything looks fine, you can go ahead and hit the Print button.Īutofit only the Width or Height into a Single Page

Check if you got everything on a single page from the preview on the right-hand side of the screen.

On the left-hand side of the screen, you will see a ‘Settings’ section. The last option under this section is most likely a dropdown that says “ No Scaling”.

This does exactly the same thing that I did in the previous method (just the option to do it is in a different place).īelow are the steps to fit data on one page while printing: You can also scale the data to fit on one page while you’re printing the data. Method 2: Fitting data to Page in Excel using Print Preview Screen This works fine if you only have a few extra rows or columns, but if you have a lot, fitting all of it in one page may not be a good idea. Test Your Code! See in my example below where I change the Print Areas to demonstrate this Macro.When you use this option to scale the page and fit data on one page, it will make the data look small (as Excel tries to squeeze more data in the same space. Sounds perfect for what we want, doesn’t it? This Includes all cells that are in between. The Used Range property represents the upper left and lowest right cells that are used in a worksheet. This is ideal as this can vary from time to time. This returns a range object which is representing the rea of the worksheet that is being used. This is where we set the Print Area as being the UsedRange. We use the PageSetup.PrintArea Property which sets or returns the Print Area to be printed. Select the Worksheet Object and the Change event from the Event drop-down list. Double click on the Worksheet where you want to set your Print Area.

HOW DO I CHANGE PRINT AREA IN EXCEL HOW TO

If you want to know how to enable the developer tab then you can check out my YouTube Video below for some simple Instructions.

Activate the Visual Basic Editor By hitting ALT+F11 shortcut of you can go to the Developer Tab | Visual Basic to open the Visual Basic Explorer Window.

HOW DO I CHANGE PRINT AREA IN EXCEL CODE

By combining it with the UsedRange property and storing the code in the worksheet’s Change Event it becomes dynamic as it triggered anytime there is a change in the Excel worksheet. We use the PrintArea property to determine the range of cells to be included when printing the Excel worksheet. This macro will automatically print the used or active range of cell in your worksheet How Does The Macro Work?. So, if you have a variable report or data set you to need to print, this little macro will automatically create a dynamic Print area for you with no hard work at all. That’s right, set up this piece of VBA code in your Excel workbook and your print area with change as your active area in your worksheet changes. I have a really nice little bit of VBA code for you today which allow you to set your Print area in your Excel worksheet to become dynamic. Hello Excellers, welcome to another #macromondays blog post.