Is there a way to edit cell value without activating it first? I would like to set the cell E3 to value 6 and I tried to put the code E3=6 to the formula bar while the cell A1 was activated but it didn’t work.
Hello,
No - you can’t put a value into a cell without selecting the respective cell. But you can select a cell (or a whole range) without scrolling by entering the reference into the Name Box leftmost in the formula bar and ENTER
Example:
- Enter
A128into the Name Box - Press
ENTERkey (cellA128gets selected) - Type
5into the formula bar
Hope that answers your question.
BTW:
If you move the view using the scroll bars subsequently to having put the focus on the cell, the focus doesn’t change. This way you can edit the content of a cell using the formula bar while the cell itself is outside the view - and probably something else you want to see during editing is inside.
To access the Name Box, also can press Ctrl+Shift+T.