Tame your computer – a formula for success

5 May

Have you ever had the need to keep your formulas in a worksheet, but get rid of all the other data? For example, you might want to create a new sheet for the new tax year, containing exactly the same headers and formulas, but not the data from the previous tax year.

Here’s how:

  1.  Select the rows and/or columns that contain the formulas. (Remember the quick way to select a range of cells?)
  2. On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. (Or press CTRL + G and click on the Special button.)
  3. In the Go To Special dialog box, click the Constants radio button.
  4. Click OK.
  5. Press the Delete key on your keyboard.

This will delete all the data, but leave the formulas, ready for next year’s tax year.  (Thanks for the inspiration, Melissa.)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: