Less F9 In The Excel Formula Bar And Two Other New Features

Three new features coming to Excel

1. Value Preview will evaluate part of your formula when you select it in the

Excel formula bar. You don't have to press F9 and Esc anymore.

2. AutoSave moves from an icon to Words in the Excel Title Bar
3. Small preview of Personalized Toolbar in Excel

Table of Contents

• (0:00) Three new Excel Features
• (0:30) F9 replaced with Value Preview
• (3:57) AutoSave icon moves to Title Bar words
• (5:07) Personalized Toolbar in Preview
• (10:38) Wrap-up

More links on about

• How to edit, evaluate and debug formulas in Excel - Ablebits

Nov 9, 2022 — In this tutorial, you will learn a few quick and efficient ways to check and debug formulas in Excel. See how to use the F9 key to evaluate ...

• Evaluating an Excel Formula with "Edit" Mode and the F9 Key

Almost everybody knows that pressing the F9 key in Excel recalculates all of the worksheets within all of the workbooks that a user has open. What many people ...

• How to avoid broken formulas - Microsoft Support

Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.