Google Drive and Docs Tips

Power tip New!

An easier way to delete a file from Google Drive

A recent update has introduced the ability to delete a file whilst it is open. Here's how to do it.
New!

Viruses: How Drive Detects and Protects

Google Drive screens files for viruses and malware to prevent downloading infected files and help protect your data and computers.
Power tip New!

Working with zip files in drive

ZIP Extractor extension enables efficient management of zip archives within Drive.
Power tip

Make more space in a document

Reduce the whitespace in non-print documents.
New!

Get Smart with Default Styles in Docs

Save time & be consistent via default style preferences within Docs.

Comments: 1

Power tip

Customise your Styles in Google Docs

You can customise the look of headings and text in your document directly from your toolbar, and set the new styles as default for future documents.

Comments: 1

Power tip New!

Edit images in a Google Doc

Google have announced that users can now edit images in Drawings and Slides, here's how to do it in a Google Doc.

Comments: 1

New!

Try out new Google Sheets

The new version of Google Sheets is currently on the Rapid Release track only but will be available to everyone by the end of April 2014, if you haven't tried it yet, use this tip.

Comments: 1

Power tip New!

Add bookmarks to create new versions of Google documents

Avoid having to find your Drive tab to create new Docs/Sheets/Slides - simply create bookmarks, if you know the secret URLs...

Comments: 1

New!

Reduce Drive Usage and Increase Performance via Gmail Doc Search

This tip reduces the need for Drive and boosts performance whilst conserving battery power on a Chromebook or laptop.
Power tip New!

Find specific file types in Google Drive

Rapidly pinpoint the file you're after with an advanced Drive Search using MIME Types and combination searches.
Power tip New!

Use editable themes in Google Slides to bring your presentation to life

Check out the editable master slides feature to create tailored slide presentations.
Beginner Admin Power tip New!

The difference between Add and Move

It's very easy to drag files and folders around in Google Drive, too easy in fact, and dragging items moves them for everyone in your domain... so take care.

Comments: 13

Power tip New!

Save PDFs and web pages directly to Drive

A few tips to simplify saving PDFs and web pages directly to Google Drive.

Comments: 3

Beginner Admin

Google Docs Size Limitations

A useful summary of Google Docs, Spreadsheets and Presentation size limits to bear in mind when uploading and converting.

Comments: 1

Power tip New!

Advanced Searches on Google Drive

These advanced search tips will help you get the most out of the search box at the top of Google Drive.

Comments: 11

Power tip New!

Count the number and type of items in a Google Drive folder

A quick tip if you need to know how many files are in a folder in Google Drive - and it also shows you how many of each type you have.

Comments: 3

Admin Power tip New!

Managing Microsoft Office files in Google Drive

If you plan to make use of Google Drive and continue to use Microsoft Office, or any non-native files, it's important to understand how Drive manages file versions.

Comments: 7

Beginner New!

A look at Google Drive settings

Settings in Google Drive is where you can set your Language, Time Zone and choose whether you want Docs to open in a new window and show in bold if they've been updated.

Comments: 1

Beginner Power tip New!

Data import wizard for PDF to Google spreadsheet

A handy tool to help you copy and paste table data from a PDF into a Google Spreadsheet.

Comments: 4

Beginner Power tip New!

How to transpose data in a Google spreadsheet

Excel has a useful transpose feature when copying and pasting. Here's a tip to do the same in a Google spreadsheet.

Comments: 4

Beginner Power tip New!

Don't forget the advanced editor sharing settings

When giving editing rights to collaborators, consider what further permissions you want them to have.

Comments: 3

Power tip New!

Store Google Forms in Gmail for easy access from your inbox

If you use Google Forms regularly, email the forms to yourself or your users and use an email label for easy access.
Power tip

Protect individual cells in Google Spreadsheets

Individual cells or a cell range can be protected in Google Spreadsheets with this tip.

Comments: 6

Power tip New!

Add your Google Drive folder to Documents in Windows

Use this tip to add Google Drive to your Documents folder in Windows, so it is always easy to find.

Comments: 3

Power tip New!

Change the Google Drive default folder

Use this tip to change the default folder location in Windows

Comments: 71

Beginner Power tip New!

Organise from within a Google Document

You can place a Google doc, presentation, spreadsheet, or any file into a folder from within the document using the folder icon next to the file name.

Comments: 1

Power tip New!

Use the paint format tool in a document to quickly copy formatting

The paint format tool in Google documents lets you copy the formatting you have applied to a specific section of text to another section.

Comments: 1

Power tip New!

Advanced copy and paste with web clipboard

Copy and paste in Google Docs becomes a lot more powerful when using the web clipboard, allowing you to queue items to paste and add tables or charts to a document.

Comments: 4

Admin Power tip New!

Protect your Google Drive folders by setting permissions

Set folders to "View only" in Google Drive to ensure users don't accidentally remove sub-folders and files.

Comments: 4

Power tip New!

Add specific people to a comment in Google Docs

You can easily tag collaborators in a Google document so they receive an email notification.

Comments: 2

Power tip New!

Teach Google Docs your common misspellings

If you often misspell words whilst typing then Google Docs spell check has a great feature that allows you to train it to recognise those words and auto-correct them as you type.
Power tip New!

Fact find without leaving your Google Document with the Research pane

Google Docs now has a really useful Research pane that allows users to access the power of Google Search from inside a Google Document.
Beginner Best Practice New!

Save time with a Google Drive template

Since Google have just announced 60 new templates, if you haven't checked out Google Drive templates yet, now is a good time.

Comments: 7

Power tip New!

3 ways to protect your Google Spreadsheet data

Protect your Google Spreadsheet data from accidental or malicious changes with these 3 methods.

Comments: 6

Power tip New!

Use Sort feature to find large files in Google Docs

If you want to know how large your uploaded files are in Google Docs, sort by Storage used to see document size.

Comments: 1

Beginner New!

Hide rows and columns in a Google Spreadsheet

To hide a row or column in a Google Spreadsheet, right click the row number or column letter and choose the hide option.

Comments: 3

Beginner New!

Add a description to your Google Docs

Use the preview button to open up a right hand menu, where you can add a description to your Google Doc, Spreadsheet, Presentation or any file.

Comments: 1

Power tip New!

Fill Google Spreadsheets with series of values

As with Excel, a Google spreadsheet can have automatically fill a series of cells - e.g. months of the year, sequential numbers, football teams and almost anything else!
Power tip New!

Remove zero values from a Google spreadsheet

Sometimes you need to see the data that is important in a Google spreadsheet - and get rid of annoying zeros, this tip helps you do just that.

Comments: 4

Power tip

Drag and drop

Drag mutiple files from Windows Explorer into the documents list to upload them.
Beginner New!

Managing data in spreadsheet with the help of List View

The List View option provides a minimalistic view of your spreadsheet data. It's particularly useful for those that have viewing rights only, but have a great amount of data to manage. If you're trying to access a spreadsheet with more than 50 users currently viewing it, you'll be automatically redirected to list view.
Power tip

See all Comments in a Google Doc - even resolved ones

Click on the "Comments" button at the top of a Google Doc to see all comments and discussions that have taken place in a document or presentation.

Comments: 14

Power tip

Some of the best keyboard shortcuts

If you use keyboard shortcuts, below are our favourites - well worth learning even if you don't normally use them!

Comments: 1

Power tip

Turn on Spreadsheet Notifications

Use Tools > Notifications to get notified by email when someone changes the spreadsheet.

Comments: 3

Beginner

Google Spreadsheet limitations

Spreadsheets is good for most uses, and converts very well from Excel, but it does have some limitations.

Comments: 2

Beginner

Spreadsheet Locale Setting

Change Locale in File > Spreadsheet Settings to ensure correct date format, currency and number format

Comments: 11

Advertisement

Capsule CRM