Something in my Excel settings has changed.
When I say have hidden cells in a workbook and I want to make a formula to reference to another cell all hidden cells appear.
How do I change it back?
Thanks in advance.
Something in my Excel settings has changed.
When I say have hidden cells in a workbook and I want to make a formula to reference to another cell all hidden cells appear.
How do I change it back?
Thanks in advance.
protecting the workbook might fix that
"ShaiGuy" wrote:
>
> Something in my Excel settings has changed.
>
> When I say have hidden cells in a workbook and I want to make a formula
> to reference to another cell all hidden cells appear.
>
> How do I change it back?
>
> Thanks in advance.
>
>
> --
> ShaiGuy
> ------------------------------------------------------------------------
> ShaiGuy's Profile: http://www.excelforum.com/member.php...o&userid=27228
> View this thread: http://www.excelforum.com/showthread...hreadid=467413
>
>
thanx however the issue is for every spreadsheet - it used to work fine
it's just like navigating through the spreadsheet... say i have hidden row B
when i do a cell reference =c1 it will unhide b1 automatically and inadvertantly select b1 and c1 which is very frustrating
Is it hidden because you Froze Pane/Split Table or hidden by right clicking
on the row and Hide?
"ShaiGuy" wrote:
>
> thanx however the issue is for every spreadsheet - it used to work fine
>
> it's just like navigating through the spreadsheet... say i have hidden
> row B
>
> when i do a cell reference =c1 it will unhide b1 automatically and
> inadvertantly select b1 and c1 which is very frustrating
>
>
> --
> ShaiGuy
> ------------------------------------------------------------------------
> ShaiGuy's Profile: http://www.excelforum.com/member.php...o&userid=27228
> View this thread: http://www.excelforum.com/showthread...hreadid=467413
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks