We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel


Molly_Don

Likes # 0

I've started a job that requires me to use excel spreedsheets, which I'm not familiar with yet.

On my desktop, I have several spreedsheets which contain default information.

Each day I have to enter information then save the file to a folder > right click on the file > copy > paste.

When I've pasted the amended file, I go back to the orignal on my desktop and delete the information in each cell, so the file is ready for the next day.

Is there a quicker way to set the default file, should I be using > right click > cut > paste instead of deleting the new information?

Like this post
canarieslover

Likes # 0

Click 'File', 'Save As', and give it another name. That will save your work to the new file name and you will still have your original as it was.

Like this post
BT

Likes # 0

As long as your default information doesn't include number data you can use this method which will clear all the numeric data, after you have saved it as detailed by canarieslover

*Press F5 to display the "Go To" box. Select the "Special" button. Choose the "Constants" button and remove the ticks from the Text, Logicals, and Error boxes. "Numbers" should be the ONLY box ticked. When you click "OK", every numeric cell across the spreadsheet will be selected. Now manually press "Delete" to delete the values. If you have text in the spreadsheet aswell, you would just de-select the "Numbers" option and select the "Text" option*

Like this post
wee eddie

Likes # 0

I would go with Canarieslover's solution. The main consideration is the Naming of the saved File, for which I have a suggestion.

If the main Spread Sheet is called, for example, "Group Sales-Daily" I would rename your File "Group Sales-2011.04.21" or something similar. If you use the 'Year.Month.Day' format. When they get to the other end, all the Spreadsheets file themselves in date order throughout the year.

Like this post
Molly_Don

Likes # 0

Thanks for the advice, I'll give the suggestions a go.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Best Christmas 2014 UK tech deals, Boxing Day 2014 UK tech deals & January sales 2015 UK tech...

IDG UK Sites

LED vs Halogen: Why now could be the right time to invest in LED bulbs

IDG UK Sites

Christmas' best ads: See great festive spots studios have created to promote themselves and clients

IDG UK Sites

Stop running out of cellular data on your iPhone, see which apps use the most data