Column headings not lining up in Excel for Mac 2011

[drffc]

Hi,

I got a sales spreadsheet from a vendor.

When I click its column headings (A, B, C, etc)
not all of the data in the column below the heading
is selected.

I've included some screenshots of various columns
selected.

How to get the column headings to select the entire
column below its heading?

And, if you'll look at "Item Description" it has 3 column
headings --B,C,D-- above.

Why?

How to get just one-to-one correspondence between
column headings and the column?



Thanks!

[candybg]

You have merged cells.
Unmerge and you should be able to work with your data - but you may also find you have unused columns that should be deleted OR set to a zero width.

[drffc]

Hi,

Thanks!

I'm a real newbie ... can you tell me how to un-merge cells?

Thanks!

[kdoug13]

Select all your data by clicking the triangle in the top left corner of the spreadsheet. Then click the button on the bar at the top that says "merge", and select unmerge cells

[drffc]

Hey! I found it:

https://kb.wisc.edu/helpdesk/page.php?id=939

I just un-did what it advised to do to merge cells.

But tell me ... why would anyone want to merge cells
in the first place?