 |
 | 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 / December 2005border format causing the doc to be hundreds of pages long
I have a spreadsheet that is about 6 pages long. Evidently, someone has applied a border to some cells , that seem to go on and on forever. Therefore, the worksheet looks to be hundreds and hundreds of pages... all the extra pages have a bold line down one of the columes. I have tried to select all the range and get rid of the bold , but the spreadsheet goes on forever.. I never get to the end, so the page length keeps getting longer. I know there must be an easy solution... Anyone?? Thanks g It's a good habit to specifically set the print range: Select the range you want printed. File>Print Area>Set Print Area That way Excel won't just print the used area of the sheet. Does that help? *********** Regards, Ron > I have a spreadsheet that is about 6 pages long. > Evidently, someone has applied a border to some cells , that seem to go on [quoted text clipped - 15 lines] > > g Setting the print area is a last resort, I would not consider it as solving the problem. Use of Print Preview is always a good idea. Then if you have a problem, first try to fix, if you are short on time then and only then would I suggest using Print Area range just so you can print. > It's a good habit to specifically set the print range: In general, I try to assess "what's the worst that could happen". With printing, I run across too many users who confidently click the Print icon and don't realize that 500 sheets are pumping out of the printer. Typically, I use a 2-pronged approach: 1)I remove the print icon from the toolbar and leave the Print Preview icon. That way, if they (I) accidentally click the Print Preview icon, I only get a preview. And if I really intend to print, I hold down the [Shift] key when I click it, which as you know converts it to the Print icon 2)Set the print area...just in case. That's probably because I deal with quite a few financial professionals who create huge analyses, but only need to print specific report sections of their worksheets. Your thoughts? *********** Regards, Ron > Setting the print area is a last resort, I would not consider it as > solving the problem. Use of Print Preview is always a good idea. > Then if you have a problem, first try to fix, if you are short on time then > and only then would I suggest using Print Area range just so you can print. > > > It's a good habit to specifically set the print range: Most of my thoughts I already gave. I certainly agree with removing the print button, as you can't see what you are doing, you might be creating a file instead. If your print area is too small then you will likely lose some of your printed report in the future if not careful. "Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message news:5EF80BD2-076F-48DF-9577- > Your thoughts? Hi Grace, Try changing your print area to select only the spreadsheet that contains data? Just a thought... unfortunately I haven't run into this so I'm not 100% sure what else to try. How extensive is the formatting on the spreadsheet? If you're desperate, you can select the entire sheet, click Edit > Clear > Formats... that should clear *EVERYTHING* including number formatting, column formatting etc... That might not be what you want. Hope I Helped. OBD Hi Grace, Applying borders to the entire worksheet will not change the lastused cell indication (Ctrl+End) The first thing I would try would be to make sure that the problem is not from inserting and deleting rows where Excel only seems to remember how far you had extended range and never fixes it. Run the DeleteUnused macro to fix all worksheets to see if that solves your problem -- Debra Dalgleish's site: Why do my scrollbars go to row 500 -- my data ends in cell E50?, http://www.contextures.com/xlfaqApp.html#Unused otherwise, ... Someone has placed a cell with formula or constant or even a space in some out of the way area on the spreadsheet. Often caused by someone trying to extend a format or conditional format with the fill handle rather than formatting the entire column. Or by someone trying to use a hidden formula in an out of the way place on the worksheet rather than in a different worksheet.  Signature--- 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 > I have a spreadsheet that is about 6 pages long. > Evidently, someone has applied a border to some cells , that seem to go on [quoted text clipped - 15 lines] > > g I can set the print range and that will fix the printing problem, but I would like to know how to fix the problem. I have tried everything except the unformating the entire sheet.... How many rows are in a sheet anyway... I don't seem to get to the end.... The formating errors don't seem to be too bad, but enough to make a lot of work to fix ... > Hi Grace, > Applying borders to the entire worksheet will not change the lastused [quoted text clipped - 35 lines] > > > > g That is why I suggested the macro in my previous reply. > I can set the print range and that will fix the printing problem, > but I would like to know how to fix the problem. [quoted text clipped - 3 lines] > The formating errors don't seem to be too bad, but enough to make a lot of > work to fix ... |
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.