Quick Copy of Excel File
October 25, 2016
Make a quick copy of an Excel file, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
When I'm working on a complex Excel file, I usually create a new copy in Windows Explorer, at the start of each day. That way, I have the previous file to go back to, if something goes horribly wrong. (I also make backup copies while working, with my Excel Tools add-in -- it creates time-stamped copies.)
Last week though, I found a quicker way to make a copy. Why didn't I know about this before? Here's how to make a copy of a file you were working on recently:
Excel creates an unsaved copy of that file, with a number at the end of its name.
There are almost 500 Excel videos on my website, to show the steps in my Excel tutorials. Some people prefer to read the instructions, with a few screen shots, and other people like step-by-step videos. Which do you prefer?
Last week I noticed that the volume control bar is missing on a few of the videos, so you might not be able to hear them -- that's not good! I'm working to fix all of them, but in the meantime, if you find a video on my website that doesn't show a volume control bar, start playing the video. Then, use your keyboard's up and down arrows to adjust the volume. And send me a link to the page, if you can, so I'll be sure to fix it.
And if there are any tutorials on my website that don't have videos, and you'd like to see one, please let me know!
Here are a couple of Excel articles I read recently, that you might find useful.
Spreadsheet Tasks - How many ways can you use a spreadsheet, besides financial analysis? Dan Bricklin and Joel Spolsky both shared this link on Twitter, so that made me want to read the article! (Level - All)
Lookup Function - Doug Jenkins wrote a User Defined Function (UDF) that returns the Nearest value when doing a lookup. Read about it, and download the sample file. (Level - Intermediate)
We've had beautiful weather this month, with days that felt like summer. You can tell that it's autumn though, because the leaves have changed colour. This little tree, in front of our house, looked pretty against a bright blue sky, despite losing most of its leaves on a windy day.
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:53 AM