Tips For End Users of Excel 2003 and 2007

Here are some tips for end users of Excel, both the 2003 and 2007 versions. In this article, you will learn how to print a portion of a spreadsheet, print column headings on each page, and change the default font - in both versions of the application.Excel 2007 - Printing a portion of a Spreadsheet.First selected range of cells you want to print. Then, under the heading "page layout," go to print area icon, select "Set Print Area." Then print the worksheet. Finally, select Delete print area "and the entire worksheet will print the next time (instead of just the selected area). There is also a section at the end of the article describing the format painter.Printing column headings in each Page.First, go to "menu page layout" and click "Print Titles" icon, then click in the "Road" tab. Then, to print column headers on each page, enter the rows that contain labels under the column "Print titles" in "Rows to repeat." When you're ready, click "Print". Change Default Font.In Excel 2007, the default font and size is Calibri 11.First, click "Microsoft Office" and then click on "Options Excel." By creating new work in "Popular", click on the font you want to use the "Using this source," then enter the font size you want to use the "Fontsize" box.NOTE: you must Excel restart to use the new selection by default, which affects only newly created workbooks.Excel 2003 - Printing start Spreadsheet.To part of a selected range of cells you want to print. For the next step in the file menu, go to "print area."

Then click on "Set Print Area." Then print the worksheet. When you save your print area is also saved.Printing column headings in each Page.If you have spreadsheet data covering several pages and want column headings in each of them, this will help: First beam click on Page Setup in the File menu, then click on the "Road" tab. Then, to print the column labels on every page, enter the rows that contain labels under the column "Print titles" in the "Rows to repeat in the table above." Finally, click " ; Print ". Changing the default FontFirst, click "Options" in the "Tools" menu. Then click on a font in the "Standard typeface" box on the General tab. Finally, click a font size in the "size" box.NOTE: You must restart Excel to start using this new default font and font size. This new default will be effective for new work cree - are not working existing format is affected.What Painter? Those who prefer to do simple Word documents could not be the heaviest users Style. If you want to use styles already created a document format Painter is an excellent tool. In order to implement a paragraph style of a paragraph to another: first put the cursor somewhere in the style of the paragraph, then click the format Painter (Ctrl-Shift + C). Click the paragraph where you want to apply the style. If you want to apply style to several paragraphs, double-click the Formet Painter. Then click on each paragraph later, to implement this style.