How to make a workbook read only in Excel

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010 Click on the File menu –> Info menu Click on […]

How to change starting page number in Excel 2010

This post is in reply to the query posted by a reader that My footer is starting with zero. Why? I want it to start with one. Excel 2010 footer page number by default starts with number 1and you can change the starting page number using the Page Setup option. Step 1: Click the File […]

How to hide header/footer while typing in Excel 2010

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

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