Merging cells in Google Sheets is a great way to keep your spreadsheet well-organized and easy to understand. The most common use is for headers to identify content across multiple columns, but regardless of the reason, it’s a simple process.
Fire up your browser and head to the Google Sheets home page. Once there, open up a spreadsheet that contains data that needs merging. Highlight the cells you want to merge.
Next, click Format > Merge cells and then choose one of the three options to merge the cells:
- Merge All: Merges all the cells into one cell that spans the entirety of the selection, horizontally and vertically.
- Merge Horizontally: Merges the selected cells into a row of the selected cells.
- Merge Vertically: Merges the selected cells into a column of the selected cells.
Depending on the direction the cells are positioned, you might not be able to merge horizontally/vertically. For our example, because we want to merge four horizontal cells, we can’t merge them vertically.
A prompt will appear if you have data in all the cells you’re trying to merge, notifying you that only the content in the leftmost cell will remain after you merge the cells. The contents of all the other cells are deleted in the process. Click “OK” to proceed.
Read the remaining 11 paragraphs
from How-To Geek https://ift.tt/2O41dFE
No comments:
Post a Comment