Excel Green Highlight Row and Column: How to Turn It On

How-to basics · Updated November 19, 2026

To highlight the active row and column in green in Excel for Microsoft 365 on Windows, select View > Focus Cell, then open its color menu and choose green. This shows a crosshair around the selected cell; the ordinary green outline around one cell is just Excel’s active-cell indicator, not a row-and-column highlight.

What the green highlight means

Excel normally marks the current cell with a border, while its row number and column letter show which row and column contain that cell. That is useful for navigation, but it can be difficult to track across a wide worksheet or down a long list. A row-and-column highlight makes the selected cell’s position easier to follow without changing the worksheet’s data.

In current Microsoft 365 versions, Focus Cell is the built-in feature for this crosshair effect. It highlights the row and column associated with the active cell, and its color can be changed. The feature is a display aid: it does not write a fill color into every cell, alter formulas, or change what prints. Move the selection and the focus follows it.

It helps to distinguish three things that can look similar:

  • Active-cell border: Excel’s outline around the one selected cell. In the standard Windows theme it is green.
  • Selected row or column: Clicking a row number or column letter selects the whole row or column; Excel shows selection shading, but this is not a persistent crosshair.
  • Focus Cell: A visual row-and-column guide that follows the selected cell and can be given a green highlight color.

Turn on Focus Cell and choose green

In Excel for Microsoft 365 on Windows, click any cell, open the View tab, and select Focus Cell. The active row and column should now be highlighted. To change the color, open the arrow or menu associated with Focus Cell, choose Focus Cell Color, and select a green swatch. The exact appearance can vary with the selected color and Excel’s current interface theme.

  1. Open the workbook and select a cell in the area you are reading.
  2. Choose View > Focus Cell.
  3. If the highlight is not green, open the Focus Cell color menu and choose a green shade.
  4. Select another cell to confirm that the guide follows the active selection.

To turn the effect off, select View > Focus Cell again. The command acts as a toggle in versions that provide it. Focus Cell is part of Microsoft 365’s evolving feature set, so the command may be missing in an older or not-yet-updated installation. If it is absent, install available Office updates and check again; perpetual editions such as Excel 2019 may not include it. Excel for Mac and Excel for the web can have different feature availability and ribbon layouts, so do not assume that the Windows steps or the same color controls appear there.

Why the highlight may not appear

If the command seems to do nothing, first check that a single cell is selected rather than a chart, shape, or other object. Then confirm that Focus Cell is switched on and that the active cell lies within the visible worksheet area. If the button is not on the View tab, check the Excel version under File > Account and install updates if your organization permits them. Work or school administrators can manage update timing, which may delay access to newer features.

Also check whether the color is simply too pale against the sheet. Choose a stronger green shade if the color menu offers one, and consider the workbook’s existing cell fills. A visual highlight can be hard to distinguish over a dark or similarly colored cell background. Focus Cell is not the same as applying a green fill: if you need the color to remain attached to cells after closing the workbook or to appear on a printout, use cell formatting or conditional formatting instead.

Finally, make sure the worksheet is not confusing you with another selection effect. A green border around just one cell is normal. Selecting a row by clicking its number may shade the selected row, and selecting a column by its letter may shade that column. Those actions do not enable a moving row-and-column guide.

Use conditional formatting for a fixed crosshair

Conditional formatting is a useful alternative when you want a row and column highlighted according to numbers in helper cells, or when Focus Cell is unavailable. It does not automatically know which cell you have clicked. Instead, a formula can compare each cell with a row number and column number that you enter and update yourself.

For example, suppose the cells you want to format are A1:E100, and you put the target row number in F1 and the target column number in F2. Enter 4 in F1 and 3 in F2 to mark row 4 and column C. Select A1:E100, choose Home > Conditional Formatting > New Rule, then choose Use a formula to determine which cells to format. With those helper cells outside the formatted range, enter:

=OR(ROW()=$F$1,COLUMN()=$F$2)

Choose Format, set a green fill on the Fill tab, and confirm the rule. The result is the intersection of row 4 and column C, plus the rest of row 4 and column C within A1:E100. Changing F1 or F2 moves the crosshair. The formula is a rule for the selected range; it does not follow the active cell by itself. If you include the helper cells in the formatted range, the rule may also affect them, so keep them outside the target area or adjust the range deliberately.

When a permanent fill is better

Sometimes the goal is not to track your cursor but to mark a record, such as a customer row that needs review. In that case, apply a normal fill or use conditional formatting based on a status value. That marking remains associated with the relevant cells, unlike Focus Cell’s temporary guide.

For a one-time highlight, select the row or cells and use Home > Fill Color to choose green. For a rule-based highlight, use Home > Conditional Formatting and select a rule suited to the data, such as highlighting cells that contain a particular status. A permanent formatting rule is generally a better choice for shared workbooks, reports, and printouts because other people can see the mark without needing to turn on a personal viewing aid.

Be cautious about coloring an entire row manually in a data table. Sorting and filtering can change where a record appears, while the fill remains with the cells unless the range is moved as part of the sort. A conditional-formatting rule based on a status column is often more reliable when the color should represent the record’s meaning rather than your current place in the sheet.

Focus Cell compared with other options

Choose the method based on what you want the green to communicate. Focus Cell is the simplest option for following a selection while reading or editing. Conditional formatting is better for a repeatable rule or a fixed crosshair driven by helper values. A manual fill is appropriate for a deliberate, lasting annotation.

  • Need a guide that follows your clicks? Use Focus Cell if your Excel version includes it.
  • Need a row highlighted because a value meets a condition? Use conditional formatting tied to that value.
  • Need to mark a cell or row by hand? Use Fill Color, while remembering the fill is part of the workbook.
  • Need other users to see a cursor-following crosshair automatically? Focus Cell may be a personal interface feature and may not be enabled or available in their version. A shared, rule-based formatting method is more dependable.

There is no need to use a macro just to get a crosshair when Focus Cell is available. A custom macro can react to selection changes, but it adds maintenance and security considerations, and a macro that writes fills can overwrite existing formatting. For most users, the built-in feature or a carefully scoped conditional-formatting rule is safer and easier to manage.

Frequently Asked Questions

How do I highlight the active row and column in Excel?
In Microsoft 365 for Windows, select View > Focus Cell. Choose a green color from the Focus Cell color menu if you want green rather than the current highlight color.

Why is my Excel cell outlined in green?
The green outline normally marks the active cell, meaning the cell currently selected. It does not, by itself, indicate that the entire row and column are highlighted.

Can I make the row-and-column highlight stay green?
Focus Cell can use a chosen highlight color, but it is a viewing aid that follows the active cell. For a green mark that stays attached to cells or prints, apply a fill or create a conditional-formatting rule.

Does Focus Cell change my workbook or print the highlight?
It is intended as an on-screen focus aid, not a cell fill. It does not change values or formulas. Use normal formatting if you need a color to be part of the worksheet’s printed or shared presentation.

What if I cannot find Focus Cell?
Check that you are using an updated Microsoft 365 version and look on the View tab. Feature availability differs by Excel edition and platform; if the command is not available, use conditional formatting or a normal fill for the effect you need.

Which method should you choose?

For a green crosshair that follows the selected cell, start with View > Focus Cell and set its color to green. If you cannot access that feature, a conditional-formatting rule can highlight a row and column based on helper cells, although those values must be updated manually. Use ordinary fills or condition-based formatting when the color is meant to label worksheet data, remain visible to collaborators, or appear in a printed report.

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.