View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kassie Kassie is offline
external usenet poster
 
Posts: 37
Default In excel, how do I remove unwanted lines for printing

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

--
kassie

never stop learning




"Darren N" <Darren wrote in message
...
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?