21 Tips to Make Google Docs, Sheets and Slides Work for You

Google Docs , Sheets , and Slides have evolved to become very factor online productiveness tools , enabling you to roil out document , spreadsheets and presentations from any computing machine ( with other collaborator , if necessary ) . But are you take full advantage of everything these internet apps have to proffer ? These 21 bakshis will save you clock time , meliorate your work , and help you do more with these apps .

1) Create new files with a URL

Set up a row of bookmark withdocs.new , sheets.new , andslides.newin them , and you ’ve get a one - click mode of afford up new documents , spreadsheet , and presentations in your Google Drive — think of all the second you ’ll deliver by not using the menus each clock time .

2) Get ready to go offline

Do n’t rent a break in cyberspace connectivity slacken you down by enable offline redaction and filing cabinet creation in Docs , Sheets , and Slides : From the mainGoogle Drivescreen on the web , click the cog picture ( top right ) , then choose circumstance , then ticktack the checkbox next to Offline .

3) See more on the screen

If you do utilize Google Drive on the World Wide Web to get at Docs , Sheets , and Slides , you may launch the same options pane ( see above ) and fit more files on the screen at once , via the Density drop - down fare — you get to choose between Comfortable , Cosy , and Compact .

4) Watch your word count in real time

Google Docs on the internet recently add together the choice to see your word count rise ( and devolve ) in substantial time , which might avail you hit your deadline faster . peck Tools and Word tally , then tick the box mark Display Christian Bible count while typecast ( other stats can be shown too ) .

5) Speak before you’re spoken to

Have you ever launch the experiment to see if you’re able to speak quicker than you’re able to typecast ? In Google Docs on the entanglement , dawn Tools and Voice typing , then try dictating document rather than tapping them out ( you might be surprised at how good the transcription is ) .

6) Link your own documents

Did you know you may colligate between written document ? When you hit Ctrl+K ( or Cmd+K on a Mac ) , just paste in the file universal resource locator or search for it in the tie-in box ; you’re able to replace “ edit ” with “ preview ” at the end of any Docs URL to link to a clean version of a document .

7) Turn back the clock

Docs , Sheets , and slide come with more than just a uncomplicated undo option — they offer a layered version account so you may go back to that version from last Sunday you really liked , or from before that guy from accounts got involved . Click File then Version history .

8) Type what you meant to type

Docs comes with an Automatic Substitution tool that wreak a picayune number like the autocorrect on your sound — you’re able to use it to displace coarse mistakes or even to apply cutoff for sealed words and phrases . Select Tools and then Preferences to make change to the list .

9) Change up the fonts

physician live on the WWW , so you may put down in a few newfangled fonts with ease : They can revamp the look of a document and even boost your productiveness . Click the font fall - down on the toolbar , then choose More fonts , and you’re able to range through a wide selection of typefaces .

10) Change up the font rotation

Google Sheets is more various in terms of layouts than you might have realized : employ the Text rotation button on the right of the toolbar on the vane to put text at a sure angle . Either pick from one of the presets that appear , or enter an slant for the text manually .

11) Get alerted of any changes

Sheets will ping your inbox as soon as there ’s any alteration to a share spreadsheet , if you like : penetrate Tools then Notification rules to configure the means this works . you could blame between getting alerts straight away and getting a daily e-mail digest of all the change .

12) Know your shortcuts

Keyboard shortcuts are of course one of the ultimate productivity drudge , and Docs , Sheets , and Slides have got a bunch of them you may make utilization of . To see the keyboard shortcuts at your disposal , opt Help then Keyboard shortcuts from inside one of the vane apps .

13) Let macros do all the work

Take some of the strain off your aching fingers by assigning macro to rough-cut tasks in Google Sheets — if you unfold up the Tools menu you could snap Macro then Record macro to register keystrokes and clicks that can then be replayed at any time with a shortcut .

14) Lock down specific cells

Having multiple people work on one spreadsheet in sheet of paper can make it knockout to keep caterpillar track of what ’s what , and to ensure sure information stays fixed . By selecting a group of cells , aright - clicking , then choosing Protect cells , you could put limits on who can make edits .

15) Supercharge sheets with IFTTT

Google Sheets figure out nicely with a boniface of third - company plug - In and services , including the always excellentIFTTT(If This Then That ) . It ’s potential to create reflex feeds for all kind of useful datum , from the info stored on your physical fitness tracker to the day ’s conditions .

16) Duplication made easy

There ’ll be pile of time in Google Slides where you want to make an very copy of an object or text box , and the entanglement app include a useful shortcut for this : take hold down Ctrl ( Windows ) or Option ( Mac ) , then click and cart an object to make a duplicate next to it .

17) Trim videos inside Slides

Do n’t panic if you only want to show part of a YouTube video inside one of your presentations in Slides , because this can be orchestrate for you : Right - flick on the video recording , choose Format choice , and expect under the Video playback options on the rightfulness .

18) Get some guidance

You want your presentations to look their best , so ensure your slide are neatly arranged . From the View and Guides menu , use Show usher to display guidelines , and Edit guides to modify them . Make certain View , Snap to , Guides is selected as well .

19) Use add-ons as time savers

If you ’re wrangling with trying to create something on a coast , an add - on can probably serve — select minimal brain dysfunction - ons then Get minimal brain damage - ons to see what ’s on offer . They cover interactive questions , flow sheet , music notation , live polls , maths par and much more .

20) Don’t start from scratch

You might often need to progress a novel slide that ’s very nearly match to one that you ’ve already create . Right - select a swoop thumbnail on the odd and prefer Duplicate slide .

21) Make the most of your Chromecast

When it come to presenting your Slides presentation , why not make use of Google ’s ownChromecast applied science , if it ’s set up wherever you are ? It ’s simple and reliable , and you could connect by clicking the arrow next to Present , then Present on another concealment .

Google DocsGoogle Drive

Get the estimable technical school , science , and refinement intelligence in your inbox day by day .

News from the future , present to your present .