ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a way to lock two or more rows together? (https://www.excelbanter.com/excel-worksheet-functions/60620-there-way-lock-two-more-rows-together.html)

christy

Is there a way to lock two or more rows together?
 
I would like to be able to lock one or more rows together so when I sort the
data these rows sort as one row. Is this possible?

Dave Peterson

Is there a way to lock two or more rows together?
 
Maybe putting a key in both rows and including a row number (1 or 2) in that key
would work.

But if you can put the data in one row, your life would be much simpler.

christy wrote:

I would like to be able to lock one or more rows together so when I sort the
data these rows sort as one row. Is this possible?


--

Dave Peterson

Gord Dibben

Is there a way to lock two or more rows together?
 
NO.


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 09:39:05 -0800, "christy"
wrote:

I would like to be able to lock one or more rows together so when I sort the
data these rows sort as one row. Is this possible?



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

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