We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Another Excel question sorting colums
eddiebb
Posts: 14 Forumite
in Techie Stuff
I have a sheet with headings every 3 colums and information in the 3 colums.
so A1 has a heading and colums A B and C have related data.
D1 has heading D E and F have data
and so on
Is it possible to sort these in groups left to right or would I have to give each colum a heading?
so A1 has a heading and colums A B and C have related data.
D1 has heading D E and F have data
and so on
Is it possible to sort these in groups left to right or would I have to give each colum a heading?
0
Comments
-
You should to give a heading to each column you wish to sort, but it is possible not to, as long as you remember the column letter that you want to sort on.
Also, pet hate of mine... Why have you left row 1 and column A blank? That means sorting and filtering become more cumbersome to do. If it's to do with printing, the. Adjust the settings when you print, but please, start spreadsheets at A1, not B2.
Actually, I'm not sure a sort will work on row 2 if there are no headings...1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0 -
Also, pet hate of mine... Why have you left row 1 and column A blank?
To make the borders of the blocks more visible to hopefully make explaing easier. I had started A1 but inserted row and colum for clearer visibility.
I could add headings to other colums so A-A1-A2-D-D1-D2-C would make sorting easire but more work on sheet which I hoped to avoid if I canActually, I'm not sure a sort will work on row 2 if there are no headings...0 -
Ok, well if you move it back to A1, you should be able to sort. Select the complete sheet, go to sort and it should list the columns by letter if there is no title in the column.1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0 -
Ok, well if you move it back to A1, you should be able to sort. Select the complete sheet, go to sort and it should list the columns by letter if there is no title in the column.
but unless I fill the empty cells A-A1-A2-D-D1-D2-C
then it would just sort A-E and the other 10 colums would go to the end.0 -
Ok, I think you're going to have to explain what way you want it sorted, also what is the link between the data in the first column with that in the second and third, and why can't you give each one a title?1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards