Combine Cells In Excel Mac In 09

Dont ask me why that is.

It just is. 2. Make sure the Workbook is NOT set to be shared.

TOOLSSHARE WORKBOOKUncheck the box that says Allow changes by more than one user at the same time.

Just click on the Toolbox icon in the top portion of Excel, and click on the triangle next to Alignment and Spacing.

He took his first computer class when he was just 8 years old.

He always had an affinity for computers, but never really took it seriously.

It was not until he graduated from college and experienced the real world for a while did he realize that computers may be where his talent and passion lie.

At the bottom of that section, under Indentation and Merge, you will see a checkbox that you need to checkuncheck, depending on whether you want to mergeunmerge.

If it is grayed out, then you need to make sure that when you are selecting the cells that you want to mergeunmerge, that you are holding down the SHIFT key, and NOT the Command key.

Combine Cells In Excel Mac In 09

I bought my Mac in 09, so whatever the version of Excel was available is what I have, and I only have the option to merge all the cells.

It throws other merged things off in the columns, you know Ugh, Im a mess; I applogize, and again, thank you so much for your response.

Since, when you merge cells, the selected cells ALL become ONE cell, then just merge them one row at a time.

Fail (SO sorry) I did not mention in my original post that I wanted to do it all at the same time, which is why I was asking about AB 1-20.

My version of excel has a button on the toolbar (not even sure if thats what it is, but the buttons for fonts, sizes, save, print, etc.

If I click that button, it will merge AB 1-20 into one ginormous cell, instead of leaving 20 rows of one AB column.

That was also why I mentioned that my 07 PC Excel had several options as to how you wanted to merge the cells.

I can select every other row of columns AB merge them, then go in between those merge the remaining rows Id like, but its a pain, which is why I wanted to just select AB 1-20 and merge across.

At this point, I dont think its an option; its not in the toolbox, not when I click command 1, and certainly not the little box in the toolbar.

Not sure if it does it or not, but its worth a shot if you have to do that task a lot.

Why would they get rid of such a wonderful little buttonoption If I ever get a solutionway how, I will definitely post back Again, thank you so much for your help.

How To Combine Cells In Excel For Mac