ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Validation source field size and function. (https://www.excelbanter.com/excel-worksheet-functions/147260-validation-source-field-size-function.html)

Dudedad

Validation source field size and function.
 
This seem crazy but the size of the validation source field seems very small
and moving around in the formula without it changing seems impossible.
Normally you can just use the arrow keys but this of course adds or changes
cells.
I've got a feeling I'm missing something.

T. Valko

Validation source field size and function.
 
Try pressing function key F2 *before* you try to move around using the arrow
keys. And yes, source field *IS* very small. Argh!

Biff

"Dudedad" wrote in message
...
This seem crazy but the size of the validation source field seems very
small
and moving around in the formula without it changing seems impossible.
Normally you can just use the arrow keys but this of course adds or
changes
cells.
I've got a feeling I'm missing something.





All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com