Excel Highlight Active Cell Row and Column Automatically

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select View > Focus Cell to highlight the row and column that cross at the active cell. Focus Cell is the simplest built-in way to follow your position in a large worksheet; it changes the on-screen view, not the cell values or their formatting.

What Focus Cell does

Excel worksheets can extend far beyond the portion visible on screen, so it is easy to lose track of which row or column belongs to the selected cell. Focus Cell adds a colored crosshair: a highlight across the active cell’s row and down its column. The selected cell remains identifiable where the two bands meet.

The highlight follows the active cell as you move around the sheet. For example, if the active cell is G42, the crosshair marks row 42 and column G. Select C8 and it moves to row 8 and column C. This makes it easier to read across wide tables or trace a value back to its labels without changing the worksheet’s data.

Focus Cell is a viewing aid, not a command that fills cells with color. It does not replace existing cell formatting, change formulas, or create a permanent row-and-column highlight in the data. That distinction matters if you want the effect to appear in a printed worksheet or in a copy opened by someone without the feature.

Turn on the active row and column highlight

In Excel for Microsoft 365 on Windows, use the View tab on the ribbon:

  1. Open the worksheet where you want the crosshair.
  2. Select View > Focus Cell.
  3. Move to another cell and confirm that the highlighted row and column follow your selection.

Select View > Focus Cell again to turn the feature off. Depending on the ribbon layout and the version available to your account, Focus Cell may appear as a button with a dropdown. The dropdown can offer color choices; choose a shade with enough contrast to see against your worksheet while keeping the cell contents readable.

There is no need to select an entire row or column first. Focus Cell uses the active cell—the current selection shown by Excel’s cell border—as its reference. If you select a range, the active cell is the cell within that selection from which the selection began, and the crosshair follows that active cell.

Choose a useful highlight color

A good color is noticeable without overpowering the grid or the worksheet’s own formatting. A pale tint is often easier to read over tables with colored headers, while a stronger tint may be more visible on a mostly white sheet. If the Focus Cell dropdown in your Excel build offers colors, try one with clear contrast and check that it does not make text difficult to read.

Color preference depends on what is already on the sheet. A yellow crosshair may blend into yellow input cells; a blue one may be hard to distinguish from a blue table style. If a color makes the worksheet harder to scan, pick another option or switch Focus Cell off. The highlight is intended to guide your eye, not to communicate the meaning of the underlying data.

What the highlight changes—and what it does not

Focus Cell is a screen-level visual aid. It does not add fill color to every cell in the active row and column, so you will not see those cells acquire new formatting in the Home tab’s Fill Color controls. It also does not change formulas, values, sorting, filtering, or the workbook’s calculations.

Because the crosshair is not cell formatting, it is not a reliable way to mark a row for printing or to show a permanent highlight to another person. If you need a visible result in a printed report, apply ordinary formatting to the relevant cells or use a table style, conditional formatting, or a deliberate selection and fill. Those methods affect the worksheet itself and should be chosen carefully so they do not obscure existing formats.

The crosshair is also different from the active-cell border, which identifies the selected cell itself, and from Freeze Panes, which keeps chosen rows or columns visible while you scroll. These features solve separate problems and can be useful together.

Availability on Windows, Mac, and the web

The steps above are for Excel for Microsoft 365 on Windows. Microsoft rolls out some Microsoft 365 features over time, so the exact button, dropdown, and availability can depend on your update channel, build, and account. If Focus Cell is missing, first check that Excel is up to date and look on the View tab. A missing command does not mean the workbook is damaged.

Excel for Mac and Excel for the web can have different feature availability and ribbon layouts from the Windows desktop app. If your Mac or browser version includes Focus Cell, look on the View tab for that command; do not assume that the Windows menu layout or all color options will be identical. If it is not present in your version, use one of the alternatives below or open the workbook in an up-to-date Microsoft 365 desktop version that provides the feature.

Keyboard shortcuts are not required to use Focus Cell: the ribbon command is the dependable route. Excel has many shortcuts for selecting cells and navigating a worksheet, but that does not make them shortcuts for turning this particular display feature on or off.

Alternatives when Focus Cell is unavailable

If you only need help navigating, use the Name Box to go directly to a cell, or use the row and column headings to orient yourself. Freeze Panes can keep header rows or identifying columns visible as you scroll; on Windows, the command is View > Freeze Panes. It does not dynamically shade the active cell’s row and column, but it often solves the related problem of losing table labels while moving through a large dataset.

Conditional formatting can highlight cells based on a rule, such as a status, a date, or a value. It is useful for persistent, data-driven emphasis, but it does not automatically follow the currently selected cell just because the selection changes. A rule intended to represent the active selection needs additional design, and a simple conditional-formatting rule based on cell contents is not equivalent to Focus Cell.

For a permanent highlight, select the relevant row or column and use the Fill Color control on the Home tab, or create a conditional-formatting rule for a meaningful condition. For a temporary visual guide while browsing, use Focus Cell where available. For an output that must print consistently, use actual formatting and check Print Preview before distributing it.

Common problems and quick checks

  • The highlight is not visible: Select a cell on the worksheet, confirm Focus Cell is switched on, and try another available color. A color can be difficult to see over existing fills.
  • The highlight stays in the old place: Click a different cell rather than only scrolling. The crosshair follows the active selection, not the portion of the sheet currently shown on screen.
  • The command is missing: Check the View tab and update Microsoft 365. Feature rollouts and platform differences can affect availability.
  • The effect does not appear in a printout: Focus Cell is a viewing aid, not cell fill formatting. Apply worksheet formatting if the emphasis needs to print.
  • The feature seems to change a cell’s color: Check the cell’s normal fill and conditional-formatting rules separately. Focus Cell’s crosshair is not the same as either one.

When diagnosing a busy worksheet, test the feature in an empty area or a simple sheet. That helps distinguish a low-contrast highlight from a problem with the selected cell, existing formatting, or a version that does not yet include the command.

Frequently Asked Questions

Can Excel automatically highlight the active cell’s row and column?
Yes. In Excel for Microsoft 365 on Windows, select View > Focus Cell. The crosshair follows the active cell as you move through the worksheet.

How do I turn off the row and column highlight?
Select View > Focus Cell again. If the command has a dropdown, use the main Focus Cell control to toggle the feature rather than choosing a different color.

Can I change the color of the active-cell highlight?
Some versions show color options in the dropdown beside Focus Cell. Availability and layout can differ by Excel build and platform. If the options appear, choose a color that stays clear against your worksheet’s existing formatting.

Does Focus Cell print or change the workbook’s cell fills?
No. It is a visual aid for working on screen, not permanent cell formatting. Use regular fill formatting or conditional formatting if the emphasis must appear in a printed worksheet.

Why can’t I find Focus Cell in Excel?
It may not be available in your particular build, update channel, or platform yet. Check the View tab and update Microsoft 365; if the command remains absent, use navigation or formatting alternatives, or try a version that includes the feature.

Is Focus Cell the same as Freeze Panes?
No. Focus Cell highlights the active cell’s row and column. Freeze Panes keeps selected rows or columns visible during scrolling. Use Focus Cell to track your position and Freeze Panes to retain headers or labels.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.