Google Drive and Docs Tips
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.
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: 2
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: 1
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.
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: 5
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.
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.
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.
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: 1
Power tip
New!
Change the Google Drive default folder
Use this tip to change the default folder location in WindowsComments: 9
Beginner
Admin
New!
Google Docs size limits
A handy reminder of the size limits for docs you create and upload.
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: 1
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: 1
Power tip
New!
The difference between Add and Move in Google Drive
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: 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: 4
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: 1
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.
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!
Add bookmarks to create new Google Docs
Use these simple new document URLs to add bookmarks or shortcuts that create new documents, spreadsheets and presentations with one click.
Power tip
New!
User Submitted
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: 2
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: 2
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!
Power tip
Turn on Spreadsheet Notifications
Use Tools > Notifications to get notified by email when someone changes the spreadsheet.Comments: 1
Beginner
Google Spreadsheet limitations
Spreadsheets is good for most uses, and converts very well from Excel, but it does have some limitations.
Beginner
Spreadsheet Locale Setting
Change Locale in File > Spreadsheet Settings to ensure correct date format, currency and number formatComments: 5
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.
Subscribe to tips by email
×
Subscribe to tips by email
Please Sign In to subscribe to our tips emails