Microsoft Excel - Page 3 - Tech-Recipes

Microsoft Excel tutorials

Excel 2007: Print High Quality Graphics

contributed by Rob Rogers on March 23, 2007 under Microsoft Excel

If you use graphics in your Excel spreadsheet and need them to really shine, print them out in high quality mode. Here’s how:

Excel 2007: Show Formulas to Verify Your Equations

contributed by Rob Rogers on under Microsoft Excel

One mistake that is often made in spreadsheets containing lots of data and formulas, is the accidental placement of numbers in a cell instead of the formula. It is a painful task to examine each and every cell one at a time to verify that the proper cells are using the proper equation. In addition, verifying that the cells referenced in the equations are correct can be equally overwhelming. Fortunately, Excel allows you to show the formulas of the entire spreadsheet so that you can more easily check your work. Excel 2007 does a great job of automatically expanding the cell size to accommodate long equations. Once you are finished verifying the formulas, a simple click of the mouse returns the spreadsheet to it’s normal data view with your formatting intact.

Excel 2007: Add Your Physical Signature to a Workbook

contributed by Rob Rogers on March 22, 2007 under Microsoft Excel

Once you have finalized a spreadsheet or workbook, you may want to add your physical signature (or actually an image of your signature) to the finished document. To do this:

Excel 2007: Spell Check All Sheets at Once

contributed by Rob Rogers on March 16, 2007 under Microsoft Excel

Instead of spell checking each sheet in your workbook one-at-a-time, you can spell check all of them at once and save yourself some time.

Excel 2007: Eliminate Blank Rows in a Spreadsheet

contributed by Rob Rogers on March 8, 2007 under Microsoft Excel

Blank rows can be beneficial when it comes to making your spreadsheet easier to read, however if you are going to pull the data into another application (such as Access), the blank rows can cause you some problems. You could go through the painful task of selecting and removing these rows individually, but if you are working with a large spreadsheet, it could take forever to accomplish this. Instead, utilize Go To Special and let Excel do the work for you. Here’s how:

Excel 2007: Print Part of a Spreadsheet

contributed by Rob Rogers on February 26, 2007 under Microsoft Excel

If you are working with a large spreadsheet, you may want to only print a portion of the total worksheet. Why print out 1200 rows of data when you only need 25? Follow these steps to print part of a spreadsheet:

Excel 2007: Set the Default Column Width for a Worksheet

contributed by Rob Rogers on February 20, 2007 under Microsoft Excel

By default, Excel gives you a standard column width value of 8.43, but what if the worksheet you are working on requires the columns to be wider? You can adjust the width of each individual column or better yet, you can adjust the default width and take care of all of them at the same time. Here’s how:

Excel 2007: How To Add a Trendline to a Chart

contributed by Rob Rogers on February 12, 2007 under Microsoft Excel

Trendlines are useful for revealing patterns or trends in your data. They are mostly used in XY scatter charts but are also useful in line, area, and bar charts. To add a trendline to your chart, follow these instructions…

—