Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default In excel, how do I remove unwanted lines for printing

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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove the annoying automatic date formatting in Excel? Jose-Edinburgh Excel Discussion (Misc queries) 2 May 10th 23 11:43 AM
How do I remove (form) check-boxes from multiple excel fields? ATSANAC Excel Discussion (Misc queries) 2 May 11th 06 06:48 PM
HOW DO I REMOVE THE GHOST ON DRAWING LINES in excel ? art in S.A. Excel Discussion (Misc queries) 1 May 1st 06 04:25 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
copy-paste from excel to powerpoint - grid lines Cowtoon Excel Discussion (Misc queries) 3 October 5th 05 12:41 AM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"