 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004Huge spreadsheet spanning 600 rows...
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 > 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. I had no clue where to start..thanks for the ideas and if I come across anything further I will post back. :) > Hi > [quoted text clipped - 13 lines] > > page and then some..where would I first look to edit to make this easy to > > read. 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 > I had no clue where to start..thanks for the ideas and if I come across > anything further I will post back. :) [quoted text clipped - 22 lines] > >>>read.  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Hi Debra thanks for picking that up ... don't know where my brain was :) Cheers JulieD >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 [quoted text clipped - 33 lines] >> >>>>read. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.