Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Help I am new to all this
 
Posts: n/a
Default I have too many columns and rows, so it prints too many pages.

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!!!
  #2   Report Post  
paul
 
Posts: n/a
Default

You dont say if you need to have more pages or not but you need to
"highlight" the area that you want to print and on the file menu go to print
area and then set print area.You can then go to the view menu and select
page break view to see how the sheet is going to print out.On this view you
can drag the page breaks(blue lines) to the row or column you want.The file
menu has a page setup where you can set how many pages you want and the
orientation of the pages(portrait or landscape).Experiment with that and post
back if you need to!
--
paul
remove nospam for email addy!



"Help I am new to all this" wrote:

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

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



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
inserting columns within certain rows only crimsonkng Excel Discussion (Misc queries) 4 July 14th 05 05:13 PM
Repeating Rows and Columns on each page of print out BruceM Excel Discussion (Misc queries) 1 July 6th 05 12:28 PM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 08:45 PM.

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

About Us

"It's about Microsoft Excel"