How to make a nice looking table with Excel? (Merged Cells have created a nightmare) (2024)

How do you make a nice-looking table to paste into a Word document? I tried merging some cells to make it look nice, but that has caused many random, nonsensical, and infuriating problems.

I used merged cells because some table parts needed 1, 2 and 3 columns to make sense. Only the table sheet has merged cells. The information sheets it is pulling from have no merged cells.

I need an alternative. I am about to pull out my hair.

If you want to read, here are the problems I had using merged cells to make an table to paste into a word document.

1. I couldn't paste a 17 row x 2 column selection into a 17 row x 2 column selection with merged cells. There are zero reasons that it should be more than a 5 second task. I have to paste it into each cell manually.I tried so many different things that completely messed up my excel sheet. Which wasted more of my time. Some formulas were destroyed, for some g***bleep** reason when I posted the table to A Word Doc all the cells were unmerged and some colors randomly changed (This was fixed by a restart). This is ridiculous.

2. The Excel Program CONSTANTLY freezes when all I do is select cells. Sometimes if I wait 5-10 minutes it will come back... but when I am working on a project with coworkers, it is very embarrassing and a waste of everyone's time, both in the waiting and when I finally give up after making a coworker wait for 5 minutes and force excel to shut down and I have to redo work.

TLDR: Any way to make nice looking tables to paste in a word document without merged cells that have 1,2,3 columns in the same table?

How to make a nice looking table with Excel?  (Merged Cells have created a nightmare) (2024)
Top Articles
Latest Posts
Article information

Author: Gov. Deandrea McKenzie

Last Updated:

Views: 5974

Rating: 4.6 / 5 (46 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.