excel unhides rows

[Elliot]

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?

[Marcelo]

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?

[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

On Fri, 11 Aug 2006 05:29:01 -0700, Elliot <[email protected]>
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?