F9 function key

E

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
 
E

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

Max said:
.. is a shortcut key to reverse F9+enter.
Click to expand...
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
 
E

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

Max said:
.. is a shortcut key to reverse F9+enter.
Click to expand...
How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
 
R

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

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

Epinn said:
.. is a shortcut key to reverse F9+enter.
Click to expand...
How about CTRL+Z ?
 
M

Max

Epinn said:
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.
Click to expand...

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?
Click to expand...

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

Do hang around for other possible insights
 
E

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

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

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)
 
B

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

Epinn said:
.. is a shortcut key to reverse F9+enter.
Click to expand...
How about CTRL+Z ?
 
E

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

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

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

Epinn said:
.. is a shortcut key to reverse F9+enter.
Click to expand...
How about CTRL+Z ?
 
E

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

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

Max

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.
Click to expand...
No, I'm afraid not. Shawn's a Powerpoint MVP (just checked)
 
R

Ragdyer

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interchange line break and paragraph break shortcut keys 9
VBA Copy & Paste multiple ranges 2
Calculations may not occur in an Excel 1
F9 Calc refresh does not work... 3
MAC shortcut key 3
refresh pivot tables 5
Force Calculation 6
Excel 2007 SP1 - How to do F9 in VBA code? 3

Top