Sort Problem
I have a file with 500 row, 7+ columns of data. At some point last year, I must have sorted it without highlighting the last column. Consequently, it is all discombobulated. In future, I will sort it by highting the rows rather than all the cells. However, I am wondering if there is some way to 'lock in' a sort so that every time I sort it, all the columns are automatically included (ie - is there a way to remove stupid human error)? -- Joe |
The best way to do this would be to create your own macro and then attach it
to a button that initiates the sort. Simply record how you want to do a sort, add a command button and then attach the button to your macro. If you need more help come back J "jdb" wrote: I have a file with 500 row, 7+ columns of data. At some point last year, I must have sorted it without highlighting the last column. Consequently, it is all discombobulated. In future, I will sort it by highting the rows rather than all the cells. However, I am wondering if there is some way to 'lock in' a sort so that every time I sort it, all the columns are automatically included (ie - is there a way to remove stupid human error)? -- Joe |
All times are GMT +1. The time now is 08:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com