Make sure both Wide and Tall settings are 1. On the Page tab, click Fit To in the Scaling section. To print the active sheet on a single page, do the following: Excel 2003 You might not be able to read it easily, but that might not be your main concern. This feature is nice when you want all the data on a single sheet. The break will appear above the selected row or to the left of the selected column. Then, in the Page Setup group, click Breaks | Insert Page Break. Choose Page Break from the Insert menu. Select the row or column where you want to insert the break. #EXCEL SET PRINT AREA 2010 MANUAL#
Sometimes, rather than moving an existing page break, you might want to insert a manual break, as follows: No more guesswork: Simply put the page breaks exactly where you want them.
The dark gray watermark denotes the page number. 
The dashed lines identify page breaks, which you can move. You can adjust this area by moving the solid blue boundary lines. 
The visible white area is the Print Area. This view is noticeably different from the other views but shares a lot of information, visually: Click OK to clear the prompt and move on to Page Break Preview. Excel will prompt you with a quick reminder that you can adjust page breaks by clicking and dragging them. In Excel 20, choose Page Break Preview from the Workbook Views group on the Layout tab. To remove some of the guesswork, choose Page Break Preview from the View menu in Excel 2003. Fortunately, there’s help in the form of page breaks. Initially, printing can be a bit tenuous just what will you get? You print, reset, try again… that could go on for a while. 
When you need to quickly print another area, print a selected range.
Choose Print Selection from the first Settings drop-down (Print Active Sheet is the default).įor the normal print job, just print, and Excel will default to the Print Area. Click the Office button or the File tab. In the Print What section, choose Selection. When you need to print something other than the Print Area, print a selected range as follows: Excel 2003 In the Page Setup group, click Print Area | Set Print Area. To set the Print Area, do the following: Excel 2003 After you set the Print Area, subsequent print jobs will default to that specified area instead of the entire sheet. Print selected cells for a one-time print job.Ī combination of these two methods provides the flexibility you need to quickly print exactly what you need.įirst, use the Print Area option for a print job that seldom changes. Set the Print Area to limit what Excel prints by default. There are two quick methods for controlling what Excel prints: 1: Set a custom print areaĮxcel prints the active sheet unless you tell it differently. Here are several easy ways to enable the appropriate settings to print just what you need, when you need it. Fortunately, once you master a few of Excel’s print options, you can avoid frustration and save a lot of time. Many Excel users are skilled at manipulating data in their worksheets - but when the time comes to print certain portions of the data, the results aren’t what they want. These simple tips demystify the print options and explain when to use which ones. Five tips for printing Excel data more efficientlyĮxcel's printing features aren't complicated, but users often take a hit-or-miss approach and wind up with a mess.
0 kommentar(er)
