How to Insert Pictures in Excel

Excel is a powerful tool for organising and analysing data, but sometimes you need to add a visual touch to your spreadsheets. Whether it’s for a presentation, a report, or simply to make your data easier to understand, inserting pictures in Excel is a useful skill to have. In this blog post, we’ll show you […]

Streamline your Excel spreadsheets with these easy steps to hide rows and columns

Excel spreadsheets can get cluttered and disorganised with too much data, making it difficult to find what you need. Hiding rows and columns in Excel can be a simple solution to keep your data organised and easily accessible. Steps to Hide Rows and Columns: Another way to hide rows and columns is to use the […]

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 […]