Custom Spreadsheet Solutions
Productivity – powered by Excel

You can now turn on Focus Cell in Excel. This highlights the row and column of the cell you have activated. Handy if you want to be able to see easily all the data in the row or column that you have selected.

Focus cell in action

To turn on Focus cell, use the button on the View menu. Shortcut keys Alt, W E, F.

You can change the colour of the highlighting on the same button.

Focus cell on off button on the view menu.

Click the button again, or same shortcut keys to turn it off.