Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Video Tutorials : Excel Navigation
Free Video Tutorials : Excel Navigation
Search

EXCEL NAVIGATION: HOW TO MERGE CELLS

Learn how to merge cells in Microsoft Excel

Background information and resources for Excel courses that we hope you find useful

Merging two or more adjacent cells might be useful when you want your title to be centred over a particular section of your spreadsheet. It can be useful when building tables with very specific layouts and changing the appearance of a table.

THE MERGE AND CENTRE BUTTON

The Merge and Centre button has been on the Excel toolbar and ribbon for many years and is usually the option people need.

For example, in this case, our aim is to merge cells A1 to D1 and our title will be 'Sales Results' which is centred across the table of data.

The Merge and Centre button

Click A1 and highlight over to D1, then click on the Home Tab in Excel and click Merge & Centre.

Excel Navigation: How to merge cells

Now your title is nicely merged and centred. It worked because the text was originally in A1. If there had been any text or numbers in B1 to D1, this would have been overwritten.

OTHER OPTIONS WHEN MERGING CELLS

There are a few other options, however, when merging cells. Let's say you wanted to do the same as before but you didn't want to centre the text, just leave it left aligned. Easy! Just follow the same procedure only this time, select Merge Cells (without the & Centre bit).

Another handy option is when you want to merge a number of rows across. Take the below example. In this timetable, the student has allotted a study period between 12 and 2 of each day. Of course, it would be easy enough to highlight across each study period and merge the cells but you would have to do this 5 times.

Other options when merging cells

Instead, you can highlight all of the cells you wish to merge across, select the merge options from the home tab and this time, select Merge Across.

If you'd have highlighted this region and simply merged, it would have made one big cell. With this option, you can see that each of the rows are merged across.

Who knew there were so many options?!

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Main Excel Resources Page

Excel Resources

Video tutorials & articles, and templates to help you work better in Excel

      Click to view

 

Video Tutorials - Navigating Excel

Video Tutorials - Navigating Excel

Navigate and control the layout of your spreadsheets to make working with Excel much easier

Click to view

Excel Navigation: Why selecting multiple cells?

Excel Navigation: Why selecting multiple cells?

See how to fix accidental selection of multiple cells and how to use multiple selection in your work with Excel

      Click to read more

 

Excel Navigation: How to hide sheets

Excel Navigation: How to hide sheets

Learn how to hide worksheets when working with Microsoft Excel

      Click to read more

Excel Navigation: How to remove blank rows

Excel Navigation: How to remove blank rows

Useful tricks to help you remove blank rows in Microsoft Excel

      Click to read more

 

Excel Navigation: How to lock cells

Excel Navigation: How to lock cells

Learn how to lock cells in Microsoft Excel

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

HOW TO MERGE CELLS IN MICROSOFT EXCEL

We can enhance your skills with courses for Microsoft Excel spreadsheets at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Video Tutorials : Excel Navigation.

Why not contact us today to see how we can help with providing your MS Excel classes ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top