General discussion

Locked

Printing blocks of cells on a page

By Allan.Thompson@ntlworld ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by softcorp.us In reply to Printing blocks of cells ...

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

Collapse -

by Allan.Thompson@ntlworld In reply to

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

Collapse -

by softcorp.us In reply to Printing blocks of cells ...

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

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums