Contextures

Contextures News 20191015

Excel Pasting Trick

October 15, 2019

Spreadsheet Day, pasting trick, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Skip Blanks

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.

paste special skip blanks

Here's how you can get all the new data into the orders, without clearing all of the old information.

  1. Copy the green cells
  2. Right-click the top left orange cell, and click Paste Special
  3. In the Paste Special window, add a check mark in Skip Blanks, then click OK

Here's the order data, after the Paste Special. In the top section,

  • Green cells show where the new data is.
  • Orange cells still have old data, because those cells were blank in the green update cells

There are detailed steps and a video on my Contextures blog, and a sample file to download.

paste special skip blanks

Spreadsheet Day

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)

Excel Articles

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!

Also see: My Excel Products || Previous Issues

Pillow Project

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.

weekly photo

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.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

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

contextures newsletter info

 

Related Links

Paste Special Tip

Spreadsheet Day

Holiday Dinner Planner

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: October 14, 2019 3:17 PM