How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Pete Your Own Question

Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 16498
Experience:  MS Office expert
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

I have excel 2007 and would like to clear all the data in my

Resolved Question:

I have excel 2007 and would like to clear all the data in my spreadsheet so I can enter fresh year 2012 data.
How do you clear the spreadsheet to start as though from scratch, yet keep the formulas and data formatting?
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Pete replied 5 years ago.

ITPeter :

Hello Bill,

ITPeter :

Welcome to JustAnswer

ITPeter :

I am Pete, and I'll be happy to assist with your Excel question.

ITPeter :

You should save the spreadsheet under a new name first, so that if any mistakes are made in clearing the old data, you will still have a copy of the original.

ITPeter :

Then to clear all the old data, you will need to select any cells that have inputted data and press the Delete button.

ITPeter :

If you have a lot of data to be deleted, there are a number of ways to select multiple cells at once.

For example, if you want to delete the entire data from a column, you can click the column header letter, then press Delete.
If you want to delete data from an entire row, you can click the row header number to select the row, then press Delete.
You can also select a block of multiple cells by clicking and holding the left mouse button whilst hovering over the first cell, then drag the mouse to make your selection.

Pete and 2 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions