Hi guys,
See attached spreadsheet.
I'm making an order form that will eventually have cells locked unless they need editing. Row 6 has has the cells merged where as Row 14 does not.
Is there a good reason in favor of merging as I generally prefer not to? When locking will it be easier to have unmerged cells?
Thanks Andy
If the header columns are going to be used in any formulae, never use merged cells. Never use merged cells in the body of your data. I would remove all the merged cells below Row 1!! Merged cells are the spawn of Satan and will sneak up behind you and cause serious problems, sooner or later.
You may gather that I don't like merged cells very much!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Andy
Why would you need/want to merge the cells in row 6?
If posting code please use code tags, see here.
No, none at all.Is there a good reason in favor of merging
That's the right choice. Well done, you!I generally prefer not to
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.
Looking at it again you are right as there is nothing in cell B6.Why would you need/want to merge the cells in row 6?
Looks like I've hit a Excel form "pet peeve" there must be some good reasons for merging.
It's not a 'pet peeve' - it's something that you just shouldn't do if the data is going to need analysing and/or manipulating in any way. Glenn has intimated why in his earlier post.
People merge cells for presentation purposes. There's usually plenty of workarounds like removing gridlines or "Center across selection." Ideally, you enter data on one sheet and set up another sheet for presentation purposes.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Cheers I'll have a look at center across selection.
I think that centre across selection causes more problems than merge.
What problems?
Is there any REAL need to use either?
I like that!! Bookmarked for future use.Originally Posted by Pepe Le Mokko
tails1
What problems does center across selection cause?
P.S. While I agree you should never used merged cells when a sheet is being used for calculation/analysis etc. there's (usually) no harm in using them for presentation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks