T
thurm
I am hoping that someone can tell me if there is any correlation in Excel
2008 between Print>Preview and Page Layout. I have a brand new, out of the
box, Intel Mac running Office 2008 in OS 10.5.6. To my dismay, I have found
that Excel 2008 does not have Print Preview—a feature that I have used with
great frequency since I started using Excel back in 1987. I understand that
I must now use Page Layout. Unfortunately, the “pages†displayed in Page
Layout do not reflect the actual pages as printed. Granted, Print>Preview
does show the pages as they actually print, but it is not possible to make
any layout changes without leaving that view. My work often entails the
production and layout of large, multi-page tables that have specific layout
parameters (i.e., margins, font size, etc.). I am trying to figure out how
to accomplish that without being able to view and adjust the tables in a
straight forward manner.
As an example: In a new file, type a ‘1’ in Cell A1, ‘2’ in Cell B1 and
consecutively through ‘20’ in Cell T1. Copy and paste Row 1 in Rows 2
through 70. Specify Cells A10 through T50 as the print area. In Page Setup,
specify landscape, Fit to one page high by two pages wide. Print>Preview
will display the pages to be printed correctly, but Page Layout displays the
entire table with no print area. To display the print area in Page Layout,
you must go back to Page Setup and specify the print reduction. In this case
94%. Page Layout now delineates the print area with a dashed line, which is
spread over FOUR “pages†instead of the actual two pages. In addition, the
view in Page Layout includes all of the table, not just the area to be
printed. This makes it very difficult to visualize exactly what will print
out or how it will look on the page.
I have read many similar questions in the forum, but I have yet to find a
solution to the above problem. Is there some obvious solution that I am
missing?
Thanks,
Thurm
2008 between Print>Preview and Page Layout. I have a brand new, out of the
box, Intel Mac running Office 2008 in OS 10.5.6. To my dismay, I have found
that Excel 2008 does not have Print Preview—a feature that I have used with
great frequency since I started using Excel back in 1987. I understand that
I must now use Page Layout. Unfortunately, the “pages†displayed in Page
Layout do not reflect the actual pages as printed. Granted, Print>Preview
does show the pages as they actually print, but it is not possible to make
any layout changes without leaving that view. My work often entails the
production and layout of large, multi-page tables that have specific layout
parameters (i.e., margins, font size, etc.). I am trying to figure out how
to accomplish that without being able to view and adjust the tables in a
straight forward manner.
As an example: In a new file, type a ‘1’ in Cell A1, ‘2’ in Cell B1 and
consecutively through ‘20’ in Cell T1. Copy and paste Row 1 in Rows 2
through 70. Specify Cells A10 through T50 as the print area. In Page Setup,
specify landscape, Fit to one page high by two pages wide. Print>Preview
will display the pages to be printed correctly, but Page Layout displays the
entire table with no print area. To display the print area in Page Layout,
you must go back to Page Setup and specify the print reduction. In this case
94%. Page Layout now delineates the print area with a dashed line, which is
spread over FOUR “pages†instead of the actual two pages. In addition, the
view in Page Layout includes all of the table, not just the area to be
printed. This makes it very difficult to visualize exactly what will print
out or how it will look on the page.
I have read many similar questions in the forum, but I have yet to find a
solution to the above problem. Is there some obvious solution that I am
missing?
Thanks,
Thurm