Excel Add-in: explanation function IS_HIDDEN

Introduction

In Excel it is possible to hide certain rows or columns. There are two ways to hide rows or columns:

• Select one or more rows or columns (be sure you select the complete row/column). Right-click your mouse and choose ‘Hide’. The selected rows or columns are hidden.
• Use the ‘Advanced filter’ function in Excel.

In both cases the specified cells are recognized as being hidden. If the Exact function [IS_HIDDEN (cell)] points to a hidden cell, the value ‘TRUE’ appears. If this functions points to an unhidden cell, the value ‘FALSE’ appears.

You can use this function to check whether cells have been hidden or not and to display an alternative in case a cell has been hidden. You can do this by using the Excel function ‘IF’. This function does not connect to the Exact database.

Explanation of the fields

Company
The company is not of any importance, as this function does not connect to the Exact database. You can leave it ‘Default’.

Function
Select the function you want to use. To check whether cells have been hidden or not, choose ‘IS_HIDDEN”.

Cell
Select the cell for which you want to know whether it has been hidden or not. If you want to know if cell C2 has been hidden, select ‘=C2’. Do not forget the ‘=’-sign.

Example

1. IS_HIDDEN(C2)
   If cell C2 has been hidden, the value ‘TRUE’ will be displayed. If the cell has not been hidden, then the value ‘FALSE’ appears.
2. IF(IS_HIDDEN(A5);"yes";"no")
   If cell A5 has been hidden, the text ‘yes’ will be displayed. If that cell has not been hidden, the text ‘no’ appears.