Zap the Numbers, Keep the Formulas

Posted by : Dexter Panganiban | ; Filed Under Tips and Tricks

Welcome back! You might want to check my Archives and let me take this opportunity to invite you at my Make Money Online Personal Blog

Let me share you some tips for that I got from my bunch of files. I cannot link to the main source since I don’t have it . All I can say based on the documents I have this is a reprint from PCWorld.

One common type of spreadsheet is a fill-in-the-blanks template. Typically, such a sheet will have a number of input cells, and a number of formula cells. You enter your data in the input cells, and the formula cells kick into action and use those values to display some type of (usually) useful result.

For example, you may have a worksheet set up to calculate a loan amortization table. Input cells would include items such as loan amount, interest rate, loan term, and so on. Formulas in other cells use this information to display the
calculated results.

At some point, you may want to clear the slate and delete all the values in the input cells. Rather than scroll around and look for the non-formula cells, you can take advantage of an often-overlooked Excel feature that lets you select cells in a “special” way:

Select Edit, Go To (or press Ctrl-G or F5)to bring up the Go To dialog box.

Click the Special button to show the Go To Special dialog box.

Choose the Constants option, then clear all of the check boxes except Numbers (if some of the input cells in the spreadsheet accept text, leave the check mark next to Text).

Click OK, and Excel will select all of the non-formula cells that contain a value.

Press the Delete key, and those numbers are history but the formulas remain intact.

This is a good exercise if your work is repetitive in a table full of formulas.

Free Credit Card Numbers
I don't know why lots of people are looking for Free Credit Card Numbers maybe you will use it for e...
Free Credit Card Numbers

I found out that there are lots of people looking for Free Credit Card Numbers, b...
Windows XP and Vista Crack, Serial Numbers and Keygen
This is an old post , but it seems you reached this post from searching Windows XP and Vista Crack, ...
How To Change Wordpress Permalink
Another Excel Control Hot Keys Part 1 of 3

About the author

Dexter Panganiban : Dexter is a techie person that also blogs at his Personal Blog " Dexter Panganiban Site ", He is a Mechanical Engineer by Profession. He loves Search Engine Optimization and Making Money Online