Microsoft Excel - Page 2 - Tech-Recipes

Microsoft Excel tutorials

Excel 2007: Clear All Formatting From a Range of Cells

contributed by Rob Rogers on August 4, 2008 under Microsoft Excel

If you have a spreadsheet that contains the data you desire, but the formatting isn’t to your liking, Excel can clear the formatting from a cell, range of cells, columns, rows or the entire spreadsheet.

Excel 2007: Using a Background Image

contributed by Rob Rogers on July 16, 2008 under Microsoft Excel

If you want to dress up your spreadsheet a little bit, you can add a background image. This works especially well when using images such as corporate logos that give it an “official” look.

Excel 2007: Have Your Data Read Back To You

contributed by Rob Rogers on July 15, 2008 under Microsoft Excel

After taking the time to input a large amount of data, you will want to double check to make sure you entered everything correctly. It can be quite time consuming to have to constantly look back and forth from your printed list to your spreadsheet. A better way is to have Excel read your data back to you, allowing you to check the printed list while listening to the spreadsheet values.

Excel 2007: How To Hide Duplicate Records in a Spreadsheet

contributed by Rob Rogers on July 8, 2008 under Microsoft Excel

If you have a large spreadsheet that contains duplicate entries (customer names, class subjects, etc.) and you want to view only the unique records in the list, you can filter out the duplicates.

Excel 2007: Use Data Bars for Cell Value Analysis

contributed by Rob Rogers on April 14, 2008 under Microsoft Excel

Data bars make it easy to analyze the values in a range of cells. They are colored, horizontal bars whose length is dependent upon the value of the cell. The cell value itself, rests in front of the data bar, so the data is still easy to read. Using data bars can be helpful in easily determining high and low values. By default, Excel will configure the data bars based on the highest value and the lowest value in the range of cells. By default, Excel will configure the data bars based on the highest value and the lowest value in the range of cells. You can also apply customized data bars to the selected data range.

Excel 2007: Add Minimum, Maximum and Numerical Count to the Status Bar

contributed by Rob Rogers on June 29, 2007 under Microsoft Excel

Excel’s status bar can come in handy by giving you additional information when you select a range of cells. By default, it displays the Average, Count, and Sum. You can also include Minimum, Maximum, and Numerical Count, or any combination of the six options.

Excel 2007: Change the Default File Location

contributed by Rob Rogers on April 24, 2007 under Microsoft Excel

By default, Excel uses your Documents (if you use Vista) or My Documents (if you are using XP) directory as the location for saving files. To change the default file location, follow these steps:

Excel 2007: Use Custom View

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

If you find yourself modifying the display of your worksheet multiple times in the course of working with your spreadsheet, then the Custom Views functionality is definitely for you. Custom Views allows you to save changes to current position and magnification, column widths, row heights, print settings, frozen panes and more. Instead of constantly making these modifications and changing them back, you simply select your custom view and you’re there, switch back to your normal view and you’re back to the default view.

—