Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER
I am creating a data chart to keep records of old tenants, I am using cells A
thru j, left to right, but top to bottom needs to be left open to continually add more tenants as they leave, this way I don't need to keep paperwork. I would like to list these alphabetically, but do not want colum A to be separated with the respective colums of information that go with it. How do I alphabetize keeping for example A1 - AJ together.......I am somewhat new at this |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER
Lolly57,
Try highlighting the columns A:J and then going to DataSort...Column A (Ascending/Descending). -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "lolly57" wrote: I am creating a data chart to keep records of old tenants, I am using cells A thru j, left to right, but top to bottom needs to be left open to continually add more tenants as they leave, this way I don't need to keep paperwork. I would like to list these alphabetically, but do not want colum A to be separated with the respective colums of information that go with it. How do I alphabetize keeping for example A1 - AJ together.......I am somewhat new at this |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER
select all your data and click on "Format as Table" and select a table format
this will show an arrow on every title of your every column. clicking this arrow you can sort a-z or z-a etc. "lolly57" wrote: I am creating a data chart to keep records of old tenants, I am using cells A thru j, left to right, but top to bottom needs to be left open to continually add more tenants as they leave, this way I don't need to keep paperwork. I would like to list these alphabetically, but do not want colum A to be separated with the respective colums of information that go with it. How do I alphabetize keeping for example A1 - AJ together.......I am somewhat new at this |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER
Select columns A to J before DataSort.
Don't let Excel guess the range to sort. Gord Dibben MS Excel MVP On Wed, 8 Oct 2008 10:23:01 -0700, lolly57 wrote: I am creating a data chart to keep records of old tenants, I am using cells A thru j, left to right, but top to bottom needs to be left open to continually add more tenants as they leave, this way I don't need to keep paperwork. I would like to list these alphabetically, but do not want colum A to be separated with the respective colums of information that go with it. How do I alphabetize keeping for example A1 - AJ together.......I am somewhat new at this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort data in data area in a pivot table | Excel Discussion (Misc queries) | |||
HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |