Donate SIGN UP

microsoft excel

Avatar Image
watteee | 10:40 Mon 13th Apr 2009 | Technology
3 Answers
hi all,im just about to start a new spreadsheet on microsoft excel for to do my accounts.as its the start of a new tax year i need the same sheet as last year but without the entries.i still need all the headings,hope thats clear. any help appreciated
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by watteee. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Save the spreadsheet with a new name.

Open the new spreadsheet and use the mouse to highlight the text to be deleted.

This usually consists of clicking in the top left, then holding the left mouse button, then dragging to the bottom right.

So the whole block of text should now be selected.

Now press the delete button and the whole of the text should be deleted.

If you cant do it in one go, do it in smaller chunks, a few blocks of text at a time.
Question Author
ok but what about the original one i want to keep
that's why you make a copy ...
using save as ... and entering a new name will create a new file leaving the old one in tact

as VHG says ... clear the data ... and save ... and you are set to go
... you might need to update the date fields

1 to 3 of 3rss feed

Do you know the answer?

microsoft excel

Answer Question >>