30 Google Sheets Shortcuts That Will Save Marketers Hours Every Week

As a marketer, you probably spend an inordinate amount of time working in Google Sheets. From tracking campaign metrics to analyzing website traffic to building reports for clients and bosses, spreadsheets are the lifeblood of marketing. In fact, a recent study by Deloitte found that marketers spend an average of 3.55 hours per day working in spreadsheets – that‘s nearly half the workday!

While Google Sheets is undoubtedly a powerful tool for crunching data and deriving insights, all of that clicking, dragging, and formula typing can really eat up the hours. Wouldn‘t it be great if there was a way to do common marketing tasks faster and more efficiently? Fortunately, there is! By learning a core set of Google Sheets keyboard shortcuts, you can dramatically speed up your workflow and spend less time wrestling with your data and more time acting on it.

In this guide, we‘ve compiled the 30 most useful Google Sheets shortcuts specifically for marketers. These underrated tricks will help you navigate, format and analyze your marketing data at lightning speed. Say goodbye to the slow slog of menu-clicking and mouse-dragging and hello to spreadsheet wizardry!

Navigating & Selecting

Scrolling and clicking around large datasets is a huge time-suck. These shortcuts will help you zip around your sheets and select the data you need in a flash:

Shortcut PC Mac
Select column Ctrl + Space ⌘ + Space
Select row Shift + Space Shift + Space
Select all Ctrl + A ⌘ + A
Move to start of row Home Fn + ←
Move to end of row End Fn + →
Move to start of sheet Ctrl + Home ⌘ + Fn + ←
Move to end of sheet Ctrl + End ⌘ + Fn + →

For example, let‘s say you have a huge spreadsheet with social media metrics for 50 posts. You need to quickly check the total number of clicks for each post. Rather than slowly dragging your cursor down the "Clicks" column, just hit Ctrl + Space (or ⌘ + Space on a Mac) to instantly select the entire column. Then you can copy, format, chart or total the data from there.

Or perhaps you need to audit UTM parameters on a big list of URLs. Use the Home and End keys to jump from the start of a long URL to the end where the UTM parameters live, rather than holding down the arrow keys to slowly move the cursor.

Inserting & Deleting

Adding and removing rows and columns is a common task when building out marketing reports and dashboards. Don‘t waste precious seconds with the awkward hover-and-right-click dance – use these shortcuts instead:

Shortcut PC Mac
Insert row above Ctrl + Alt + Shift + = ⌃ + ⌥ + I then R
Insert row below Ctrl + Alt + = ⌃ + ⌥ + I then B
Insert column left Ctrl + Alt + Shift + = ⌃ + ⌥ + I then C
Insert column right Ctrl + Alt + = ⌃ + ⌥ + I then O
Delete row Alt + E then D ⌃ + ⌥ + E then D
Delete column Alt + E then E ⌃ + ⌥ + E then E

These shortcuts become second-nature very quickly once you start using them. Need to add a new row for another email metric? Bam! Ctrl + Alt + = (or ⌃ + ⌥ + I, R on a Mac). Client wants to remove the "Avg. Session Duration" column from their web traffic report for some baffling reason? No problem! Alt + E, E and it‘s gone.

Formatting

Let‘s be real: as much as we marketers love data, it can often look like an impenetrable wall of numbers. Make your reports easier to scan and interpret by quickly formatting data with these shortcuts:

Shortcut PC & Mac
Bold Ctrl/⌘ + B
Italics Ctrl/⌘ + I
Underline Ctrl/⌘ + U
Strikethrough Alt + Shift + 5 (PC) or ⌘ + Shift + X (Mac)
Increase font size Ctrl/⌘ + Shift + .
Decrease font size Ctrl/⌘ + Shift + ,
Clear formatting Ctrl/⌘ + \
Paste values only Ctrl/⌘ + Shift + V

Identify key takeaways by making them bold or highlight important caveats with italics. If you‘re a stickler for consistent font sizes, quickly bump text up or down with Ctrl/⌘ + Shift + . or ,. And every marketer knows the pain of pasting data from another source only to have the existing formatting wreak havoc on your carefully crafted sheet. Worry no more – just hit Ctrl/⌘ + Shift + V to paste unformatted values only. It‘s the spreadsheet equivalent of "out, damned spot!"

Functions & Formulas

Ah, formulas. The most powerful and perplexing part of spreadsheets. While there‘s no shortcut to magically make you a formula whiz, these shortcuts will help you work with them more efficiently:

Shortcut PC Mac
Insert function Shift + F3 Shift + Fn + F3
Toggle absolute/relative references F4 ⌘ + T
Array formula Ctrl + Shift + Enter ⌘ + Shift + Enter
Expand/collapse array formula Ctrl + E ⌃ + E
Show formula help Shift + F1 Shift + Fn + F1
Full formula help F1 Fn + F1
Reveal formulas Ctrl + | ⌃ +

Instead of searching through the Insert > Function menu to find the formula you need, just hit Shift+F3 to browse commonly used marketing functions like SUM, AVERAGE, VLOOKUP, etc.

One of the most powerful shortcuts is the F4 key, which toggles absolute and relative cell references in formulas. For example, let‘s say you want to calculate percent change in website sessions between two time periods. You might use a formula like =(B2-A2)/A2 to calculate the percent change between the sessions totals in columns A and B. But what happens when you copy that formula down to calculate percent change for other metrics like pageviews, time on site, etc? The cell references will change, resulting in incorrect calculations. To keep the column references locked (absolute) while still allowing the row references to change (relative) when copied, just hit F4 twice after selecting A2 and B2 in the formula. This will add dollar signs to lock the columns in place, e.g. =(B$2-A$2)/A$2. Now you can copy that formula down and bask in your error-free calculations.

Analyzing Data

Of course, the real power of Google Sheets lies in being able to slice, dice and visualize your marketing data to uncover actionable insights. Here are some handy shortcuts for analyzing data:

Shortcut PC & Mac
Format as number Ctrl/⌘ + Shift + 1
Format as time Ctrl/⌘ + Shift + 2
Format as date Ctrl/⌘ + Shift + 3
Format as currency Ctrl/⌘ + Shift + 4
Format as percentage Ctrl/⌘ + Shift + 5
Insert current date Ctrl/⌘ + ;
Insert current time Ctrl/⌘ + Shift + ;
Group columns/rows Alt/⌥ + Shift + →
Ungroup columns/rows Alt/⌥ + Shift + ←
Hide row Ctrl/⌘ + Alt + 9
Unhide row Ctrl/⌘ + Shift + 9
Create filter Ctrl/⌘ + Shift + L

One of the most common data analysis tasks is filtering a large dataset down to only the most relevant information. With the Ctrl/⌘ + Shift + L shortcut, you can turn any dataset into a filterable table in a single keystroke. This will add filter controls to each column header, allowing you to easily sift by web traffic source, geographic region, product category or any other dimension.

The grouping shortcuts (Alt/⌥ + Shift + arrows) are also incredibly useful for visualizing data over time. Let‘s say you have a table of weekly blog post performance metrics. By highlighting the "Week" column and hitting Alt + Shift + Right Arrow, you can instantly group the data by week, allowing you to collapse or expand each group as needed. This makes it much easier to identify trends and week-over-week changes rather than getting lost in the granular data.

Power User Tricks

Ready to take your Google Sheets skills to the next level? Try out these advanced shortcuts:

  • Press Alt + Shift + K (PC) or ⌥ + Shift + K (Mac) to enable compatible spreadsheet shortcuts, allowing you to use hundreds of Excel shortcuts in Sheets.
  • Enable the Explore panel with Alt/Option + Shift + X to get AI-powered data insights and visualization suggestions.
  • Record a macro with tools > Macros > Record macros to save time on repetitive tasks
  • Access scripts, macros and add-ons quickly with Alt/Option + Shift + T
  • Insert links to other sheets with Alt/Option + Shift + V and create your own custom shortcuts through the Tools > Macros menu

The more you use these shortcuts, the more they become like reflexes, allowing you to whiz through marketing data and analysis. While mastering spreadsheets certainly won‘t replace the insight, creativity and storytelling required of great marketers, it will free up more of your time and brainpower to focus on those higher-value activities.

How to Remember All These Google Sheets Shortcuts

If this all seems like a lot to memorize – don‘t worry! You don‘t have to become a spreadsheet robot overnight. Start by picking five shortcuts that correspond to your most common Sheets tasks. Write them down on a sticky note or save them to a document and challenge yourself to use them whenever you‘re working in Sheets.

Once those first five shortcuts become habits, pick a few more to learn. Before long, you‘ll be flying through your data with ease. And if you ever forget a shortcut, just press Ctrl/⌘ + / (forward slash) to bring up an interactive menu of keyboard shortcuts for easy reference.

To make learning these shortcuts even easier, we‘ve compiled them all into a [downloadable cheat sheet]() you can print out and keep next to your computer. Pin it up on your cubicle wall to assert your dominance as the office spreadsheet sensei.

Reclaim Your Workday With Google Sheets Shortcuts

We marketers need every competitive advantage we can get in today‘s data-driven business world. While spreadsheets may not be the sexiest skill to master, they are often the difference between guessing and knowing what‘s working. And in marketing, it‘s our job to know.

By taking the time to learn these Google Sheets shortcuts, you can dramatically reduce the time and effort required to track, analyze and report on your marketing efforts. That means more time for planning and optimization and less time lost in the data weeds.

So embrace your inner data nerd, break out that cheat sheet and start putting these shortcuts to work! Your team (and your wrists) will thank you.