Skip to main content

Evaluating the result of Particular formula With F9 Key

Evaluating the result of Particular formula With F9 Key

This is the best trick to know the result before publishing into cell.

Step 1: Select the section of the formula for which we want to know the result
Step 2: Press F9, now we can see the result
If we press the enter the result will be published into the cell.

Note : But we want to see the formula back to the cell, then how to go ahead?
Here is the answer –

Just press Ctrl + Z (Undo command), we were now back to formula mode.

Labels:

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more