Hello. I am having trouble figuring out the relationship between page scaling and the inclusion of print titles. Please see the attached image for reference. Thank you in advance for your help.
Basic Question: If I have a sheet scaled to fit on one page and no print titles are included it...
I'm using Excel 2016 with Microsoft office 365. I need to retreive the pagesetup.zoom value for a area fitted into one page wide by one page tall.
Some Introduction
Before printing a worksheet, I want to run a page setup macro that will adjust the print zoom value to make sure the printed...
I have a scheduling program that runs in Excel. One macro saves 7 ranges to a PDF file. The ranges, however go beyond the print limits and thus render 14 pages of PDF instead of the intended 7 pages (referring to 7 days in the week). Can someone help me to have each range "Fit to Page,"
so...
I am making a spreadsheet that has only one worksheet but will need to divide the data onto multiple pages.
Specifically there will be 4 columns. The number of rows is variable.
I need to be able to enable the print area to fit to each page from Column A to Column D and each row of 50.
So...
I have a user that recently switched from Excel 2011 on a Mac to Excel 2010 on a PC. I'm pulling my hair out trying to figure this out.
Imagine a single spreadsheet with 5 months worth of scheduling on it. Depending on the month, you have 31 or 30 rows. Depending on the data in each row and...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.