ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze top 2 rows - how (https://www.excelbanter.com/excel-discussion-misc-queries/242957-re-freeze-top-2-rows-how.html)

Martin ©¿©¬ @nohere.net

Freeze top 2 rows - how
 
On Thu, 17 Sep 2009 04:38:01 -0700, Ms-Exl-Learner
wrote:

Just place the cursor in the 1st cell of 3rd row and give ALT+W+F and enter.

For example I want to freeze upto 5 rows then cursor should be placed in A6
Cell and if we give ALT+W+F and enter it will freeze the 5 rows

If this post helps, Click yes!

--------------------

Thank you David & (MS-Exl-Learner)
That got me sorted
--
Martin
©¿©¬


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com