• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to hide header/footer while typing in Excel 2010

February 7, 2012 by Admin 2 Comments

This is in response to question asked by a reader of this blog related with header and footer in Excel 2010.

how do I make the header / footer not visible on the page while typing?

When you click on the insert header and footer option in Excel 2010, excel would immediately change the view to Page Layout. Hence you would see the newly added header and footer in your worksheet.

image

After typing the required header and footer details and do not want to see header and footer while typing you excel sheet in the data section then you can change the view to Normal by selecting Normal under the Workbook Views section.

image

This would temporarily hide the inserted header and footer in the Worksheet and you can always get it back by changing the Workbook view to Page Layout.

del.icio.us Tags: Excel 2010,Header,Footer,Hide,Workbook,Worksheet,Views,Normal,Page Layout

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Excel 2010, Footer, Header, hide, Normal, Page Layout, Views, Workbook, Worksheet

How to password protect workbook in Excel Mac 2011

September 29, 2011 by Admin 1 Comment

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.

201109292051.jpg

This would display the following File Passwords window with different password option.

201109292054.jpg

You can set a password for opening the excel workbook using the Password to open field. Similarly to set a password for modifying the content in the excel workbook, you can use the Password to modify. If you want to make the workbook as readonly then mark the check box labelled as Read-only recommended.

Filed Under: Excel, Mac, Technical Tagged With: excel 2011, Mac, Password, Protect, Workbook

How to limit results returned by Query function in Google Spreadsheet

September 5, 2011 by Admin Leave a Comment

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 scored, then you can use

=QUERY(C3:G13,”select C,G limit 3″)

The limit keyword will reduce the number of results returned to 3.

But say if you want to get the list of top 3 batsman with maximum averages then need to use the Order by clause.

=QUERY(C3:G13,”select C,F order by F desc limit 3″)

The above query would first sort the list using Order by clause and then uses the limit keyword to get the Top results.

Filed Under: Excel, Technical Tagged With: Google Spreadsheet, Limit, Order by, Query, results

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.

Filed Under: Excel, Technical Tagged With: Freeze rows, Google Docs, Headings, Rows, spreadsheet, Visible

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.

Filed Under: Excel, Technical Tagged With: Autocomplete, Enable, Google, Google Docs, spreadsheet

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.

Filed Under: Excel, Technical Tagged With: Alternate rows, Google Apps Script, spreadsheet

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 8
  • Go to page 9
  • Go to page 10

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023