Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I determine how many pages my excel workbook is?
I have a huge excel worksheet and I want to determine how many pages it will
be. Is there a way to do that? I also have separated this document into 8 or 9 worksheets. Thanks. -- - RP - |
#2
|
|||
|
|||
Group all the sheets you want to check then use print preview,
if you are showing the page number on the printed pages you will see the total on the last page. Don't forget to ungroup your sheets when finished or risk severe damage to your workbook as any change made to a grouped sheet is made to all sheets in the grouped sheets. To group sheets, select first sheet then hold shift and select last sheet, or right click on sheet tab and choose select all sheets. to UNGROUP sheets when finished, right click on sheet tab and choose Ungroup Sheetsl --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "RP2chil" wrote in message ... I have a huge excel worksheet and I want to determine how many pages it will be. Is there a way to do that? I also have separated this document into 8 or 9 worksheets. Thanks. -- - RP - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel XP - 2 Column Pages | New Users to Excel | |||
How can I mirror pages in an excel document for printing? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
how do i find percentage from 2 different pages in Excel? | Excel Worksheet Functions |