Discussion Locked

Printing blocks of cells on a page

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello there,
I am trying to devise a macro that will print blocks of text without overlapping to the next page.

Does anyone have a set of instructions that will achieve this? None of the commands to reset page breaks, hard page breaks, clear print area etc seem to work!

Thanks in anticipation.

Allan THompson

3 replies

by softcorp.us

Hello...

I presume you are using Microsoft Excel...

Which version of Excel are you using?

You shouldn't need a macro to control page breaks as you like them in Excel. Excel will print an entire cell on one page or another, not span a single cell across pages.

One thing to try: Use View->Page Break Preview. In this view, you can use the mouse to set and move the page breaks.

Does this help?

-----Steve Jackson

CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use

by Member 34533650

Thanks for responding.
My version is Excel 2002.
THe block of cells that I am trying to print 3 to a page is 27 deep x 14 cells wide. The width is set to expand to fill the page width.
I need to ensure that only three blocks are printed per page ireespective of what paper size is in the printer set up. I don't want the user to have to intervene manually.
regards
Allan Thompson

by softcorp.us

Hello Allan,

With Excel, you can tell it to break inbetween specific columns and force 3 columns per page. But, it will not expand or contract the column widths or font sizes if the paper size changes.

Or, you can tell Excel to print 3 pages wide and it will choose how many columns per page and the font size will expand and contract as required to fit on the paper. This is done via Page Setup->Fit to N pages wide by M pages tall.

But, I know of no way to do a combination of the two.

If the number of columns per page is most important to you, I suggest you manually set the page breaks inbetween those columns and manually size the column widths so it looks best on the paper most often used. Or, specify a specific paper or orientation be used. For example, require portrait orientation with either letter or legal paper.

-----Steve Jackson

CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use

This discussion is closed to new replies.