How do i freeze the second row at the top in excel?

• 
• Forum
• Microsoft Office Application Help - Excel Help forum
• Excel General
• Freezing the SECOND Row

1. 04-08-2009, 06:12 AM #1

   

   Registered User

   

   ---

   Freezing the SECOND Row

   Hi,

   I was just wondering, I'm a fair way through my spreadsheet, and I made the second row the row with all the titles etc. My spreadsheet is to complicated to move up 1 row without breaking it all, and I feel that it would be far more easy to read if I had the title row (the second one) frozen... so I was wondering is it possible to do that?

   Thanks

   ---

2. 04-08-2009, 06:20 AM #2

   Re: Freezing the SECOND Row

   Put your cursor at row 3 and go to Window ></blockquote></div> </div> </div> <div class="after_content"> <blockquote class="signature restore"><div class="signaturecontainer" style="font-weight:normal">oldchippy<br> -------------<br> <img src="https://www.excelforum.com/images/smilies/smile.gif" border="0" alt="" title="Smilie" class="inlineimg"> <img src="https://www.excelforum.com/images/smilies/wink.gif" border="0" alt="" title="Wink" class="inlineimg"> <img src="https://www.excelforum.com/images/smilies/smile.gif" border="0" alt="" title="Smilie" class="inlineimg"><br> <br> <i>Blessed are those who can give without remembering and take without forgetting</i><br> <br> <font size="2"><font color="Red">If you are <b>happy with the help you have received</b>, please click the </font><font color="Blue"><b>&lt;--- STAR </b></font><font color="red">icon on the left - Thanks</font>.</font><br> <br> <font color="Red"><b>Click here </b></font>&gt;&gt;&gt; <a href="http://www.excelforum.com/showthread.php?t=620254" target="_blank">Top Excel links for beginners to Experts</a><br> <br> <font color="Red"><b>Forum Rules </b></font>&gt;&gt;&gt;<a href="http://www.excelforum.com/showthread.php?t=642590" target="_blank">Please don't forget to read these</a></div></blockquote> </div> <div class="cleardiv"></div> </div> </div> <div class="postfoot"> <div class="textcontrols floatcontainer"> <span class="postcontrols" style="width:60%"> <img style="display:none" id="progress_2072885" src="https://www.excelforum.com/images/misc/progress.gif" alt=""> <a target="_blank" id="qrwq_5837" class="newreply" href="http://www.excelforum.com/register.php" rel="nofollow"><img id="quoteimg_5837" src="https://www.excelforum.com/clear.gif" alt="Reply With Quote">Register To Reply</a> </span> <span class="postlinking"> </span> </div> </div> <hr> </li> <li class="postbitlegacy postbitim postcontainer old" id="post_2072892"> <div class="posthead"> <span class="postdate old"> <span class="date">04-08-2009,&nbsp;<span class="time">06:39 AM</span></span> </span> <span class="nodecontrols"> <a target="_blank" name="post2072892" href="https://www.excelforum.com/excel-general/679082-freezing-the-second-row.html#post2072892" class="postcounter">#3</a><a id="postcount2072892" name="3"></a> </span> </div> <div class="postdetails"> <div class="userinfo"> <div class="username_container"> <div class="popupmenu memberaction"> <a target="_blank" class="username offline popupctrl" href="https://www.excelforum.com/members/118392.html" title="Rudey is offline"><strong>Rudey</strong></a> <ul class="popupbody popuphover memberaction_body"> <li class="left"> <img src="https://www.excelforum.com/images/site_icons/profile.png" alt=""> <a target="_blank" href="https://www.excelforum.com/members/118392.html"> View Profile </a> </li> <li class="right"> <img src="https://www.excelforum.com/images/site_icons/forum.png" alt=""> <a target="_blank" href="https://www.excelforum.com/search.php?do=finduser&userid=118392&contenttype=vBForum_Post&showposts=1" rel="nofollow"> View Forum Posts </a> </li> </ul> </div> <img class="inlineimg onlinestatus" src="https://www.excelforum.com/images/statusicon/user-offline.png" alt="Rudey is offline" border="0"> </div> <span class="usertitle"> Registered User </span> <span class="postbit_reputation" id="repdisplay_2072892_118392" title="Rudey is becoming part of the community"> <img class="repimg" src="https://www.excelforum.com/images/reputation/reputation_pos.png" alt=""> </span> <hr> <dl class="userinfo_extra"> <dt>Join Date</dt> <dd>04-06-2009</dd> <dt>Location</dt> <dd>Melbourne, Australia</dd> <dt>MS-Off Ver</dt> <dd>Excel 2007</dd> <dt>Posts</dt> <dd>19</dd> </dl> <div class="imlinks"> </div> </div> <div class="postbody"> <div class="postrow"> <h2 class="title icon"> Re: Freezing the SECOND Row </h2> <div class="content"> <div id="post_message_2072892"> <blockquote class="postcontent restore"> <div style="float:right"> <script type="text/javascript"><!-- google_ad_client = "pub-8275723683113357"; /* excelforum 300x250 */ google_ad_slot = "9830241510"; google_ad_width = 300; google_ad_height = 250; //-->

   I can't find the window thing in Excel 2007 sorry

   
   I see the Freeze Panes drop down menu, and I can freeze either the top row or first column, but I can't see that option
   

09-20-2009, 08:58 AM #5

Registered User

---

Re: Freezing the SECOND Row

Hi there,

Originally Posted by Rudey

I can't find the window thing in Excel 2007 sorry

I see the Freeze Panes drop down menu, and I can freeze either the top row or first column, but I can't see that option

There are actually two ways of doing it on Excel 2007...

1. Split option: Using the Split functionality, which splits the spreadsheet in 4. You can then adjust the limits to the second line and click on the Freeze Panes option.

2. Copy and Paste option: Freeze Pane the top row. Add two rows before the frozen one: on the second row paste the one you would like to freeze, on the first paste the one automatically frozen. Then you just have to delete the originally two rows. Confused with this second option?

Best regards,
rfarinha

---

06-02-2010, 09:24 AM #6

Registered User

---

Re: Freezing the SECOND Row

Hi ..

hope you are doing well ,

Simply .. To freeze more than just the first column, click the column immediately to the right of the last column you want to freeze. For example, to freeze columns A, B, and C, click column D, and then click Freeze Panes on the menu.

It works

.

Good luck .

---

03-04-2020, 02:21 AM #7

Registered User

---

Re: Freezing the SECOND Row

Guys it is quite simple than we think...
Here is how - for a sec remove the top row temporary, which will make your labels row first then freeze it with the option 'Freeze top row',
then next simply right click in the first row -> click insert -> entire row.
Now put back your previous top row content back.

Thanks
YP

---

How do I freeze the top second row in Excel?

How do I freeze the second row in Excel 2020?

How do I freeze the top two rows in Excel Online?