I have a large spreadsheet that I print several sections of. In what menu can I set a print range of BX1:BY63 to print in two columns so that this range can print on one page?
Thanks
I have a large spreadsheet that I print several sections of. In what menu can I set a print range of BX1:BY63 to print in two columns so that this range can print on one page?
Thanks
Sorry... but Highly confusing.
Will File -> Print Area -> Set Print Area work for you?
If not, please specify your problem clearely, and what do you mean by printing in two columns??
Have a look at the "paper saver" in the free addin from http://www.asap-utilities.com. That should do what you want
There's an example in Ozgrid's main site to download from the Workbooks Download section of the VBA articles. Title is PrintCol.zip
I’m sure your find to get you started and workable solution look into setting up a printable area to this Excel document
Caution: When you print you only get the ranges that were selected to print
IE : Two Columns only
Is that what you are looking for.
Kindest possible regards
Jack in the UK
Don’t have an account yet? Register yourself now and be a part of our community!