The ‘Microsoft Excel’ Archives
Posted February 16, 2012 by

Office 2010: Add, remove or modify a trusted location

Office programs like Word, Excel or PowerPoint all have a Trusted Location. Documents in this location will be opened without being checked by the Trust Center; and therefore, they will be opened without Protected View. If you want to get rid of the annoying Protected View mode, just follow these steps.

Posted November 25, 2011 by

Excel 2010: Change the number of sheets in a new workbook

By default, when you create a new Excel workbook, the program will create three new sheets for you. If you usually work on only one sheet, the rest will be unnecessary. Or if you always have to work on a big workbook, then three sheets may be not enough and you have to manually create […]

Category Microsoft Excel

Posted March 3, 2011 by

Using Autosum with Microsoft Excel

Many people use Microsoft Excel to crunch numbers and keep track of sales. It’s ability to insert and utilizing formulas is incredible. This tutorial and screencast demonstrates Excel’s powerful autosum feature to calculate the sum and the average of a column of numbers.

Category Microsoft Excel

Posted August 18, 2009 by

Microsoft Excel: How to Hide Tabs

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.

Category Microsoft Excel

Posted April 27, 2009 by

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

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.

Category Microsoft Excel

Posted November 30, 2008 by

Excel 2007: How to Sort Rows

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.

Category Microsoft Excel

Posted August 12, 2008 by

Excel 2007: How to Clear the Values while Keeping Formulas

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.

Category Microsoft Excel

Posted August 12, 2008 by

Excel 2007: Use Descriptions in Complex Formulas

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.

Category Microsoft Excel

Posted August 8, 2008 by

Excel 2007: How to Print Comments

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.

Category Microsoft Excel

Posted August 4, 2008 by

Excel 2007: Clear All Formatting From a Range of Cells

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.

Category Microsoft Excel

Posted July 16, 2008 by

Excel 2007: Using a Background Image

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.

Category Microsoft Excel

Posted July 15, 2008 by

Excel 2007: Have Your Data Read Back To You

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 […]

Category Microsoft Excel