ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lock rows together (https://www.excelbanter.com/excel-discussion-misc-queries/73692-lock-rows-together.html)

CBrausa

Lock rows together
 

Is there a way to lock 3 or 4 rows of information together so that when
you do a filter or data sort they will stay together?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=516189


Dave Peterson

Lock rows together
 
Put the same key into a cell on each row--and maybe use a second column to
indicate which record they are of that group.

But that gets pretty crummy pretty fast.

There's no way you can use one long row and hide/show the columns when you need
them?

CBrausa wrote:

Is there a way to lock 3 or 4 rows of information together so that when
you do a filter or data sort they will stay together?

--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=516189


--

Dave Peterson


All times are GMT +1. The time now is 10:02 AM.

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