Is there a setting that opens a popup of the selected cell content for editing?

I frequently work with large worksheets where some cells contain a paragraph of text. I would like to be able to zoom out on the worksheet to the point where I can just barely read the text (so I know what cell I’m clicking in) and then when I click in a cell, have a popup content editor open. I know I can expand the formula bar to accomplish this, but that reduces the available space for the worksheet. Any ideas? I would think this would be an awesome feature if it doesn’t already exist.

Try to write a macro what will

  • display the cell string on a MessageBox.
  • put the cell content into an InputBox to edit it.

What happens if you press F2 while such a complete-book-cell is selected?
Do you know that you can select a cell by entering its address (name) into the ‘Name Box’?

Here is a tip for the macro solution:

Edit shrinked text.ods (12.6 KB)

When I hit F2 with the cell selected it makes the cell editable. This is similar to what I want, but I would like the size of the cell to expand so its easier to work with

Thanks for the macro Zizi64, I ended up attaching my laptop to dual monitors with the data sheet on one and the large worksheet on the other. This allows me to increase the size of the formula bar while zooming out on the worksheet cells to see the big picture.

That’s nice that you have all that equipment and opportunities.
If somebody comes here with a similar interest, but can’t apply a dual-monitor solution, see example:
optimalEditArea.ods (10.2 KB)
If the extra toolbar is too unwieldy due to your different porofile, you have to search for it specifically in the toolbar area, and then fetch it best with drag’n drop into the workspace.