Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

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

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: F9 function key

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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default F9 function key

"Epinn" wrote:
.. is a shortcut key to reverse F9+enter.

How about CTRL+Z ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default F9 function key

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



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

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



  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default F9 function key

"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
---
  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

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


  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default F9 function key

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



  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default F9 function key

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


  #10   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default F9 function key

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


  #11   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

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



  #12   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default F9 function key

Okay Bob,..

That's Roger, I believe <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #13   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

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

"Max" wrote in message ...
Okay Bob,..


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

  #14   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default F9 function key

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





  #15   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default F9 function key

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






  #16   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 605
Default F9 function key

Bob,

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

Epinn

"Bob Phillips" wrote in message ...
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
---





  #17   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default F9 function key

Hi Epinn

Mark a range of cells
FormatCellsAlignmentCentre across Selection

--
Regards

Roger Govier


"Epinn" wrote in message
...
Bob,

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

Epinn

"Bob Phillips" wrote in message
...
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
---






  #18   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default F9 function key

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
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
---






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Creating a Custom Excel Function to Calculate Gini Coefficients [email protected] Excel Worksheet Functions 3 February 21st 06 10:15 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"