MS Excel 2003: Set the print area. Answer: To set the print area in a sheet, first highlight the cells that you wish to print. In this example, we've highlighted cells B1 to D9. Then under the File menu, select Print Area > Set Print Area. Now when you print, only those cells will show up. However I just reopened it again and have not selected more than one sheet, even though I have apprx 25 tabs in total, and it still shows group mode at the top and the set print area is greyed out again? If you want your headings to repeat,. There seem to be so many misconceptions about the Print Range in Excel, and many people set it unnecessarily. Fit to a Page One of the few settings you might want to make is to force the data to fit to a page. Please keep in mind that you can't make it perfectly fit a page both horizontally and vertically. Make a choice, which is usually horizontal. To do this, go to File Page Setup and click the Fit To option. Click inside the 'tall' box and delete the 1 that's there if you don't want it to fit to one page tall, but you do want to limit the horizontal width. Setting a Print Area Excel will automatically want to include all cells that contain information. But suppose the only thing you have over in column H is a note to yourself, but you don't want it to print. You can select entire columns to set a print range, there's no need to select all the cells. So, you can select columns A through G, for instance, and hit File Print Area, Set Print Area. Print Area Too Big So you didn't set a print area, but Excel wants to print too many pages? Or you set the width to fit to one page wide, and it only fills half a page and it's too small? It's as if Excel is seeing something in cells that don't contain anything? You may need to clean up these areas of 'dirty' cells. • Select the first completely blank column in your worksheet by clicking on its letter. Hold Shift+Ctrl and then hit the Right arrow key until you have selected all the way to Column IV. Hit Edit Clear All. • Select the first completely blank row in your worksheet by clicking on its number. Hold Shift+Ctrl and then hit the Down arrow key until you have selected all the way to Row 65536. Xenogears for pc. Hit Edit Clear All. • Save your workbook, and try your print preview again. OfficeArticles.com debuted on May 26, 2005. OfficeArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided 'as is' and we do not guarantee that they can be used in all situations. Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.| © 2005 - 2019 by MrExcel Publishing. All rights reserved.
0 Comments
Leave a Reply. |