Merge Table Cells in Google Draw
- You can merge cells in Google Sheets to combine two or more cells into a single larger cell using the Merge tool.
- It's possible to merge cells vertically, horizontally, or in both directions from the Format menu when you're using Google Sheets a web browser.
- When you select two or more cells in the Google Sheets mobile app, the Merge button automatically appears in the toolbar at the bottom of the screen.
- Visit Business Insider's homepage for more stories.
Most spreadsheet apps let you merge cells — to combine two or more cells into one larger cell — and Google Sheets is no exception.
There are many reasons why you might do this, but a common use of merging cells is to create a title that needs to span multiple columns.
You aren't limited to merging cells horizontally, though: You can combine them vertically, or both horizontally and vertically to turn a block of cells into a single entity.
Here's how to do it on your computer or mobile device.
Check out the products mentioned in this article:
iPhone 11 (From $699.99 at Best Buy)
Samsung Galaxy S10 (From $899.99 at Best Buy)
How to merge cells in Google Sheets on desktop
1. Open a spreadsheet in Google Sheets in a web browser.
2. Select two or more cells that you want to merge.
3. Click "Format" in the menu bar.
4. In the drop-down menu, click "Merge," and then click the kind of cell merge you want – Merge Horizontally, Merge Vertically, or Merge All. Depending upon the cells you selected, you may not have all these options.
If you prefer, there's also a Merge button in the toolbar between the Borders and Alignment buttons. It does the same thing, and may be faster than using the menu.
How to merge cells in Google Sheets on mobile
You can also merge cells if you're editing a spreadsheet using the Google Sheets mobile app on your iPhone or Android phone.
1. Open the Google Sheets app and create a new spreadsheet.
2. Tap to select two or more cells that you want to merge.
3. In the toolbar at the bottom of the screen, the Merge button should automatically appear. Tap it. It'll automatically merge all the selected cells.
Related coverage from How To Do Everything: Tech:
-
How to make a bar graph on Google Sheets in 5 simple steps, to make your spreadsheet data more digestible
-
How to set a print area in Google Sheets, so you can print selected cells or sheets
-
How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet
-
'What is Google Authenticator?': How to set up Google's two-step verification software to secure all of your Google apps
-
How to edit Google Docs files offline, for when you're without internet or trying to eliminate online distractions
Dave Johnson
Freelance Writer
Dave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life. Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft. As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Dave is the author of more than two dozen books and has contributed to many sites and publications including CNET, Forbes, PC World, How To Geek, and Insider.
Insider Inc. receives a commission when you buy through our links.
Merge Table Cells in Google Draw
Source: https://www.businessinsider.com/how-to-merge-cells-in-google-sheets