Google Sheets provides handy tools for managing your spreadsheet's appearance and organization. This guide will show you how to hide and merge cells and rows, complete with screenshots and examples.
Hiding Cells and Rows
Hiding data can be useful for decluttering your sheet or focusing on specific information without deleting anything.
1. Hiding Rows:
- Select the row(s) you want to hide by clicking on the row number(s).
- Right-clickon the selected row number(s).
- Choose "Hide row" from the context menu.
Opens in a new window
www.oksheets.comGoogle Sheet with rightclick menu on row number showing Hide row option
- To unhide rows, click the gray arrows that appear where the row(s) were hidden.
Opens in a new window
www.simplesheets.coGoogle Sheet with gray arrows indicating hidden rows
2. Hiding Columns:
- Select the column(s) you want to hide by clicking on the column letter(s).
- Right-click on the selected column letter(s).
- Choose "Hide column" from the context menu.
Opens in a new window
rows.comGoogle Sheet with rightclick menu on column letter showing Hide column option
- To unhide columns, click the gray arrows that appear where the column(s) were hidden.
Opens in a new window
www.tillerhq.comGoogle Sheet with gray arrows indicating hidden columns
Merging Cells
Merging cells combines multiple cells into a single cell, which can be useful for creating headers or labels that span multiple columns.
1. Select the cells you want to merge.
- Click the "Format" menu.
- Hover over "Merge cells"and choose from the following options:
- Merge all: Combines all selected cells into one.
- Merge horizontally: Merges cells within the same row.
- Merge vertically: Merges cells within the same column.
Opens in a new window
unito.ioGoogle Sheets Format menu with Merge cells options highlighted
Example:
Opens in a new window
www.owox.com
Google Sheet showing a table with Monthly Expenses merged across multiple columns as a header
In this example, merging cells creates a clear header for the expense tracker.
Important Notes:
- When merging cells, only the upper-leftmost cell's value is retained. Any other values in the merged cells will be deleted.
- To unmerge cells, select the merged cell, go to "Format" > "Merge cells" and select "Unmerge".
By mastering these techniques, you can effectively organize and present your data in Google Sheets. Remember to experiment and explore other features to unlock the full potential of this powerful tool.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article