Hidden Data

[HT]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Tom Ogilvy]

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

would also work.

 

[~D~]

I have a question about macros. I see you guys giving alot of code to record
a macro but don't understand where you would put that code.

 

[Dave Peterson]

David McRitchie has some notes for getting started with macros at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[~D~]

Great..thanks Ian, Swisse, Tom, Dave for the help..much appreciated.