In excel, how do I remove unwanted lines for printing

D

Darren N

I use a basic Excel spreadsheet which I have created to list a load of
materials. When I want to print this document I get about 20 pages when I
only require 2 of them. Is there a way I can print the document to only see
the cells I have filled in?
 
K

Kassie

Select the area you want to print, and then click on File|Print. Select
Selection iso All, and it will only print the area you selected. To do it
via a macro is also feasible, since you then only have to select the area,
click on a button, and voila
 
Top