Category: Technical
-
How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
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 verification 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…
-
How to password protect workbook in Excel Mac 2011
Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list. This would display the following File Passwords window with different password option. You can set a password for opening the excel workbook using…
-
How to limit results returned by Query function in Google Spreadsheet
We had already seen brief introduction about using Query function in Google Spreadsheet. Let us see how to limit the number of rows returned using Query Function with the following sample data of batsman with maximum runs in test cricket. Now if you want to get the top 3 batsman with maximum number of runs…
-
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…