Month: August 2011
Auto Replace feature in Google Docs
This tutorial talks about the Auto Replace feature available in Google Docs. Using this feature, Google Docs users can add abbreviation and their corresponding words. For example, if you want to the entry da to be replaced with digianswers then you can do the following Click the Tools menu and select Preferences from the displayed…
How to validate an email addresses in Google Spreadsheet
In Google Spreadsheet you can check whether the value entered is a proper email address by creating a data validation rule. This rule does a simple validation and checks for the @ symbol in the entered value. Let us say you have a column in your spreadsheet that needs to accept only email addresses, then…
Always Keep headings visible in Google Spreadsheet
When you are working with lot of data in a Spreadsheet, the headings would disappear when you start scrolling down the rows. Google Docs Spreadsheet provides users with the option for keeping the headings always visible even when you scroll down the Sheet. This can be done by using the menu option available as part…
How to enable autocomplete in Google Docs Spreadsheet
Autocomplete feature helps users by automatically filling the content of cell when users starting entering the first couple of letters in the Cell. The automatic entry is picked from the previously entered values for the same column. Let us say you have got the following list of entries in one of the column Arizona Alabama…
Change alternate row background colors in Spreadsheet using Google Apps Script
Here is a Google Apps Script that would set the background color of alternate rows in Google Spreadsheet. This script would set the background color of of the selection, this may not be an efficient script but would do the job. Let us take the following sample data which will be used by the script…
Display Date Created in finder view on Mac OS
The Finder view on Mac OS by default does not display the Date Created field for the documents, folders and other items. And if you want to know the date created for these items then you can enable this using Finder View options. In the Finder View Options window, tick the check box with label…
Turn off auto detect links in Google Docs
Google Docs has a feature that can automatically detect any links and apply the style accordingly. For example if you have type a text as http://digianswers.com in a Google Docs document then it would consider this as a hyperlink But if you do not want the hyperlink then highlight the link and click on the…
How to find word count in Google Docs Document
Word count in a Google Docs document can be found using the menu option available as part of Tools menu. The Word Count window provides count of pages, Words, Characters (no spaces), Characters (with spaces). If you want find the Word Count in document, click on the Tools menu and then select Word count from…