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?

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:

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?

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

On Fri, 11 Aug 2006 05:29:01 -0700, Elliot
wrote:

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?