excel unhides rows

[Guest]

I have hidden rows in a spreadsheet.
When pressing = and clicking in another cell, it unhides these rows
automatically.
This is playing havoc with sum functions as it tries to highlight multiple
rows.
Any help?

 

[Guest]

Hi Elliot,

excel unhide the rows during the cell or formula editon, because, maybe, you
need to refer to a hide cell.

have notice that the row number or column leters appears in blue.

if you need to sum just the unhide cells in a range use

=sum(a2:a15;a32:a70)

hth
regards from Brazil
Marcelo



"Elliot" escreveu:

 

[Gord Dibben]

Elliot

Cannot replicate your problem.

How are the rows hidden? Manually or VBA or Filtered?

Maybe some event code?

Right-click on sheet tab and "View code".

Anything there?


Gord Dibben MS Excel MVP