Formula obscuring cell

R

Ron Rosenfeld

I know this has been discussed before, but I can't seem to find it with Google.

Situation: A long, multiline formula in one of the top rows of the worksheet.
When I select that cell, the formula (from the formula bar) obscures the cell
and makes dragging the cell impossible.

I have found some ways to work around this. If I want to copy from B1:I1, I
can select B1:I1 starting at I1 (rather than B1), and then use the <ctrl><R>.
But I'm wondering if there is some other way so that long formulas won't
interfere with the adjacent cell.


--ron
 
A

Andy Brown

Hi Ron.

I don't understand
interfere with the adjacent cell.
Click to expand...

? ; notwithstanding, maybe you could (CTRL+) drag the Formula Bar (View
menu) command to your menu bar. And edit the name to &Bar. Then you could
just toggle the bar on & off with ALT+B (probably).

HTH,
Andy
 
B

Bob Umlas

You CAN un-maximize the worksheet (the middle button of the 3 on the top
right), and then you can drag the sheet away from the formula bar.

Bob Umlas
Excel MVP
 
D

Dave Peterson

I usually use Bob Umlas's suggestion--so I can still edit the formula (I edit in
the formula bar), but sometimes....

View|formula bar (uncheck it), then do your stuff and then turn it back on.

or shortcut keys: alt-vf

And you can use the shortcut keys faster than you can swear at xl!
 
R

Ron Rosenfeld

You CAN un-maximize the worksheet (the middle button of the 3 on the top
right), and then you can drag the sheet away from the formula bar.
Click to expand...

THANK you for that information. That would be most useful. Hopefully I will
remember it when I need to :))
--ron
 
R

Ron Rosenfeld

View|formula bar (uncheck it), then do your stuff and then turn it back on.
Click to expand...

Hmmm. I was looking for something like that but missed it the last time I
needed it. I do see it know.

Thanks.


--ron
 
R

Ron Rosenfeld

Hi Ron.

I don't understand


? ; notwithstanding, maybe you could (CTRL+) drag the Formula Bar (View
menu) command to your menu bar. And edit the name to &Bar. Then you could
just toggle the bar on & off with ALT+B (probably).

HTH,
Andy
Click to expand...

Thanks for that thought. But Bob and Dave gave me some other suggestions which
seem simpler.

Best,

--ron
 
Top