Merge cells in Excel

 

Why Merge Cells in Excel?

The most common reason to merge cells is for formatting and centering headings. This guide will show you how to merge cells in Excel, even though it is highly recommended that you don’t merge them unless you absolutely need to. As an alternative, we recommend using the Center Across Selection feature. Learn with video instruction in CFI’s Free Excel Crash Course!

 

How to Merge Cells in Excel

Follow the steps below to learn how to easily combine multiple cells in an Excel spreadsheet. Use the screenshots as a guide and then try it on your own!

 

Step 1

Select the cells you want to merge. Highlight them with your mouse or by starting in one cell, holding Shift, then using the arrows to select to the end.

 

Merge Cells in Excel - Step 1

 

Step 2

On the Home Ribbon, select the Format Cells button, or press the keyboard shortcut Ctrl + 1 to open the Format Cells dialogue box.

 

Merge Cells in Excel - Step 2

 

Step 3

Inside the Format Cells menu, click on the Alignment tab and tick the box that says Merge Cells.

 

Merge Cells in Excel - Step 3

 

Learn step-by-step in CFI’s Free Excel Crash Course!

 

Step 4

Click center to place the title in the center of the merged cells and set a background color to make the title really stand out.

 

Merge Cells in Excel - Step 4

 

An Alternative to Merge Cells in Excel – Center Across Selection

Merging cells is not recommended because it interferes with actions you may wish to take later while building your financial model. For example, if you want to insert or delete columns across the middle of merged cells, you will not be able to.

You can achieve the same formatting outcome as merging cells by using the Center Across Selection function.

Follow the steps below to perform the action yourself.

 

Step 1

Select the cells you want to center using the mouse or holding the Shift key and using the keyboard arrows.

 

Center Across Selection - Step 1

 

Learn step-by-step in CFI’s Free Excel Crash Course!

 

Step 2

Open the Format Cells dialogue box on the Home Ribbon, or by pressing Ctrl + 1 (Windows shortcut, see the Mac equivalent shortcut).

 

Step 3

Now click on the Alignment tab and then choose Center Across Selection. Note: be sure to uncheck Merge Cells if it’s already checked.

 

Center Across Selection - Final Step

 

Congratulations! You now have nicely centered text without combining cells.

Comments

Post a Comment

Popular posts from this blog

Samsung galaxy m51 The Meanest monster launched today (10.09.2020) for Rs 24,999

Image
  Samsung Galaxy M51 The Meanest monster launched today (10.09.2020) for  Rs 24,999                                      According to this post revealed in Amazon.in.  Samsung launched their next m series smartphone m51.  Samsung compared this smartphone with a monster.  so many peoples are waiting for this smartphone as the first M series smartphone to have a great Snapdragon 730G Chipset and a massive 7000 mah battery with 25 watts fast charger .                                                  As in this post Samsung would launch their m51 with the Snapdragon 730g processor. As it was a wonderful midranger processor which was built with 8nm structure.                   In the M51 Samsung has improved their camera performance with new features like single take feature and they have used a new Sony IMX 64mp sensor as their primary sensor and it has a ultra wide ,macro and depth sensors.              This smartphone was packed with a massive 7000 mah battery  and which supports 25 watt
Read more

How to Write a Cheque- a Step by Step Guide to Follow

Image
  How to Write a Cheque- a Step by Step Guide to Follow By Priyanka Juyal August 2, 2021 Cheques are financial instruments that allow users to make transactions securely. These cheques, when not written properly can get dismissed or dishonoured by the bank. Any kind of default or overwriting issue in the cheque can make its processing difficult. Thus, to handle a cheque decently, you must know everything about a cheque- its parts, parties involved and how to write it. What are the Parties involved in Cheque Transactions? There are three parties involved in cheque based transactions- Drawer – A person who issues or writes the cheque Drawee – It is a financial institution that connects drawer and payee Payee – A person or an institution who will receive the amount written on the cheque Read More: 4 Ways to Apply for a Cheque Book Easily What are the Parts of a Cheque? Bank’s information – The cheque carries the name of the bank and its address IFSC – It is a unique 11-digit code, which i
Read more