ExcelBanter - Hidden rows/columns expand when referencing cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hidden rows/columns expand when referencing cells? (https://www.excelbanter.com/excel-worksheet-functions/205765-hidden-rows-columns-expand-when-referencing-cells.html)

tink

Hidden rows/columns expand when referencing cells?

When I use a formula referencing a cell in the same sheet or another sheet
all hidden rows and columns expand. How can I prevent this? This just
started yesterday.

Dave Peterson

Hidden rows/columns expand when referencing cells?

In xl2003 menus...

Try Tools|Options|Transition tab|Uncheck "Transition navigation keys"

tink wrote:

When I use a formula referencing a cell in the same sheet or another sheet
all hidden rows and columns expand. How can I prevent this? This just
started yesterday.

--

Dave Peterson

All times are GMT +1. The time now is 04:56 AM.