Hi,

Today I am learning F9. From Help:-

"F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected portion of a formula and replaces the selected portion with the calculated value."

This is great. If formula auditing fails me, I can use F9. I find that if I highlight part of a formula and press F9 **without** pressing enter, it still works. My question is this:-

After the partial formula has been replaced by a value, how do I reverse back to the original formula with arguments? What shortcut key do I use? Do I have to copy the formula first and then do F9 plus enter?

While doing research on F9, I learned the basic rule for compiling *complex* worksheets.

"......reorganize your worksheets so that the primary calculations are placed near the top of the worksheet and as far left as possible, and the calculations that are based on those primary calculations are placed later in the worksheet."

For more details, see this link:- http://exceltips.vitalnews.com/Pages...culation..html

Please feel free to comment and I really like to know if there is a shortcut key to reverse F9+enter.

Thanks.

Epinn

"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi

Also, pressing ESC.

--
Regards

Roger Govier


"Max" wrote in message
...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"Roger Govier" wrote:
Also, pressing ESC
Perhaps that's if we don't hit the enter, just the F9 <g
But to reverse F9+enter, pressing ESC may not suffice ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Max

You are quite right, of course!
As I never do hit Enter after pressing F9, I hadn't really considered
this.


--
Regards

Roger Govier


"Max" wrote in message
...
"Roger Govier" wrote:
Also, pressing ESC
Perhaps that's if we don't hit the enter, just the F9 <g
But to reverse F9+enter, pressing ESC may not suffice ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Good point Max.

I wish I had made that point at the conference Roger <g.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roger Govier" wrote in message
...
Hi Max

You are quite right, of course!
As I never do hit Enter after pressing F9, I hadn't really considered
this.


--
Regards

Roger Govier


"Max" wrote in message
...
"Roger Govier" wrote:
Also, pressing ESC
Perhaps that's if we don't hit the enter, just the F9 <g
But to reverse F9+enter, pressing ESC may not suffice ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

I am not talking about reversing right after. I am thinking of entering a bunch of formulas somewhere else and then coming back to this cell manipulated with F9, then reverse it. Also, after I press F9+enter, then save the worksheet, close it, reopen it and click on the formula (with value created by F9), how do I reverse it?

Epinn

"Max" wrote in message ...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

I don't think Excel can remember it. I assume once F9 is pressed, it treats it as if I actually key in the value.

Never mind. I am a big dreamer. May be it'll happen in 20_ _?

Epinn

"Epinn" wrote in message ...
I am not talking about reversing right after. I am thinking of entering a bunch of formulas somewhere else and then coming back to this cell manipulated with F9, then reverse it. Also, after I press F9+enter, then save the worksheet, close it, reopen it and click on the formula (with value created by F9), how do I reverse it?

Epinn

"Max" wrote in message ...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Epinn

I'm afraid that once you have saved the file, then you can't "Undo" the
operation, either with Control + Z or with the Undo key on the Toolbar.

--
Regards

Roger Govier


"Epinn" wrote in message
...
I am not talking about reversing right after. I am thinking of entering
a bunch of formulas somewhere else and then coming back to this cell
manipulated with F9, then reverse it. Also, after I press F9+enter,
then save the worksheet, close it, reopen it and click on the formula
(with value created by F9), how do I reverse it?

Epinn

"Max" wrote in message
...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

I basically understand the idea of "undo." But when I play with F9, my frame of reference is similar to merging two cells one day and then splitting them the next.

Okay Bob, another sign of "information overload" and I shall stay away from Excel for a few days.

Can I really?

Epinn

"Roger Govier" wrote in message ...
Hi Epinn

I'm afraid that once you have saved the file, then you can't "Undo" the
operation, either with Control + Z or with the Undo key on the Toolbar.

--
Regards

Roger Govier


"Epinn" wrote in message
...
I am not talking about reversing right after. I am thinking of entering
a bunch of formulas somewhere else and then coming back to this cell
manipulated with F9, then reverse it. Also, after I press F9+enter,
then save the worksheet, close it, reopen it and click on the formula
(with value created by F9), how do I reverse it?

Epinn

"Max" wrote in message
...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Okay Bob,..

That's Roger, I believe <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Epinn,

Don't merge cells, it is more trouble than it is worth.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Epinn" wrote in message
...
I basically understand the idea of "undo." But when I play with F9, my
frame of reference is similar to merging two cells one day and then
splitting them the next.

Okay Bob, another sign of "information overload" and I shall stay away from
Excel for a few days.

Can I really?

Epinn

"Roger Govier" wrote in message
...
Hi Epinn

I'm afraid that once you have saved the file, then you can't "Undo" the
operation, either with Control + Z or with the Undo key on the Toolbar.

--
Regards

Roger Govier


"Epinn" wrote in message
...
I am not talking about reversing right after. I am thinking of entering
a bunch of formulas somewhere else and then coming back to this cell
manipulated with F9, then reverse it. Also, after I press F9+enter,
then save the worksheet, close it, reopen it and click on the formula
(with value created by F9), how do I reverse it?

Epinn

"Max" wrote in message
...
"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"Epinn" wrote:
I am not talking about reversing right after. I am thinking of
entering a bunch of formulas somewhere else
and then coming back to this cell manipulated with F9, then reverse it.

CTRL+Z = Undo. At the cost of undo-ing several actions (several CTRL+Zs),
you might be able to get back to the particular F9+enter.

Also, after I press F9+enter, then save the worksheet, close it, reopen it and click on the formula (with value created by F9), how do I reverse it?

Once you click save, it's not possible to undo.

Do hang around for other possible insights
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Epinn,

Great to hear that you are learning about the F9 function key in Excel. It can definitely come in handy when troubleshooting formulas.

To answer your question, unfortunately, there is no shortcut key to reverse the F9 calculation. Once you press F9 and replace a portion of the formula with a calculated value, it is replaced permanently. However, you can undo the calculation by pressing Ctrl+Z immediately after pressing F9. This will undo the calculation and revert the formula back to its original state.

If you have already pressed Enter after pressing F9, then the only way to get back to the original formula is to either manually retype it or copy and paste it from a backup copy of the worksheet.

Regarding your research on compiling complex worksheets, the rule you mentioned is a good one to follow. By placing primary calculations at the top and left of the worksheet, you can ensure that they are calculated first and that any subsequent calculations are based on accurate values. This can help prevent errors and improve the overall performance of your worksheet.

1. Press F9 to replace a portion of the formula with a calculated value.
2. Press Ctrl+Z immediately after pressing F9 to undo the calculation and revert the formula back to its original state.
3. Manually retype the formula or copy and paste it from a backup copy of the worksheet if you have already pressed Enter after pressing F9.
4. Place primary calculations at the top and left of the worksheet to ensure accurate values and improve performance.