Our Absolute Google Doc Tips & Tricks

Throughout the agency we rely on all sorts of Google Documents to make our everyday working lives easier, from sharing assets with clients to making sure work is easily accessible to the whole team. Many also act as in-working documents, allowing members of the A-Team to dive in and out of their tasks easily without having to send documents back and forth all the time (queue the inbox clutter). Head of Outreach, James, is especially familiar with such documents, working alongside his team to keep various spreadsheets up to date. He’s shared some of his favourites with us, below.

Absolute Mastery

Whether you’re completely new to Google Documents and are looking for a good place to get started or have been using it for a number of weeks, months or even years now, what many don’t know is that you can access all the shortcuts at once by selecting ALT + /. So, the next time you’re endlessly scrolling down a complex sheet of data, stop and consider whether you could utilise a shortcut to help you complete your task quicker or, in some cases, more accurately.

The Real Deal

We have several favourite keyboard shortcuts here at Absolute Digital Media, and my team often rely on these throughout the day to ease the pressure of deadline-based tasks and others that just need to be completed as efficiently as possible.

The Real Deal - Add The Date To Your Sheet(s)

Time flies, especially when you’re immersed in a large spreadsheet of data! In case you don’t have the current date easily accessible at the top of your laptop, computer or the device you are using, you can use the following the insert the date:


The Real Deal - Add The Time To Your Sheet(s)

In Need Of Marketing Support?


Adding the time as well as the date to your working document can be super useful, especially if you need to showcase exactly when a certain action was performed for simply want it for your records to keep track of how long a task takes to complete. To add the current time to your document, follow these steps:

CTRL + Shift + ;

The Real Deal - Add The Date & Time To Your Sheet(s)

Whilst you can carry out both of the above actions to insert the date and time to your Google sheet or document separately, time is of the essence. You can easily insert the current date and time to said document by entering:


Quickly Sort Lists

We at Absolute Digital Media are often faced with information-filled documents that are, on occasion, sift time-consuming to through. Instead of endlessly scrolling through said information, list or data, there are a number of ways you can sort through it.

To highlight all the text in a column, select: CTRL+SHIFT, followed by the down arrow

Quickly Sort Lists on excel


To move said text to the left-hand side of the cell, select: CTRL +Shift + L

Quickly Sort Lists on excel


Alternatively, to move said text to the centre of the cell, select: CTRL +Shift + E

Quickly Sort Lists on excel


Should you need to move said text to the right of the cell, you can also do so by selecting: CTRL +Shift + R


Quickly Sort Lists on excel

Select All Of Your Data

When it comes to inserting new data into a Google Document or adding information from multiple sources, we sometimes need to adjust the font or size of our text amongst other things to ensure our sheets remain easy to read. If you’re familiar with selecting and editing each cell, did you know that, by clicking the top right corner of the sheet, you will actually highlight every cell? It’s a game changer!

Select All Of Your Data on excel

Work Offline

Many of us a familiar with working from home now and are used to being able to work in the comfort of our homes. However, working from home can sometimes come with its disadvantages such as internet and power outages that may reap havoc within your team or business. If you are one of said victims or are simply planning to work on the go as you travel to your next location (such as a client meeting) you can turn your sheet to “work offline”. Whilst you’ll still be able to update your sheet or document as needed, it won’t update for shared users until you reach a connection, helping to make sure that you can utilise all your time including that spent going from A to B.

Work Offline on excel

View Your Edit History

It’s good to know when your sheet was last edited to make sure that you don’t duplicate your own or a colleagues work. Through selecting “show edit history” within your Google sheet or document, you’ll be able to view exactly when it was last edited, including what has been changed to help you stay fully up to date without having to reach out to your team for constant updates.

View Your Edit History on excel

View Your Edit History on excel

Are Your Ready To Take Your SEO To The Next Level?

Conditional Formatting

Conditional formatting is yet another favourite of mine, allowing the team to format cells in a different colour when containing specific text. It’s really easy to set up and, when used properly, can provide you and your team with a visual representaton of your progress. You can also create a rule whereby the same happens but if you reach a certain number. Here’s how:

  1. Right click your mouse and select “conditional formatting
  2. Within “format cells if”, update the drop down menu to “text is exactly”
  3. In the space underneath, write what you want the cell to contain (a value or phrase)
  4. Select your preferred cell colour (this will be the colour of the cell when it contains the specified value or phrase inputted in the above step).


Conditional Formatting on excel

Quickly Scroll Through Multiple Tabs

Funnily enough, I discovered this one when I accidentally dropped my mouse, not realising that you could actual use it to scroll through the different tabs on your Google Sheet rather than repeatedly clicking on the arrow on the right hand side to find the one you need.


Quickly Scroll Through Multiple Tabs on excel


So, there you have it! All of my favourite Google Document tips and tricks summed up into one. There are, of course, so many other shortcuts available to utilise across all of Google’s documents, but these, for us as a team, have been the most beneficial. I’d love to hear about the shortcuts, tips or tricks you may know too! Tweet me at @JamesWSEO.


For more information or to discuss your own digital marketing requirements, call one of our expert team today on 0800 088 6000.

James Wood
James Wood
Outreach Manager

James is our Outreach Manager, whose expertise lies in building strong relationships with key influencers, bloggers, webmasters and journalists to help our client’s build up their brand reputation. James has read more.

Our Digital Marketing News

Increasing Conversions Over 126% for Hair Loss Restoration Brand Vera Clinic

We’ve been working with Vera Clinic, a leading hair clinic and cosmetic surgery hospital, for a couple of years now and supported them throughout the complications Covid-19 presented.  We have

SEO Strategy – Where The F**K Do I Even Start?

Have you ever been handed a client project or started a new role in-house and been asked to pull together the strategy for an organic campaign, and just thought ‘where

Why Your Ecom Data Sucks? – Actionable Insights Outside Of The Box

This might sound obvious but its’ shocking the number of sites and projects which treat tracking as an afterthought. The age old phrase: “what gets measured gets done” applies very

Start Now!

Join The Leading Digital Marketing Agency

Fill out the form to take the first step to digital success! Our digital marketing agency consultants are always on hand to hear from new businesses and answer any questions you may have. Select the services you're interested in and add any additional information about your digital marketing goals below, and we'll get back to you as soon as possible.

    • Goal
    • Service
    • Industry
    • Budget
    • Info

    What is your goal?

    I want to drive more leadsI want to earn more online salesI want to improve my ROII want to improve brand awareness

    What service are you looking for?

    SEOPPCDigital PRLink BuildingOther (Marketplaces, Paid social...)

    What industry you are in?

    What is your monthly budget?

    £2,000 - £5,000£5,000 - £10,000£10,000 - £20,000£20,000+ We are currently using an agencyLooking for an agency ImmediatelyWithin 1-2 monthsWithin 3-6 monthsIn 6+ months time

    Please provide us with your contact details
    so we can fulfil your enquiry.

    Subscribe me to the latest digital marketing updates and promotional information