Hi Reader,

Welcome to the Google Sheets Tips newsletter #229!

➜ News

I.
​We have a new chart type in Google Sheets! Timeline Views let you create Gantt-style charts for project tracking. It's rolling out over the next few weeks.

​Read more about Timeline View charts​

II.
I enjoyed this article from a tech recruiter on his experience learning Apps Script to automate work processes and save himself time.

​Tech Recruiter Tries Coding​

III.
Black Friday and Cyber Monday are fast approaching. I'll be running a sale on all of my courses, so it's a great time to snag one at a discounted price!

_______

Sponsored By

GRID makes numbers make sense

GRID is the best of numbers + narrative rolled into one kickass interactive spreadsheet model.

Use GRID to visualize your spreadsheet data, then add a cohesive narrative to pull it all together

Try GRID for free

_______

➜ Google Sheets Tip #229: Paste Special, the shortcut I use the most

Here is your Google Sheets tip, which you can think of as your Monday morning espresso, in spreadsheet form.

I'm a big fan of keyboard shortcuts, even though there are plenty I don't use (but probably should!).

But there are a handful that I use so frequently that they're second nature to me.

And of those, there is one that stands out: Paste Special

Paste Special (Values only)

I'm sure you're familiar with the copy and paste shortcuts (Ctrl + C and Ctrl + V).

Paste Special takes that a step further by letting you perform an operation as you paste the data.

99% of the time I use it to paste data as values only, which removes any underlying formulas and the formatting.

To paste as values, use the shortcut keys:

• Ctrl + Shift + V on PC/Chromebooks
• Cmd + Shift + V on Macs

It's a universal shortcut that works elsewhere too.

I find it especially useful when I'm copying from one place to another. For example, I want to copy a table from a website into my Google Sheet, but without all the crazy formatting.

Other Paste Special Operations

Paste special is more powerful than just pasting values, however.

Right click in Google Sheets to bring up the menu. Hover over "Paste special" and you'll see the different operations you can perform on data you've copied to the clipboard:

The transpose option is another one I use all the time!

_______

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Electricity consumption in Europe in 1507​