ExcelBanter - How do I Un-merge two columns half way down?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I Un-merge two columns half way down? (https://www.excelbanter.com/new-users-excel/130154-how-do-i-un-merge-two-columns-half-way-down.html)

Hattie

How do I Un-merge two columns half way down?

I am creating a name & address list for a club. Half way down two columns (F
and G) have merged. I cannot get it back into two separate columns again. Can
any-one advise me, please? I am using Excel from Office 2000.

Max

How do I Un-merge two columns half way down?

Try selecting the col headers F and G
Then click Format Cells Alignment tab
Click* as required to uncheck "Merge cells" completely OK
*you may probably need to click twice
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hattie" wrote:
I am creating a name & address list for a club. Half way down two columns (F
and G) have merged. I cannot get it back into two separate columns again. Can
any-one advise me, please? I am using Excel from Office 2000.

All times are GMT +1. The time now is 02:13 AM.