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