Skip to main content


Showing posts from November, 2013

How to hide error values from a cell in MS Excel?

Let's say your spreadsheet formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error indicators in cells.
There are many reasons why formulas can return errors. For example, division by 0 is not allowed, and if you enter the formula =1/0, it returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. There are many ways to hide such values. Here are some methods to do the same.
Option 1:  Format text in cells that contain errors so that they don't show. Follow the seteps shown below. 1. Select the cells that contain the error value.
2. On the Format menu, click Conditional Formatting.
3. In the box on the left, click "Formula Is".
4. In the box on the right, type =ISERROR("reference"), where "reference" is a reference to the cell that contains the error value.
5. Click "Format", and th…

how to hide 0 values in a spreadsheet?

option 1: 
Perhaps the simplest way to hide all zero values in a sheet is to let the worksheet do it Just remember, this setting works at the sheet level. You must set it for each sheet in the workbook, as follows.

Click the File menu and then choose Options (under Help). In Excel 2007, click the Office button and then click Excel Options. In Excel 2003, choose Options from the Tools menu.Choose Advanced in the left pane. In Excel 2003, click the View tab.In the Display Options For This Worksheet section, uncheck the Show A Zero In Cells That Have Zero Value.Click OK.
option 2 :
The sheet setting will hide all zero values in the sheet. If you want to hide specific zero values, but not all, you can use a numeric format instead:

Select the cells that contain the zero values that you want to hide. Click the Home tab and click the Number group's dialog launcher (the small arrow in the bottom-right corner. In Excel 2003, choose Cells from the Format menu.Click the Number tab (if necessary…

How to add title on every page in MS excel?

Many a times we have lots of rows of data. When we want to print the same we need titles to be appeared on every page. There is an option for it in excel.
Follow the following procedure:
1. Just go to page layout.
2. Select the option called print title.
3. Select the area you want to see as title on every page.
4. See print preview. You can see the title appeared on every page.
Happy exceling.