Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - Sort data with different size cells
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel computer training london - Sort data with different size cells
Resolved · Low Priority · Version Standard
Reply
Sort data with different size cells
Dear Sir,I have made a big data base with columns that are named after - Store - City- Country etc.
I would like to sort the data according to the country and normally that works but now, because some of the cells in column A have been merged - it does not seem to work.
Could you help me with this?
Thank you. Kind regards
For upcoming training course dates see: Pricing & availability
RE: Sort data with different size cells
Hi MarjoleinThank you for your question.
A sort will not work on a column that contains any merged cells, so the merged cells will need to be unmerged (which you can do by clicking the merge button on the formatting toolbar) then enter the relevant data into each of the cells.
Amanda
|
|
 |
|
» Forum post: Excel concatenation?? if?? |
Hi,
