oaktrees

Senior Data Analyst

Thomas Zucker-Scharff

<div>
(For no credit) Rob is right but to you said &quot;AND a column to the left&quot;, so to be clear, the column(s) that you freeze to the left have to start at column 'A'.
</div>


(For no credit) Rob is right but to you said "AND a column to the left", so to be clear, the column(s) that you freeze to the left have to start at column 'A'.

<div>
Thanks to Rob &amp;&nbsp;Martin! :))))))))))))))))))))
</div>


Thanks to Rob & Martin! :))))))))))))))))))))

<div>
To confirm, everything to the left or above the cursor will be frozen.<br />
<br />
I never use split screen setting but often use Freeze Panes; I have actually written an article about Freeze Panes.<br />
<br />
<a href="https://www.experts-exchange.com/articles/29067/Freeze-Panes-feature.html" rel="ugc">https://www.experts-exchange.com/articles/29067/Freeze-Panes-feature.html</a>
</div>


To confirm, everything to the left or above the cursor will be frozen.

I never use split screen setting but often use Freeze Panes; I have actually written an article about Freeze Panes.

https://www.experts-exchange.com/articles/29067/Freeze-Panes-feature.html [https://www.experts-exchange.com/articles/29067/Freeze-Panes-feature.html]

<div>
<div class="content wysiwyg-content">
Using Excel, seems like there is a way to BOTH freeze the top row AND a column to the left using some combination of:<br />
<br />
Split<br />
<br />
&amp;<br />
<br />
Freeze<br />
<br />
Not VBA &nbsp;code, but using the main features of the program itself. &nbsp;However, can't figure it out. &nbsp;What am I missing?<br />
<br />
Thanks!<br />
<br />
OT
</div>
</div>


Using Excel, seems like there is a way to BOTH freeze the top row AND a column to the left using some combination of:

Split

&

Freeze

Not VBA  code, but using the main features of the program itself.  However, can't figure it out.  What am I missing?

Thanks!

OT

Excel - Freezing Top Row and a Column

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.