Ask Your Question

Can I edit the value of a cell from formula bar if cell is not activated?

asked 2020-07-30 22:52:53 +0200

LearningLibre gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-30 23:13:46 +0200

Opaque gravatar image

updated 2020-07-30 23:14:13 +0200


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


  • Enter A128 into the Name Box
  • Press ENTER key (cell A128 gets selected)
  • Type 5 into the formula bar

image description

Hope that answers your question.

edit flag offensive delete link more



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.

Lupp gravatar imageLupp ( 2020-07-30 23:33:48 +0200 )edit

To access the Name Box, also can press Ctrl+Shift+T.

LeroyG gravatar imageLeroyG ( 2020-07-31 01:30:45 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-30 22:52:53 +0200

Seen: 20 times

Last updated: Jul 30