<div>
You can just click in A1 and that works - I just did it.
</div>


You can just click in A1 and that works - I just did it.

<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
In Excel, pressing the shortcut Ctrl+Home typically makes the A1 cell active. However, when a Row and/or Column freeze line is present, entering the same shortcut does not activate A1 but instead, activates the first cell after or outside of the frozen Rows/Columns.<br />
<br />
<b>Is there a shortcut for getting back to cell A1 even when freeze lines are present?</b><br />
<br />
By the way, in this particular scenario, each of the following is prohibited:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; • clicking the Name box, entering A1 &amp;&nbsp;pressing Enter<br />
&nbsp; &nbsp; &nbsp; &nbsp; • opening the GoTo box (Ctrl+g), entering A1 &amp;&nbsp;pressing Enter<br />
&nbsp; &nbsp; &nbsp; &nbsp; • any use of the Alt key<br />
<br />
Thanks
</div>
</div>


Hello,

In Excel, pressing the shortcut Ctrl+Home typically makes the A1 cell active. However, when a Row and/or Column freeze line is present, entering the same shortcut does not activate A1 but instead, activates the first cell after or outside of the frozen Rows/Columns.

Is there a shortcut for getting back to cell A1 even when freeze lines are present?

By the way, in this particular scenario, each of the following is prohibited:

        • clicking the Name box, entering A1 & pressing Enter
        • opening the GoTo box (Ctrl+g), entering A1 & pressing Enter
        • any use of the Alt key

Thanks

Excel shortcut to cell A1 when the freeze is on

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.