Originally Posted by
Daddy_O
I am creating a simple check register in Excel. I have set it up to look like a check register with all the data for a single check being entered into a row. I want to be able to sort the data by using the columns to sort ascending/descending and keep the data in the row intact, then sort by date, check number, amount, etc. When I currently do this only the data in the selected column sorts and it is no longer associated with other data in the row. I know I can double click in the upper most left cell to select all of the data and then sort but this limits my sorting options to one type of check attribute. So I guess my question is, Can I lock the data in a row so that it can be sorted by column and never scrambled or disassociated with the other data it is associated with in the row?
Thanks in advance
Daddy_O
Bookmarks