Google Sheets; How to merge cells
Google Sheets easily gets the job done for most of us, be it making school projects or compiling office reports. It feels simpler to use than more traditional alternatives like Microsoft Excel, yet it offersa lot of neat tools for managing your massive sheetsfilled with rows and rows of numbers. One way to handle and better present large amounts of data in your sheets is by merging cells for creating headers or combining entries. The best part is that Google Sheets makes the cell merging feature available across platforms, whether you’re editing on your smartphone or one ofthe top Chromebooksyou use for work.
Here’s everything you need to know about merging cells in Google Sheets.
How to merge cells in Google Sheets for the web
Google Sheets for the web has specific options for choosing how to merge cells. it’s possible to combine cells vertically, horizontally, or a mix of both. It sounds complicated, but it isn’t and takes only a couple of steps.
Only the data in the top or left cell is retained, depending on whether you merge cells vertically or horizontally. Merge only empty cells to avoid data loss or back up the data before merging.
This is what each one of them is used for:
A pop-up warns about potential data loss if your selected cells contain text. SelectOKto proceed. And that’s all you need to do to merge cells in Google Sheets for the web.
You don’t need to merge each column or row individually. Instead, highlight all the cells in a single selection and use theMerge verticallyorMerge horizontallyoption to execute the operation in one go.
How to merge cells in the Google Sheets app for Android
The Google Sheets mobile app lets you merge cells on your phone, but its process differs slightly.
The process on the mobile app is a bit too straightforward because it doesn’t offer additional options as you get on the web.
Since the Merge button on the mobile app does only one operation (it merges all the highlighted cells into one), you must select each column and row individually if you have a bunch of them to merge.
How to unmerge cells in Google Sheets
Unmerging cells requires you to follow the same steps with only the final option changing. Here’s how to unmerge cells.
Unmerge cells in Google Sheets on the web
Unmerge cells using the Android app
Use theMergebutton to unmerge cells. After selecting the cells to unmerge, theMergebutton in the bottom toolbar is automatically highlighted.
Unmerging a cell keeps the text currently in it but doesn’t bring back the data that was there before you merged the cells into one.
Do more with Google Sheets
Google Sheets is a phenomenal tool for crunching numbers while keeping your data safe in the cloud and accessible everywhere. Google’s excellent collaboration tools even let you share your sheets with colleagues or classmates without any fuss. These are the reasons many of us use Google Sheets every day, but we aren’t fully utilizing a lot of its hidden features. There arequite a few handy Google Sheets tips and tricksyou can try when you work on a sheet. Plus, you could make the app more convenient to usewith the help of these useful add-ons.
The note-taking app I should have used all along
Broader branding hints at wider paid-tier ambitions
Free screen and battery repairs inbound
Goodbye, text-only analysis
Navigate through galaxies of customization with Samsung’s One UI Home
$135 is its lowest price in months
