ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In cell editing (https://www.excelbanter.com/excel-discussion-misc-queries/218583-cell-editing.html)

Dewayne

In cell editing
 
With in cell edting turned on and while in edit mode, many times the formula
covers the adjacent cell(s) so that adjacent cell(s) cannot be accessed to
include it in the formula by clicking on it. Is there a way to move or
position the expanded cell formula box while editing to get it out of the way
so that I can point to an adjacent cell while in edit mode?
I realize I could turn off edit in cell but prefer to keep it enabled.
Thanks for any suggestions.
--
Dewayne

JE McGimpsey

In cell editing
 
Not that I know of, but you can use the arrow keys instead.

In article ,
Dewayne wrote:

With in cell edting turned on and while in edit mode, many times the formula
covers the adjacent cell(s) so that adjacent cell(s) cannot be accessed to
include it in the formula by clicking on it. Is there a way to move or
position the expanded cell formula box while editing to get it out of the way
so that I can point to an adjacent cell while in edit mode?
I realize I could turn off edit in cell but prefer to keep it enabled.


Dewayne

In cell editing
 
Thanks for the suggestion.
--
Dewayne


"JE McGimpsey" wrote:

Not that I know of, but you can use the arrow keys instead.

In article ,
Dewayne wrote:

With in cell edting turned on and while in edit mode, many times the formula
covers the adjacent cell(s) so that adjacent cell(s) cannot be accessed to
include it in the formula by clicking on it. Is there a way to move or
position the expanded cell formula box while editing to get it out of the way
so that I can point to an adjacent cell while in edit mode?
I realize I could turn off edit in cell but prefer to keep it enabled.




All times are GMT +1. The time now is 11:31 PM.

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