Something of Everything

Month: 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,…

  • 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…

  • 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…