Get rid of merged cells! Debate

[Greg Truby]

...Shouldn't your superscript 1 be between the I and m?

Tried it that-a-way. But then it wasn't quite obvious enough (the superscripted one kind of looked like an apostrophe), so I opted for the end-of-word position. Perhaps Emma can give us a ruling on whether a footnote can even be placed mid-word?

 

[riaz]

Lewiy - CENTRE ACROSS SELECTION!

(I can't believe you are one of Them. I always thought you were a good guy...)

Emma....

Are you saying I'm now a bad guy? Yesterday you liked my pic. Today you're sticking pins in me?

 

[RoryA]

and an adjudication on whether 'grammar wise' [sic]:
a) is a word
b) needs a hyphen

 

[cornflakegirl]

Hyphen. Again, I wasn't going to comment. I think Rory's after my podium spot

Riaz - that was aimed at Lewiy, for unnecessary use of merge. I'd never be mean to you!

 

[riaz]

Riaz - that was aimed at Lewiy, for unnecessary use of merge. I'd never be mean to you!

Yaaay! Emma has approved of my use of merge

Nice weekend all. Off to Bxls tomorrow for the day, who knows, might bump into Erik?

 

[Greg Truby]

and an adjudication on whether 'grammar wise' [sic]:
a) is a word
b) needs a hyphen

Hyphen...

Ya know, I mulled ’n’ I pondered a mite o’er dat dere dash ’n’ whether or not a feller oughtter drop one twixt them two words. But all that bother over a wee bit o’ punctuation jus’ made the Mark Twain fan in me start ta fuss and fidget like a five-year-old lad after twenty minutes on a pew, so I let it go.

 

[erik.van.geit]

wow, walked away for some hours and so many replies

Off to Bxls tomorrow for the day, who knows, might bump into Erik?

Bxls, is that Bruxelles (French), Brussels (English I hope), Brussel (Dutch)
We could do an effort? Do you live close to Brussels?

About merged cells.
Those who want to get rid of them, please test the code
UNMERGE and CENTER ACROSS

Seems like we agree. I will try to summarise using some key words.
Merged cells
STATIC - DISPLAY - PRINT - OUTPUT: ok
DYNAMIC - CALCULATION - DATA MANIPULATION: nono

To Lewyi.

they can be quite useful. Yes there are always alternatives but not necessarily satisfactory ones. Let’s say I have a report spanning 10 columns and I want a heading in row 1 centred across the top. If it were 9 columns, I could place my heading in column E and centre the text, but I have 10 columns……so what do I do? I “merge-and-centre” cells A1:J1….job done.

Seems like you didn't understand the "center across selection". If you want something centered in A1:J1, enter it in A1, then select A1:J1 and "center across selection". 10 columns and perfectly centered

best regards,
Erik

 

[dcofer]

Hello Erik,

Thanks for the discussion. I had never heard of Center Across Selection before. I always used Merge and Center, not realizing the problems it could cause until I read this thread. I use the M&C to make the worksheet more appealing.

I was not for sure how to Center Across Selection, but I searched the internet and quickly found it. (Probably should have searched this site first, but I didnt) CAS is much better! The look is the same to the naked eye, and it does not have the problems associated with M&C. Now, I want to go change all my sheets with M&C to CAS.

The more I learn, the more I realize how really little I know.

---dave

 

[erik.van.geit]

Now, I want to go change all my sheets with M&C to CAS

Well, it's you who inspired me to enhance a code made some months ago. So now you can use it for all your sheets.

 

[dcofer]

Well, it's you who inspired me to enhance a code made some months ago. So now you can use it for all your sheets.

While I would love to take credit for inspiring you to enhance the code, I do not recall what post it was. Most likely, your inspiration came from someone else.

---dave