by Alexander Trifuntov, updated on
Google Sheets lets you manage rows in many different ways: move, hide and unhide, change their height, and merge multiple rows into one. A special styling tool will also make your table easy to understand and work with.
Headers are a mandatory part of any table – it's where you give names to its content. That is why the first row (or even a few lines) is usually turned into a header row where each cell hints about what you will find in the column below.
To distinguish such a row from others right away, you may want to change its font, borders, or a background color.
To do that, use the Format option in the Google menu or the standard utilities from the Google Sheets toolbar:
Another useful tool that helps format tables and their headers is Table Styles. After you install it, go to Extensions > Table Styles > Start:
Mainly, the styles differ in their color schemes. However, you can format different parts of the table in different ways, whether it's a header row, left or right column, or other parts. This way you will personalize your tables and highlight the most important data.
The main advantage of Table Styles lies in the ability to create your own styling templates. Just click on the rectangle with a plus icon (the first in the list of all styles) to start creating your own style. A new template will be created, and you'll be able to adjust it to your liking.
Note. The default styles that exist in the add-on cannot be edited. The tool lets you add, edit, and delete your own styles only.
Choose the part of the table that you want to change, set its appearance, and click Save:
All these options make Table Styles a great tool that formats entire tables and their separate elements, including Google Sheets header row.
Tip. Learn other ways to format your Google Sheets table from this blog post.
It may happen that you will need to rearrange your table by moving one or more rows to another place. There are a few ways to do that:
All tables may contain lines with the data that is used for calculations but is unnecessary for displaying. You can easily hide such rows in Google Sheets without losing the data.
Right-click the line you'd like to hide and choose Hide row from the context menu.
Row numbers don't change, however, two triangles prompt that there is a hidden line. Click on those arrows to reveal the row back.
Tip. Want to hide rows based on their contents? This blog post is for you then :)
You can not only move, delete, or hide rows in your Google Sheets – you can merge them to make your data look more elegant.
Note. If you merge all rows, only the contents of the top leftmost cell will be saved. Other data will be lost.
There are a few cells in my table that have the same information (A3:A6) one under another. I highlight them and choose Format > Merge cells > Merge vertically:
4 cells from 4 rows are joined, and since I decided to Merge vertically, the data from the top cell is displayed. If I choose to Merge all, the contents of the top leftmost cell will remain:
There's one interesting case in Google Sheets – when you need to combine not only rows but entire tables. For example, weekly sales reports could be joined into one monthly report and furthermore into a quarter or even yearly report. Convenient, isn't it?
The Merge Sheets add-on for Google Sheets lets you combine 2 tables by matching the data in key columns and updating other records.
You can improve the layout of your table by changing the height of some lines, a header row in particular. Here are a couple of easy ways to do that:
At last, our table is created, the information is entered, all rows and columns are right where they should be and of the needed size.
Let's count how many lines are completely filled with data. Perhaps, we'll find that some cells were forgotten and left empty.
I'll use the COUNTA function – it calculates the number of non-empty cells in the selected range. I want to see how many rows there are with the data in columns A, B, and D:
Tip. To include additional rows that may be added in time to your formula, make sure to use the entire column as the formula's argument rather than a definite range.
As you can see, formulas return different results. Why is that?
Column A has vertically merged cells, all rows in column B are filled with data, and only one cell in column C misses the entry. That is how you can localize empty cells in the rows of your table.
I hope this article will make your work with rows in Google Sheets a bit easier and more pleasant. Feel free to ask questions in the comments section down below.
Table of contents