F9 function key

[Epinn]

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/T0155_Forcing_Stubborn_Recalculation..html

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

Thanks.

Epinn

 

[Guest]

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?

---

 

[Roger Govier]

Hi

Also, pressing ESC.

 

[Epinn]

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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 

[Guest]

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

---

 

[Epinn]

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

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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 

[Roger Govier]

Hi Max

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

 

[Roger Govier]

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?

---

 

[Guest]

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

---

 

[Epinn]

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

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 

[Guest]

Okay Bob,..

That's Roger, I believe <g>

---

 

[Epinn]

I did mean Bob. Bob and I had a conversation going on under a different thread ..... He'll know what I mean when he reads this.

Max, I see that you are in Singapore. Do you know Shawn Toh, MVP? Just curious.

Epinn

Okay Bob,..

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

 

[Bob Phillips]

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)

 

[Bob Phillips]

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)

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

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?

---

 

[Epinn]

Bob,

Then, how do I spread a column heading across a few columns? Just don't make it one big cell?

Epinn

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)

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

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 

[Roger Govier]

Hi Epinn

Mark a range of cells
Format>Cells>Alignment>Centre across Selection

--
Regards

Roger Govier


Bob,

Then, how do I spread a column heading across a few columns? Just don't
make it one big cell?

Epinn

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)

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

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?

---

 

[Epinn]

Thanks Roger. I am having trouble using format etc. and I have started a new thread.

Epinn

Hi Epinn

Mark a range of cells
Format>Cells>Alignment>Centre across Selection

--
Regards

Roger Govier


Bob,

Then, how do I spread a column heading across a few columns? Just don't
make it one big cell?

Epinn

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)

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

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


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

.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

 

[Guest]

Ahh, I see .. a cross country thread <g>
(missed the subtle intent in your response, thought it was addressed to
Roger)

.. Do you know Shawn Toh, MVP? Just curious.

No, I'm afraid not. Shawn's a Powerpoint MVP (just checked)

---

 

[Ragdyer]

Harlan taught me that years ago in one of his disparaging posts about my
ability (inability) to understand a formula of his.<bg>