Hidden Data
 

When I look at a spreadsheet with or without a pivot table I want to
immediately know that data is hidden without having to count and see if all
the rows and columns are consecutive..is there anywhere in any type of
spreadsheet that you immediately know "hey this spreadsheet contains hidden
data". I know that sending it to an outside source is the reason the data is
hidden but
I am simply taking internal spreadsheets and am not sure how or why they
hide stuff.

Thank you.

Hi, HT;
Don't know about an alert, but you could select everything in the sheet, and
unhide it. Your keystrokes would be:
ctrl+a (to select all), alt-o-c-u (to unhide columns), and alt-o-r-u (to
unhide rows).
Best regards,
Ian.

"HT" wrote:

When I look at a spreadsheet with or without a pivot table I want to
immediately know that data is hidden without having to count and see if all
the rows and columns are consecutive..is there anywhere in any type of
spreadsheet that you immediately know "hey this spreadsheet contains hidden
data". I know that sending it to an outside source is the reason the data is
hidden but
I am simply taking internal spreadsheets and am not sure how or why they
hide stuff.

Thank you.

Or you could make a macro and insert it in a module. Here is the macro which
will unhide all hidden rows and columns:
Sub ShowAllHiddenRowsAndColumns()
Dim ColumnsHidden As Range, RowsHidden As Range
For Each ColumnsHidden In ActiveSheet.UsedRange.Columns
If ColumnsHidden.Hidden Then
ColumnsHidden.Hidden = False
End If
Next
For Each RowsHidden In ActiveSheet.UsedRange.Rows
If RowsHidden.Hidden Then
RowsHidden.Hidden = False
End If
Next
End Sub

Swisse

Sub ShowAllHiddenRowsAndColumns()
Columns.Hidden = False
Rows.Hidden = False
End Sub

would also work.

--
Regards,
Tom Ogilvy



"swisse" wrote in message
...
Or you could make a macro and insert it in a module. Here is the macro
which
will unhide all hidden rows and columns:
Sub ShowAllHiddenRowsAndColumns()
Dim ColumnsHidden As Range, RowsHidden As Range
For Each ColumnsHidden In ActiveSheet.UsedRange.Columns
If ColumnsHidden.Hidden Then
ColumnsHidden.Hidden = False
End If
Next
For Each RowsHidden In ActiveSheet.UsedRange.Rows
If RowsHidden.Hidden Then
RowsHidden.Hidden = False
End If
Next
End Sub

Swisse