Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
64 Posts
Discussion Starter · #1 ·
How does one limit the number of avaiable rows and/or columns in a worksheet or workbook?
All at once when I open a new workbook in excell 2000 I have 65512 rows available and when I want to print out only the current worksheet my printer tries to print 100 pages????? or more.
Silly question but can not find the answer in XL Help.
Tks BobA
I can of course just select the area to print but that is a nuisance.
 

·
Registered
Joined
·
1,578 Posts
Hi alder343!

The rows and columns are references and the ones that don't get used don't take any room. Usually it's graphics and data that take up the most room, then calculations.

When you print, there should be a setting for printing the 'Selection', the 'Entire Workbook', or 'Active sheets'. Check to see if it is set ok...

If you just want to print a sentence out of a page, highlight(select) the sentence, click File, Print, make sure that 'Selection' is chosen in the print settings, and click ok.

_
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top