View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

Please put the entire question in the body of the question. The subject tends
to be ignored once someone starts answering.

Extra columns and rows that are truly empty can be a result of inserting and
deleting rows/columns, Excel tends to remember the high water mark.

If you have rows that look empty but have formulas in them, they really are
not empty. You want to remove your unused rows/columns which is
easiest done with a macro and then save the file, if the macro didn't do
that for you. You can fix up your entire workbook at one time, see
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish
http://www.contextures.com/xlfaqApp.html#Unused

You can read more about the problem and some other remedies at
http://www.mvps.org/dmcritchie/excel/lastcell.htm

As a LAST resort you can restrict the print area, but that just allows
you to print fewer pages it really does not solve your problem.

---
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

"Help I am new to all this" <Help I am new to all wrote in message
...
I have no idea how to put in the formula. I only want to print what I type
into the spreadsheet. How do I do that without having a lot of extra pages!!!