Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel 2003 - column select
- Thread starter theo1881
- Start date
PeterMoran
MIS
Hi,
Select all the cells as you have done previously, which will include the merged cells.
Use Format, Cells, Alignment, and under Horizontal select the bottom entry "Centre Across Selection", then ensure the Merged Cells box is clear, and select OK.
Repeat above but select "General" this time.
The merged cells will now be gone and your Horizontal format will be set to the default.
Most Excel experts do not use merged cells for the very type of problem you have - a much better way to go is to use "Centre Across Selection" which does what most people want without the problems.
Good Luck!
Peter Moran
Select all the cells as you have done previously, which will include the merged cells.
Use Format, Cells, Alignment, and under Horizontal select the bottom entry "Centre Across Selection", then ensure the Merged Cells box is clear, and select OK.
Repeat above but select "General" this time.
The merged cells will now be gone and your Horizontal format will be set to the default.
Most Excel experts do not use merged cells for the very type of problem you have - a much better way to go is to use "Centre Across Selection" which does what most people want without the problems.
Good Luck!
Peter Moran
ThomasLafferty
Instructor
You also must be using an older version of Excel, say Escel 97. In later versions of Excel, merging will still allow you to select just one column which contains merged cells, and since you aren't able to duplicate this on other PCs, my guess is the PCs you are testing this on are loaded with a later version of Excel. Incidentally, Peter is right: merged cells can be problematic, not just in formatting cases, but in formulas as well. If I merge cells, and then write a formula which makes reference to the merged cells, it looks like my formula is evaluating the whole range of merged cells, but in reality it is only using the upper left hand corner of the range. Best not to merge unless absolutely necessary.
Tom
Live once die twice; live twice die once.
Tom
Live once die twice; live twice die once.
- Thread starter
- #4
thomas
i am of course grateful for your reply but please do not assume that i do not know which version of excel i am using. while i am the first to understand that the basics need to be checked i would not have titled the post excel 2003 if we were using 97.
apologies for the rant but it had to be said
if my post wasn't clear then i apologise
Laters, phat, headshape
i am of course grateful for your reply but please do not assume that i do not know which version of excel i am using. while i am the first to understand that the basics need to be checked i would not have titled the post excel 2003 if we were using 97.
apologies for the rant but it had to be said
if my post wasn't clear then i apologise
Laters, phat, headshape
ThomasLafferty
Instructor
No offense taken - LOL!
I was just checking to see if your user was using a different version than you are since you mentioned that you couldn't duplicate it on any other PC...
Tom
Live once die twice; live twice die once.
I was just checking to see if your user was using a different version than you are since you mentioned that you couldn't duplicate it on any other PC...
Tom
Live once die twice; live twice die once.
- Status