Linked cells (?)
I'm trying to catorgoize my DVD library. Can I link cells together so
that if I want to sort one row, say by author, it will also re-arrange the cells/rows on each side. Not sure if that makes sense. I'd like to be able to look for an author alphabetically, without loosing the name of the DVD or catogory that's in the adjacent cells.next to the author |
Linked cells (?)
When you sort, highlight (select) all columns of your data. Then you can
specify which column to sort on. The other columns that you selected will get sorted as well. "Loki" wrote: I'm trying to catorgoize my DVD library. Can I link cells together so that if I want to sort one row, say by author, it will also re-arrange the cells/rows on each side. Not sure if that makes sense. I'd like to be able to look for an author alphabetically, without loosing the name of the DVD or catogory that's in the adjacent cells.next to the author |
Linked cells (?)
Thank you. I knew there must be a way. Am I right in thinking that
Excel is the best way to go for this? On Wed, 22 Apr 2009 20:25:01 -0700, dhstein wrote: When you sort, highlight (select) all columns of your data. Then you can specify which column to sort on. The other columns that you selected will get sorted as well. "Loki" wrote: I'm trying to catorgoize my DVD library. Can I link cells together so that if I want to sort one row, say by author, it will also re-arrange the cells/rows on each side. Not sure if that makes sense. I'd like to be able to look for an author alphabetically, without loosing the name of the DVD or catogory that's in the adjacent cells.next to the author |
Linked cells (?)
Excel is probably the best for your purposes. Access is Microsoft's database
application, but it is somewhat more difficult to learn than Excel. For a simple list of DVD's you should use Excel. "Loki" wrote: Thank you. I knew there must be a way. Am I right in thinking that Excel is the best way to go for this? On Wed, 22 Apr 2009 20:25:01 -0700, dhstein wrote: When you sort, highlight (select) all columns of your data. Then you can specify which column to sort on. The other columns that you selected will get sorted as well. "Loki" wrote: I'm trying to catorgoize my DVD library. Can I link cells together so that if I want to sort one row, say by author, it will also re-arrange the cells/rows on each side. Not sure if that makes sense. I'd like to be able to look for an author alphabetically, without loosing the name of the DVD or catogory that's in the adjacent cells.next to the author |
All times are GMT +1. The time now is 02:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com