Share this page!

Ben Collins Profile picture
Twitter logo
3 Dec, 8 tweets, 2 min read
A great way to be more efficient in #GoogleSheets is to learn basic shortcuts for selecting data.

That's what I'm going to show you today - how to select data for formulas without your hands leaving the keyboard. ⌨️

It's so much quicker than grabbing the mouse! 🖱️
I remember how awkward it felt when I first learned these shortcuts, and how it was initially slower than just using the mouse to highlight the data.

But after a few days, it was significantly quicker than using the mouse. And it will be for you too.

Here we go ⬇️
1️⃣

Move quickly to the last non-blank cell in a row or column:

PC/Chromebook: Ctrl + ⬆⬇⬅➡
Mac: ⌘ + ⬆⬇⬅➡
2️⃣

Highlight data to the last non-blank cell in a row or column:

PC/Chromebook: Ctrl + Shift + ⬆⬇⬅➡
Mac: ⌘ + Shift + ⬆⬇⬅➡
3️⃣

Highlight data, moving manually from cell to cell:

PC/Chromebook/Mac: Shift + ⬆⬇⬅➡
4️⃣

Highlight the whole dataset:

PC/Chromebook: Ctrl + A
Mac: Cmd + A

Press it again selects the whole Sheet.
5️⃣

Highlight a column:

PC/Chromebook/Mac: Ctrl + Space Bar
6️⃣

Highlight a row:

PC/Chromebook/Mac: Shift + Space Bar

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Ben Collins

Ben Collins Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @benlcollins

Ben Collins Profile picture
2 Dec
The OFFSET function is not a function you need particularly often, but it's worth knowing about because it allows you to move ranges around very easily.

#GoogleSheets thread. Let's go. 👇
The OFFSET function returns a reference to a range that is offset from a starting point in a worksheet.

For example, in the table shown in this image, imagine you want to align these columns at the top of the column.
The OFFSET function can do this with a single formula for each column, which is quicker and easier than copy-pasting or creating complex nested formulas.

The OFFSET formula in this example is:

=offset( B2:B6, 1, 0, count(B2:B6) )
Read 6 tweets
Ben Collins Profile picture
1 Dec
Have you come across floating bar (or column) charts before?

They're a useful way to show data when you want to compare ranges or high and low values.

For example, you can use floating bar charts with salary data, weather data, stock prices, blood pressure readings, etc. Image
To create a floating bar (or column) chart in #GoogleSheets, you’ll need two series in your dataset, e.g. a set of low values and a set of high values, like this salary range dataset. Image
Then follow these steps...

1. Highlight the data and Insert > Chart
2. In Setup, choose a Bar Chart (horizontal) or Column Chart (vertical)
3. Still in the chart setup menu, set the Stacking to be “Standard”
4. Go to the Customize menu

(continued in next tweet)
Read 4 tweets
Ben Collins Profile picture
8 Jul 20
A thread about #Lego, including a live build 🤓 👇

I grew up loving the stuff, from ages 3(?) to perhaps 15, from duplo blocks to cutting edge Technic. I credit Lego in part for my deep love of STEM topics.

As an adult, I've started playing it again with my own kids (1/n)
About 3 years ago, I bought the Lego Saturn V to decorate my home office. 🚀

Because #Lego + Space. No more explanation needed.

Amazing, amazing build!!

You can really appreciate the engineering in this one. Highly recommended if you can get hold of a set.

(2/n)
Recently I finished a few big work projects so it was time I built another set.

Lego absorbs your mind fully and so is a great way to distract yourself during this pandemic.

With Lego, you're in control and you enjoy the process and the outcome.

(3/n)
Read 9 tweets
Ben Collins Profile picture
14 Jan 20
Mega thread of #GoogleSheets #productivity tips & tricks coming up...

Starting with this humdinger

Type “sheet.new” or "sheets.new" into your browser to instantly create a new Google Sheet

(1/n)
From inside a folder of @GoogleDrive press

Shift + S

To create a new Google Sheet in that folder
(2/n)
Quickly freeze panes in your #GoogleSheet by hovering over the border of the sheet (just under the column letters) until you see the hand icon.

Drag down as many rows as you want to freeze.

Works for columns too!
(3/n)
Read 43 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

Like this author's thread?

Get emails when @benlcollins has new unrolls!

Check out other threads from @benlcollins!

Read all threads by @benlcollins

:(