ipslogo

"My spreadsheet only has 7 columns and 200 rows, but it prints 49 sheets!"


The problem sounds as though something has been created in cells way outside the range required. It may have been an accident or the user may have done some temporary calculations way down or way across the spreadsheet and then have deleted them. There are several solutions to this - clearing and resetting the print area springs to mind, but if there is a reason for not wanting to do this (and there could be some very practical ones), then the simplest solution is to copy and paste the required data onto a new worksheet - tedious if the spreadsheet is large, but try holding the SHIFT key down and clicking (or using Excel's navigation keys) to highlight rather than just dragging. Alternatively, can you copy and paste sections at a time?

© IPS Limited 2001