Huge spreadsheet spanning 600 rows...

  • Thread starter Thread starter ~D~
  • Start date Start date
D

~D~

User wanted this to print on 11x14..it spanned the entire
page and then some..where would I first look to edit to make this easy to
read.
 
Hi

you might want to investigate data / format / autoformat to limit the number
of row printed at a time

or you might like to have a look under file / page setup - sheet tab for
rows to repeat on each page (ie headings) & the printing of gridlines

other than that you'll need to give us a more specific idea of what you're
trying to achieve.

Cheers
JulieD
 
I had no clue where to start..thanks for the ideas and if I come across
anything further I will post back. :)
 
I think Julie meant that you should use Data>Filter>AutoFilter
That's a feature that allows you to select one or more criteria, to
limit the number of rows that are visible in a long list. For example,
you could select a customer from a Customer Name column, then print the
records for only that customer.

There are instructions in Excel's Help, and here:

http://www.contextures.com/xlautofilter01.html
 
Back
Top