spreadsheet

How to Insert Pictures in Excel

February 11, 2023 by Admin Leave a Comment

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 how to insert pictures in Excel and provide tips for formatting and positioning them.

Step 1: Select the Cell The first step in inserting a picture in Excel is to select the cell where you want the picture to appear. This will ensure that the picture stays in place and doesn’t move as you make changes to the spreadsheet.

Step 2: Insert Picture Once you’ve selected the cell, go to the “Insert” tab and click “Picture.” You can then select the picture you want to insert from your computer or from a file on your network.

Step 3: Resize and Format Once you’ve inserted the picture, you can resize it to fit the cell or the entire spreadsheet. To do this, click and drag the edges of the picture until it’s the size you want. You can also use the “Format Picture” option to adjust the picture’s brightness, contrast, and other attributes like Fill & Line, Effects, Size and Properties

By following these steps, you’ll be able to easily insert pictures into your Excel spreadsheets and add a visual touch to your data. Whether you’re creating a presentation, a report, or simply organising your data, adding pictures in Excel is a useful skill to have.

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

February 4, 2023 by Admin Leave a Comment

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:

Select the rows or columns you want to hide. To select multiple rows or columns, hold down the “Ctrl” key (Windows) or “Cmd” key (Mac) while clicking on each row or column.
Right-click on the selected rows or columns and select “Hide”.

To unhide the rows or columns, select the rows or columns immediately above or to the left of the hidden ones.
Right-click and select “Unhide”.

Another way to hide rows and columns is to use the “Format” dropdown menu on the Home tab. Simply select the rows or columns you want to hide, then go to Home > Format > Hide & Unhide > Hide Rows or Hide Columns.

Format Menu - Hide or Unhide Rows and Columns in Excel

Benefits of hiding rows and columns:

Keeps your spreadsheet organised and easier to navigate
Helps to focus on relevant data and minimise clutter
Protects sensitive data by making it invisible
Doesn’t delete the data, only makes it invisible, so it can still be used in formulas and calculations

You can also check out the steps for hiding rows and column headers in excel and Search, hide, print comments in Excel

Always Keep headings visible in Google Spreadsheet

August 24, 2011 by Admin 1 Comment

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 of the View menu. To explain, let us take the take following sample data

Now when the users scroll down below Row no 26, the heading rows would disappear as shown below.

And it will be difficult for the users to find out the column under which the values fall. This problem can be addressed using the Freeze rows feature. Navigate to View menu then Freeze rows and select Freeze 1 row menu option.

This would always Keep the heading rows always visible in a Google Docs Spreadsheet.

How to enable autocomplete in Google Docs Spreadsheet

August 24, 2011 by Admin 5 Comments

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
California
Florida
Indiana

Now when you start typing Ar in the cell below Indiana, Spreadsheet will automatically display Arizona based on the entries done earlier for that column. And when you press enter this value will be automatically filled for that cell.

You can enable Autocomplete feature in Google Spreadsheet by clicking the Tools menu and selecting Enable AutoComplete from list of available menus.

Remember that if there is a empty cell before the active cell then Autocomplete feature will try to pick from the below column values.

Change alternate row background colors in Spreadsheet using Google Apps Script

August 22, 2011 by Admin 8 Comments

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 for setting the background color.

Install the below script and select the data by excluding the Header columns and execute the script.

function alternateColor() {
var totalRows = SpreadsheetApp.getActiveRange().getNumRows();
var totalColumns = SpreadsheetApp.getActiveRange().getNumColumns();
var startRow = SpreadsheetApp.getActiveRange().getRow();
var startColumn = SpreadsheetApp.getActiveRange().getColumn();
var sheet = SpreadsheetApp.getActiveSheet();
var row = startRow;
while (row < totalRows+startRow)
{
    var column = startColumn
    while (column < totalColumns+startColumn){
      if(row%2 == 0){
           sheet.getRange(row, column).setBackgroundColor(“lightgrey”);
      }
      column++;
}
    row++;
}
}

After executing the script, the sample data would look as shown below.

If you want to change the white color then you can add an else statement to set the background color for odd row numbers as well.

if(row%2 == 0){
           sheet.getRange(row, column).setBackgroundColor(“lightgrey”);
      } else {
          sheet.getRange(row, column).setBackgroundColor(“lightblue”);
}

Let me know if any one have a better suggestionn.