Google Sheets merge cells shortcut mac

google sheetskeyboard shortcuts

Is there a keyboard shortcut to merge cells in Google Sheets? I've looked and can't find it.
F4 doesn't repeat merging cells either. I'm on OSX, Apple keyboard.

Anyone been able to do this with a shortcut? I have to merge an ungodly amount of cells and would prefer to not have to use the drop down menus to do it.

Best Answer

There doesn't seem to be a native shortcut, but you can use Alt+O, M, and then Enter to select "Merge All" quickly from the dropdown menu.

Related Solutions

Google-sheets – Keyboard shortcut to open a drop-down list for cell values in Google Docs spreadsheets

The new version of Google Sheets makes it very simple: hit the Enter key while you're in the cell. Boom. Dropdown list.

Google-docs – How to create custom keyboard shortcuts in Google Docs

nhinkle gives the germ of the answer.

Automatic Corrections

Automatic corrections for → and ← are included as defaults. You just need to add your own for ↑ and ↓. (Maybe |^ and |v?)

While editing a document,

1. Select Preferences from the Tools drop-down menu.
2. Either deselect the checkbox next to the word for which you'd like to disable text substitution, or press the "x" to the right of the word to delete the row.

This wikiHow teaches you how to combine merge more than one cell into a single cell in Google Sheets.

Steps

1. 1

   Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, sign in now.

2. 2

   Click the file with the cells you want to merge.

3. 

   3

   Select the cells you want to merge. To select multiple cells, click the first in the range, then drag the mouse cursor to select the rest.

4. 4

   Click the Merge icon. It’s in the icon bar above the spreadsheet and looks like two arrows pointing inward in the center of a dashed square.

5. 5

   Select a merging option to merge selected cells.

   • Select Merge all to merge all selected cells across both columns and rows.
   • Select Merge vertically to merge cells across columns without affecting rows.
   • Select Merge horizontally to merge cells along rows without affecting columns.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

About this article

Article SummaryX

1. Go to https://sheets.google.com.
2. Click the file.
3. Select cells to merge.
4. Click the merge icon.
5. Select Merge all, Merge vertically, or Merge horizontally.

Did this summary help you?

Thanks to all authors for creating a page that has been read 334 times.

Is this article up to date?

Watch Video – How  to Merge Cells In Google Sheets

In some cases, you would have a need to merge some cells and combine these together to make one single cell. These could be either merging cells in rows or columns (or both).

One practical example of this is when you have a header that has is the same for multiple columns and you need to merge the cells to make the header look like one (as shown below).

In this tutorial, I will show you how to merge cells in Google Sheets (horizontally as well as vertically).

I will also cover some additional things you need to take care of when using Google Sheets to merge cells.

So let’s get started!

• How to Merge Cells In Google Sheets
• Different Types of Merge Option in Google Sheets
  • Merge All
  • Merge Horizontally
  • Merge Vertically
• Issues When Learning How to Merge in Google Sheets
  • Can’t Sort Columns with Merged Cells
  • Copies merged cells and not the value
• How to Merge Cells In Google Sheets FAQ
  • How Do You Merge Cells In Google Sheets for iOS and Android?
  • How Do I Merge Cells Into One Row?
  • Why Can’t I Merge Cells on Google Sheets?
  • Is There a Way to Merge Cells In Google Sheets Without Losing Data?

How to Merge Cells In Google Sheets

Suppose you have the dataset as shown below and you want to merge ṭhe header row that has the text “Store #”.

Below are the steps to merge these cells:

1. Select the cells that you want to merge
2. Click the Format option in the menu
3. Click on Merge cells option
4. In the options that appear, click on ‘Merge horizontally’

The above steps would merge the three cells and make them one.

Another way to access the merge options is thorough the toolbar. When you click on the ‘Merge cells’ icon, it will merge all the cells. And if you click on the drop-down icon next to it. it will show other options such as merge horizontally or vertically

Important Note: When you merge cells that already have some content in the cell, the final merge cell will only retain the content of the top-left most cell. The rest of the content will be lost. Thankfully, when this situation comes Google Sheets will warn you with a prompt (as shown below) and only merge the cells when you click on OK.

Different Types of Merge Option in Google Sheets

If you followed the steps above, you would have already noticed that there are the following types of merge options:

• Merge all
• Merge horizontally
• Merge vertically

Let me quickly explain each of these options.

Merge All

When you use the ‘Merge all’ option, it will merge all the cells and you will get the result which is one big merged cell (as shown below).

Note that this option only becomes available when you have selected a contiguous range of cells. If you select a non-contiguous range of cells, you would notice that this option is grayed out.

Merge Horizontally

When you select more than one row and use this option, cells in each row would be merged (as shown below).

In case you have only selected the cells in one row, then Merge all and Merge horizontally would do the same thing.

Merge Vertically

When you select more than one column and use this option, cells in each column would be merged (as shown below):

In case you have only selected one column, then ‘Merge vertically’ and ‘Merge all’ would do the same thing.

Issues When Learning How to Merge in Google Sheets

While using merged cells, there are a few things you need to know.

Can’t Sort Columns with Merged Cells

The first issue with merge cells is ṭhat you can not sort a column that has merged cells.

If you try and do that, it will give you an error as shown below.

Copies merged cells and not the value

If you have three cells merged together with some text in it and you copy and paste this somewhere else in the worksheet, the result would be merged cells (with the same text and formatting).

In case you only want to copy and paste the content of the merged cells and not get the result which itself are merged cells, you need to copy and then paste as value.

So there are few issues you need to keep in mind when working with merged cells in Google Sheets.

And in case you need to unmerge cells, you can easily do that. Simply select the cells that are merged, go to the Format –> Merged cells and then click on Unmerge.

How to Merge Cells In Google Sheets FAQ

How Do You Merge Cells In Google Sheets for iOS and Android?

There are two easy steps to merge cells on your mobile device in Google Sheets:

1. Select the cells you wish to merge. Some phones will let you tap and drag, on others, you just have to move the little circle on the corner of the blue box to cover all the cells
   
2. Click on the Merge Cells shortcut
   

How Do I Merge Cells Into One Row?

You just have to use the merge horizontally option from the menu. If you’re unsure what that is, we covered it above in the main text of this article.

Why Can’t I Merge Cells on Google Sheets?

If you can’t use any of the above-mentioned methods to merge cells, your spreadsheet might be locked. We have an article about locked cells that will help explain what that means and how to fix it.

Is There a Way to Merge Cells In Google Sheets Without Losing Data?

Unfortunately, there’s no native way to merge data from multiple cells in Google Sheets. Buy, you can use an add-on like this Merge Cells that will allow you to do it. To use it:

1. Follow the link above
2. Install the add-on
3. Highlight the cells you want to merge
4. Navigate to Extensions>add-ons>Merge Cells
5. Select how you want your data to combine from the available options
   

That’s all there is to know about how to merge cells in Google Sheets.

I hope you found this tutorial useful!

Other Google Sheets tutorials you may find useful:

• How to Split Cell in Google Sheets (into separate columns)
• How to Combine Cells in Google Sheets (using simple Formulas)
• How to Group Rows & Columns In Google Sheets
• How to Separate First and Last Name in Google Sheets
• How to Compare Two Columns in Google Sheets
• How To Make Text Vertical In Google Sheets (Rotate Text)

Is there a shortcut to merge cells in Google Sheets on Mac?

What is the shortcut to merge cells on a Mac?

Is there a keyboard shortcut to merge cells in sheets?

What is the F4 key on Mac for Google Sheets?