If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge and Center Problems
Has anyone experienced problems with the Merge and Center
feature in Excel? If so...what are they? I was told to avoid this feature because it interferes with other things I may want to do on the worksheet. So far I haven't encountered any. Is there any merit to this claim?? |
#2
|
|||
|
|||
Merge and Center Problems
I am one of those who have been avoiding this method. The main reason is it wouldn't let you insert, delete, cut or paste a column between merged columns. You could use the "Center Across Selection" in cell formatting diabox which allows you to do all that while serves the same purpose.
"Lynn" wrote: Has anyone experienced problems with the Merge and Center feature in Excel? If so...what are they? I was told to avoid this feature because it interferes with other things I may want to do on the worksheet. So far I haven't encountered any. Is there any merit to this claim?? |
#3
|
|||
|
|||
Merge and Center Problems
Lynn
Have you tried cutting, copying, pasting, sorting, filtering with merged cells? Experiment a bit and you'll soon find why the caveat to not use the merged cells feature. Gord Dibben Excel MVP On Wed, 30 Jun 2004 10:22:52 -0700, "Lynn" wrote: Has anyone experienced problems with the Merge and Center feature in Excel? If so...what are they? I was told to avoid this feature because it interferes with other things I may want to do on the worksheet. So far I haven't encountered any. Is there any merit to this claim?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge and Center, Text disappear | Raymond | Charts and Charting | 1 | June 18th, 2004 11:28 AM |
Merge and center, text disappear | Raymond | Worksheet Functions | 1 | June 16th, 2004 08:16 PM |
mail merge data source | Randy | Contacts | 4 | May 31st, 2004 02:58 AM |
Merge and Center | Michael | Worksheet Functions | 4 | April 18th, 2004 01:10 PM |
Merge columns | Jonesy | Worksheet Functions | 1 | October 10th, 2003 06:21 PM |