Remove Merge and Center for entire spreadsheet

[JE]

I copied and pasted from an HTML page several columns of information. When
it pasted into Excel, it merged several cells together. I want to remove the
merge so that I can manipulate the data. Is there a way to highlight the
entire spreadsheet and remove the merge? Many thanks.

 

[Buzz Local#30]

I am new to Excell but I will give a go at helping you out
I do know that you can click on the top left corner of a sheet in the corner
box where the row and colum heading are at and it will select all the cells
in the sheet and you could try to click on the merge button to unmerge all
the cells but I am not sure if it will or not you might have to merge all
the cells and then unmerge all the cells again I hope this helps

 

[Dave]

Hi JE,
Highlight the whole sheet by clicking on the little box just to the left of
the Column A header.
Then FORMAT > CELLS
On the Alignment tab, uncheck "Merge cells"
Regards - Dave.

 

[ryguy7272]

There is probably a better way of doing what you want to do. Do you have MS
Explorer on your system? If you can open this browser and navigate to the
web site of interest, right-click on the field that you want in Excel and
click 'Export to Microsoft Excel'. That will import the data you want and
you won't have to deal with those annoying formatting issues, such as merged
cells.

Regards,
Ryan---