How to Merge and Center in Google Sheet

With the growing trends in documentation and information storage, you probably have desired to have a lot of data organized and stored in a manner that you could probably analyze and compare the information on a single tabular platform. Well, Google sheet helps you to achieve this perfectly well and with great ease. While using the Google sheets you can now merge and center cells by following easy and quick steps shared in this article below.

How to Merge and Center in Google Sheet

How to Merge and Center in Google Sheet

Contents

Organize Your Google Docs

  • It is important to first set your tools safe and ready to avoid data loss in the process of merging cells. You will achieve this by copying and pasting any information you have to another location in the spreadsheet for safety purposes.
  • However, if you happen to forget about copying the data beforehand, you can always retrieve your data by tracking your revision history.

Depending on the number of cells you choose to merge, there are several options to consider:

  • Option to merge all- This involves merging all the cells you have highlighted into one large cell.
  • Option to merge horizontal- This involves merging all the cells you have highlighted on their rows and this will bring about several cells equal to the number of rows that were included in your merge selection.
  • Option to merge vertical- This involves merging all the cells you have highlighted on their columns and this will bring about several cells that equals the number of columns in your merge selection.

Merging the Cells

  • Open the Google sheet spreadsheet. You can access the Google sheet in Google drive from your logged-in Gmail account or the Google drive direct link at https://drive.google.com 
  • Select the cells you prefer to merge as shown below.

    How to Merge and Center in Google Sheet

    How to Merge and Center in Google Sheet

  • Click the ‘Merge’ button available in the toolbar then select the merge option of your preference.

    How to Merge and Center in Google Sheet

    How to Merge and Center in Google Sheet

You can always rectify the cells if you feel what you have isn’t exactly the results you wanted by either clicking ‘Edit’ at the top of the window and select the ‘Undo’ option. Better still, you can click the ‘Merge’ button and tap on the ‘Unmerge’ option.

It should be noted:

  • The three options in Google sheets can be applied to an entire row or column as well. For instance, if you selected ‘column 1’ and ‘column 2’ in your spreadsheet, and followed that by clicking the merge icon and selected the merge horizontally option, sheets would automatically merge across every row in those columns, giving you an entirely new column of individual cells that traversed two columns.

Wrap Up

Getting your data properly managed and organized is an easy step if you take your time to learn how to merge and center in Google sheets. With the merging options onboard, you have a wide space to settle your data in the spreadsheets as creatively as possible as you can be. Go ahead and save your data in an organized and presentable manner.

You may also like...