Ask Your Question
0

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
0

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

Opaque gravatar image

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

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 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

Comments

1

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.

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

Stats

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

Seen: 20 times

Last updated: Jul 30