• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

November 7, 2019 By Matt Jacobs

This guide is going to show you how to merge cells in Google Sheets.

  1. Sign into https://drive.google.com and open the file containing the cells you want to merge.
  2. Select the cells to merge.
  3. Click the arrow to the right of the Merge cells button.
  4. Select the way that you wish to merge the cells.
How to merge cells in Google Sheets

The ability to merge cells in Google Sheets is an option that you may be familiar with if you have worked with Microsoft Excel.

While the traditional method for entering data in a spreadsheet involves typing data into cells that are organized into rows and columns of equal size, your layout may require you to combine a couple of cells into one larger cell.

This is common if you are breaking up your spreadsheet into sections, or if you are using Google Sheets to make something like an order form.

Google Sheets gives you the option to merge your cells in a handful of ways, which are:

  • Merge all
  • Merge horizontally
  • Merge vertically

Any merge option that you choose can be undone by selecting the merged cell, clicking the arrow next to Merge cells, then choosing the Unmerge option.

Find out about freezing a row in Google Sheets if you need to keep one of your spreadsheet rows visible at the top of the screen.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Make a Desktop Shortcut for a Google Docs File

Why is the Text Bold on My iPhone 11?

How to Turn Off Javascript in Safari on an iPhone

How to Clear YouTube Search History on an iPhone

how to remove highlight in Google Docs

How to Remove Highlight in Google Docs

How to Update Apps on iPhone 5C

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com