Microsoft Excel Tip #8

//Microsoft Excel Tip #8

 

Merged Cells

Merged Cells are pretty easy to use.  A “merged cell” is two or more cells joined together to form one big cell.  Usually, merging is simply a formatting feature.  Let’s look at our two examples.  First, a standard spreadsheet comparing values across months and years.

Merged Cells 2

This gives us our values, but it’s just a little boring and not eye catching at all.  What happens if we merge cells?  Highlight the cells you would like to combine and choose Home | Alignment | Merge & Center.  Now we have something just a little nicer!

Merged Cells

We admit, we changed the orientation of the text in the first merged cell so this looks a bit more appealing, but that was all.  For orientation, right click on the cell and go to Format Cells and the Alignment Tab.

Stay tuned next week for how to add more formatting to your spreadsheets!

 

If you would like to learn more about this or any Microsoft Dynamics product, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!

Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.

2017-08-02T13:58:00-04:00