Merging identical cells automatically
I am new to coding and cant seem to figure out an easy way to merge identical cells automatically. the only reason I want to merge is to neaten up the table
column A has all the duplicates, I would like to merge column A and keep the top value.
Second question ... is it possible to merge cells in a table? and will the merging still work if the filter is applied in the table?
thanks
Hi AlastairT
Welcome to the forum ...
Best advice you could get will be, avoid merging cells in any table structure, better still forget that merging cells even exists.
They will give you trouble when sorting, copying, etc, etc ...
Think of other ways to neaten your sheet.
If you are talking about an Excel Table (List in pre-2007) then you can't merge cells.
If microsoft decided to disable merging in their tables, that should tell you something.
Last edited by Marcol; 09-08-2011 at 05:03 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks