How To Display The Active Cell In Top Left In Excel Screen?

The cell that is now chosen or highlighted is referred to as the active cell in Excel. In the Name Box, which is situated next to the formula bar, Excel by default shows the current cell. However, you could find it more practical to have the current cell shown conspicuously in the Excel window's upper left corner.

In this article, we'll look at a quick way to implement this customisation. You may set up Excel to display the active cell in the upper left corner of the screen in the manner shown above, giving you constant sight of and quick access to the cell you are now working on. This lesson will walk you through the process with simple instructions and useful visuals, whether you are an experienced Excel user trying to increase your productivity or a newbie learning the ropes. Let's get started and discover how to make the top−left corner of the Excel screen show the active cell!

Display The Active Cell In Top Left

Here we will create a VBA module and then run it to complete the task. So let us see a simple process to know how you can display the active cell in the top left corner of the Excel screen.

Step 1

Consider an Excel sheet.

First, right−click on the sheet name and select View Code to open the VBA application, then click on Insert and select Module.

Right click > View code > Insert > Module.

Step 2

Then copy the below code into the text box.

Code

Sub TopLeft()
Application.Goto ActiveCell, Scroll:=True
End Sub

Step 3

Then save the sheet as a macro−enabled template and click F5 to complete the task. You can see that the active cell will always be displayed at the top left.

Save > F5.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can display the active cell in the top left corner of the Excel screen to highlight a particular set of data.

Pradeep Kumar

e

Updated on: 12-Jul-2023

325 Views

Kickstart Your Career

Get certified by completing the course

Get Started