Hi all,
Hope all are well.
In attached file, cells C5 to C11 are merged with column D. When i try to copy and paste data in C5 to C11, excel gives error as below
Capture1.PNG
Capture2.PNG
Is there anyway this issue can be solved?
Note: Sheet will always be protected.
Don't merge cells - it's the kiss of death.
Use centre across selection instead: https://www.wallstreetprep.com/knowl...lection-excel/
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW.
Thanks for your response.
It already tried but that will unmerge and create 2 different cells i.e. C5 and D5 whereas i want just 1 because data needs to be entered in 1 single cell.
I cannot keep 3 columns since some of the rows contain 4 cells. As a result keeping 3 columns initially will disturb the entire form's layout
Short answer - no.Originally Posted by rizwanulhasan
Shorter answer - dont use merge
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I concur with Ali and Ford. Merged Cells are the road to disaster
https://www.youtube.com/watch?v=ghK2VIT2XJw
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Try this:
Format cells
Alignment
Horizontal
Center across selection
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
You enter the data into C5, but once centred across the selection (C5 and D5), the text will loook identical to a merged cell.It already tried but that will unmerge and create 2 different cells i.e. C5 and D5 whereas i want just 1 because data needs to be entered in 1 single cell.
You are making frankly silly arguments for continuing to use merged cells, which should always be avoided.
Hi all,
I now understood that merge cells are to be avoided. The only way left is to change the form layout.
Many thanks to all for your responses
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks