Total width of several columns.
 

Could you please advise if there is a quick way to total the width over
several columns of a worksheet. I need to do this so that I can make page
breaks for printing a worksheet that is about 1 page high x 10 pages wide, in
landscape format, ensuring that the pages break at the required cells.

Alternatively, is there a way to set vertical page breaks?

Thanks!

Total width of several columns.
 

View Pagebreak preview

In this view you can drag the page breaks where you want them.

--
Carlos

"Basher Bates" wrote in message
...
Could you please advise if there is a quick way to total the width over
several columns of a worksheet. I need to do this so that I can make page
breaks for printing a worksheet that is about 1 page high x 10 pages wide,
in
landscape format, ensuring that the pages break at the required cells.

Alternatively, is there a way to set vertical page breaks?

Thanks!

Total width of several columns.
 

Many thanks! - brilliant!! - easy when you know how!

Ken

"Carlos Antenna" wrote:

View Pagebreak preview

In this view you can drag the page breaks where you want them.

--
Carlos

"Basher Bates" wrote in message
...
Could you please advise if there is a quick way to total the width over
several columns of a worksheet. I need to do this so that I can make page
breaks for printing a worksheet that is about 1 page high x 10 pages wide,
in
landscape format, ensuring that the pages break at the required cells.

Alternatively, is there a way to set vertical page breaks?

Thanks!