| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| How do I use my excel program to total up columns ex. e3 to e155 | Excel Worksheet Functions | |||
| total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) | |||
| Columns with "zero" width | Excel Worksheet Functions | |||
| Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel | |||
Hybrid Mode
