Resizing Converted Page

  • Thread starter Thread starter Don2003
  • Start date Start date
D

Don2003

I saved a Lotus file as a Win XP Excel file. When I open
this new Excel file, it seems like extra columns have
been added and the form will not fit on a single page.
When I try to fit it all on one page (Page Setup - Fit to
one page), it's very tiny. Is there any way, other than
manually deleting columns, that I can fit the form on one
page (making it the same size that it was in Lotus when I
printed it)?
 
Hi Don,
Use Ctrl+End to find the lastcell, which is the intersection of the
last used column and the last used row. I expect that the conversion
process is not at all concerned with adding additional rows or columns
as long as the results look the the same.

Manually deleting rows and columns can be nuisance, but you can
use a macro, see (directions at top to install/use a macro)
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

If you want to do it manually use the namebox to specify the
range to be deleted for the columns, and after deletion for the rows,
after which you must save the file then recheck with Ctrl+End
 
Back
Top