Microsoft Excel | Tech-Recipes

Microsoft Excel tutorials

Microsoft Excel: How to Hide Tabs

Contributed by shamanstears on August 18, 2009 under Microsoft Excel

If your spreadsheet is shared and used by others, you may want to keep your formulas and some data from being viewed or changed by others. By hiding the tabs that these are located, you can allow others to use your spreadsheet without having to worry about them playing where they don’t belong.

Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet

Contributed by shamanstears on April 27, 2009 under Microsoft Excel

If you find yourself yearning to view Twitter updates in a worksheet, then this is for you. Seriously, Excel can be a useful tool for viewing Tweets, allowing you to format them to your liking. You can add multiple Twitter feeds to your worksheet and have an inconspicuous viewer to read them.

Excel 2007: How to Sort Rows

Contributed by shamanstears on November 30, 2008 under Microsoft Excel

By default, Excel allows you to sort your data by columns. If you run into a situation that requires that you sort the rows, you could do it by hand or let Excel do it for you.

Excel 2007: How to Clear the Values while Keeping Formulas

Contributed by shamanstears on August 12, 2008 under Microsoft Excel

If you are constantly using a spreadsheet that requires you clear the values but retain the formulas, it can be painful to go through and select each field individually for deletion. Excel makes it easy to do this in just a few steps.

Excel 2007: Use Descriptions in Complex Formulas

Contributed by shamanstears on under Microsoft Excel

If you are troubleshooting a spreadsheet with complex formulas, it can sometimes be a very time consuming task to figure out what the formula is supposed to be calculating. A good practice to follow is to include a description in the formula itself so the user can more easily understand the purpose of the formula.

Excel 2007: How to Print Comments

Contributed by shamanstears on August 8, 2008 under Microsoft Excel

It can be quite helpful to have a printout of all the comments that have been inserted on a worksheet. This way you have a hard copy to use as you make any necessary changes to the worksheet.

Excel 2007: Clear All Formatting From a Range of Cells

Contributed by shamanstears 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 shamanstears 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.