Excel Pasting Trick
October 15, 2019
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Here's a copy and paste trick that you might not know. In the screen shot below, old information is at the top, in orange cells. There's updated data in the green cells, for a couple of orders. Some data is missing though, like Region and Category names.
Here's how you can get all the new data into the orders, without clearing all of the old information.
Here's the order data, after the Paste Special. In the top section,
This Thursday, October 17th, is Spreadsheet Day -- an annual event that I started in 2010 - it's our 10th year of celebrating! (Like many computer sequences, Spreadsheet Day uses zero-based numbering.)
October 17th was selected as the celebration day, because that was the date, in 1979, when VisiCalc was first released – that was the first spreadsheet for personal computers.
On Thursday, I'll share a VisiCalc video on the blog, and you can watch it now - The Origins and Impact of VisiCalc. The panelists are Dan Bricklin, Bob Frankston, and Mitch Kapor, moderated by Charles Simonyi. It was recorded by the Computer History Museum, on April 8, 2003.
The panel discussion starts at the 7:45 mark, and ends at 1:15:00, followed by audience questions. There are lots of computer experts in the crowd! (To save time, I watched it at 1.25 speed)
Here are a few Excel-related articles that you might find useful or interesting.
Charts: On the Storytelling with Data blog, Elizabeth Ricks shows how to create a shaded range in a line chart. (Level - Int)
Statistics: If you'd like to learn more about statistical analysis in Excel, check out this list of tutorials, on the UC San Diego site. The Clemson link is broken, but you can find those tutorials here. (Level - Int)
Excel Tweets: See what people tweeted about Excel this week. Click the link in the first tweet, to see lots of lovely tweets about Excel!
I hope you had a happy Thanksgiving yesterday, if you're in Canada, like I am. We had our family dinner on Sunday, and of course I scheduled everything with my Excel holiday dinner planner!
Our granddaughter worked on another sewing project when she came to visit us -- she changed an outgrown t-shirt into a cute pillow for her room. She did all the machine and hand sewing by herself, and was very pleased with the results.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20191015ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
[email protected] contextures.com
Last updated: October 14, 2019 3:17 PM