Contextures

Contextures News

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.

Quick Copy of Excel File

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:

  • Click the File tab on the Excel Ribbon, then click Open
  • In the list of Recent files, right-click on a file, then click Open a Copy

Excel creates an unsaved copy of that file, with a number at the end of its name.

open a copy

Volume on Excel Videos

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!

video volume

Excel Articles

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)

Also, see all my Excel products on my Contextures website, and my weekly collection of humorous Excel tweets.

Leaves Are Falling

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.

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:53 AM