Excel’s New Focus Cell Feature Makes It Easier to Read Data

Excel; Excel consulting

Microsoft is testing a new feature that highlights the active row and column when a cell is selected. This means it’s easier to follow across rows and down columns when reading your data.

If you have a large spreadsheet of data, it can be difficult to read across the rows or down the columns, and your eyes can sometimes inadvertently jump from one row or column to the other. Currently, you can counteract this issue by selecting the whole row or column, and pressing Enter or Shift+Enter to navigate between the selected cells.

An Excel spreadsheet containing data, with column F selected, and the Enter key being used to jump between the cells in this column.

Alternatively, you can freeze the first rows and columns via the View tab on the ribbon, so that when you scroll along or down, you don’t lose sight of their names.

An Excel spreadsheet containing data, with the Freeze Panes option highlighted.

However, Excel’s new Focus Cell feature means that when you select a cell, the whole row and column turn to a color of your choice. As a result, you can read right across a row or down a column, safely in the knowledge that you’re correctly maintaining your gaze on the correct data.

An Excel spreadsheet containing data, with the Focus Cell feature clearly highlighting that cell F4 is selected.

This feature can be turned on and off in the Show group of the View tab on the ribbon, where you can also click the Focus Cell drop-down to change the cell color.

Excel's Focus Cell tool, with the Focus Cell Color menu opened.
Microsoft

Handily, the Focus Cell feature automatically activates when you use Excel’s Find (Ctrl+F) and Replace (Ctrl+H) tools, making it easier to follow the active cell as you toggle through your search results.

Unfortunately, you cannot activate the Focus Cell feature in Excel if you have already used the Freeze Panes or Split Panes tools in your spreadsheet. Given the usefulness of freezing and splitting panes, we hope that Microsoft addresses this inconvenient shortcoming. Indeed, using Focus Cell and Freeze Panes simultaneously would make reading spreadsheet data even easier.

Focus Cell is currently only available to Microsoft Insiders using Version 2410 (Build 18118.20000) or later on the Beta channel. Once Microsoft is satisfied with the testing phase, the company will roll the feature out to Microsoft customers on Windows PCs and, eventually, those who access Excel on a Mac or the free online version.

Source: Microsoft

Partilhar:

Mais publicações

Excel Consulting Image Blog

What’s New in Excel (October 2024)

Welcome to the October 2024 update. This month, we’re excited that Clean Data with Copilot in Excel is now available in Excel for the web. Also, GROUPBY and PIVOTBY functions are now generally available in Excel for Windows, Mac and web. Furthermore, Focus Cell is now available to Insider users on Excel for Windows.

Excel; Excel consulting; Powerapss

Office 2024 for consumers available October 1 

Office 2024 comes in two editions. Office Home 2024 is $149.99 USD and includes Word, Excel, PowerPoint, and OneNote for one PC or Mac. Office Home & Business 2024 is $249.99 USD and comes with everything in Office Home 2024 plus Outlook and the rights to use the apps for commercial purposes. You can buy both editions from retailers worldwide and via Microsoft.com starting October 1, 2024.

How to Use the SWITCH Function in Excel

Excel’s SWITCH is a logical function that is primarily used for data manipulation. It evaluates an expression against a list of values, and returns a result corresponding to the first matching value.

Its popularity comes from its relative simplicity compared to other Excel functions that perform similar tasks, meaning it’s easier to read the formula and debug any issues.
In this guide, I’ll explain how to use the function with a real-world example, assess its benefits over other functions, and cover some of its limitations.

Increase ease of navigation with Focus Cell in Excel

Increase ease of navigation with Focus Cell in Excel 

Focus Cell applies vibrant highlights to the corresponding row and column of the active cell and increases the active cell’s border thickness. This makes the active cell more visible and facilitates easy identification of data across the same row and column.

© 2024 Created by wpexperts.pt