Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    Top 10 Useful Car Accessories & Gadgets You Can Buy on Amazon

    12.04.2022

    Top 10 Must Have Health & Fitness Gadgets

    29.03.2022

    Top 10 Most Innovative Pop Up Camper Trailer on the Market

    28.03.2022
    Facebook Twitter Instagram
    Facebook Twitter Instagram Vimeo
    • English
      • Français
      • Deutsch
      • Italiano
      • Português
      • Русский
      • Español
    My Blog
    Subscribe Login
    • Home
    • Contact
    • Editors’ choice
    My Blog
    Home » How to Combine Cells in Excel

    How to Combine Cells in Excel

    William ParkerBy William Parker02.11.2021No Comments4 Mins Read
    Facebook Twitter Pinterest LinkedIn Tumblr WhatsApp VKontakte Email
    Share
    Facebook Twitter LinkedIn Pinterest Email

    Excel offers extensive functionality for its users. But to enjoy all these benefits, you need to study all the available functions of this Microsoft app. In this article, we are going to show you how to combine cells in Excel.

    We suggest you to study several ways on how to combine two cells in Excel to choose the one that is convenient for you. We will also share the secret of how to combine cells so that the values inside them are saved.

    The 1st way to merge cells in Excel

    We will do this through the main menu of the app. To perform this function, follow the instructions below.

    Step 1. Select the cells you want to merge

    Step 2. Select the “Main menu”

    Step 3. Find the “Merge Cells” icon

    When you click on this icon, the two cells will turn into a single one.

    Moreover, if one of the cells contained values, they will be saved in the new cell. And the information will be aligned to the center of the cell.

    “Merge Cell” Options

    The “Merge Cell” icon offers us even more functionality for working with cells.

    To see all available options, click on the small down arrow next to the icon:

    Then you will see a window with the following options:

    The first option “Merge and Center” is what happens automatically when clicking on the icon. The cells are merged into a single one, and the information is displayed in the center of the new cell.

    The second option “Merge Across” provide with combining by lines; it allows us to select a large range of cells, within which the cells are merged by lines. For example,

    Step 1. We’ll highlight the following cells:

    Step 2. Choose the “Merge Across” option to combine the cells by lines:

    Step 3. Our cells are transformed like this:

    The third option “Merge Cells” will make the values inside the cell right-aligned.

    And the fourth option “Unmerge Cells” provides canceling the merge function. If you accidentally merged the wrong cells, you can use this function.

    The 2nd way to combine cells in Excel

    The next way on how to combine cells in Excel can be done through the right-click context menu of the mouse.

    Step 1. Select the desired range of cells

    Step 2. Select the desired range of cells. Such a window will appear

    Step 3. Find the “Format Cells…” line

    Step 4. Go to the “Alignment” tab in this menu

    Step 5. Check the box next to “Merge Cells”

    Step 6. Click on “OK”

    Thus, the cells you selected turned into a single one.

    The described methods of how to combine two cells in Excel are suitable if only one of the two selected cells or none of the cells contained values.

    If you start combining several cells, each of which contains some information, the Microsoft app will give you a warning:

    If you are willing to donate your values, you can confirm merging. In such a way, merging cells only keeps the upper-left value and discards other values.

    If you want to save values from all the cells, you can follow these options:

    • Overwrite values from all the cells into one manually
    • Copy and paste the values via keyboard shortcuts or a context menu

    In any case, the program does not yet offer us an option on how to combine two cells in Excel by simultaneously combining all the information in them at once.

    We told you about the easiest and fastest ways of how to combine cells in Excel in this article. Choose the option that is convenient for you and use it as needed.

    Now, the multifaceted functionality of the Excel app will not be so mysterious and incomprehensible to you.

    cells combine excel guide how to merge
    Share. Facebook Twitter Pinterest LinkedIn Tumblr WhatsApp Email
    Previous ArticleHow to Add Fonts to Word on Mac
    Next Article How to Delete Pins on Pinterest
    William Parker
    • Website

    Related Posts

    How to Find WiFi Passwords on Mac

    08.11.2021

    How to Sync Bookmarks in Chrome

    08.11.2021

    How to Transfer Contacts from Android to iPhone via Bluetooth

    08.11.2021

    How to Make a Standard Curve in Excel

    08.11.2021

    Leave A Reply Cancel Reply

    picks

    Subscribe to Updates

    Get the latest creative news from SmartMag about art & design.

    About Us

    The main objective of the portal votetopbest.com is to provide up-to-date, objective and expert information on all categories of goods sold in online hypermarkets, from coffee machines, cordless vacuum cleaners to gaming PCs, drones and noise canceling headphones.

    picks
    New Comments
      Facebook Twitter Instagram Pinterest
      • Home
      • About us
      • Terms of Use and Policies
      © 2023 Created with love...

      Type above and press Enter to search. Press Esc to cancel.

      Sign In or Register

      Welcome Back!

      Login to your account below.

      Lost password?