Google Sheets (Google Sheets) is as powerful as Excel, allowing you to analyze huge data sets, but only if you know how to read the data correctly. If the data is not formatted properly, you may find it difficult to see the results you are looking for.
One way to make the data easier to read is to adjust the size of the spreadsheet cells. You can increase the size of cells in Google Sheets by adjusting the row height or column width. This can be useful if you have large amounts of data in a cell, or if you want to add additional formatting, such as multiple lines of text.
If you want to know how to make cells bigger in Google Sheets, follow the steps below.
How to adjust the size of cells in Google Sheets with the mouse
If you want more data to fit in a cell or to make the data in a cell easier to read, you probably need to increase the size. The best way to do this is to adjust the size of the cells with the mouse.
You can do this by dragging the borders of rows or columns to increase the size of those cells.
To adjust the size of cells in Google Sheets with the mouse:
- Open the Google Sheets spreadsheet you want to edit.
- Hover your mouse over the border of the column or row you want to enlarge. The mouse cursor will change to a double-headed arrow.
- Click and drag the border to increase the size of the cell. The size of the cells in that row or column will increase as you drag the border.
- Release the mouse button to finish resizing the cell.
- Repeat these steps for any other cells you want to make larger.
How to set an exact size for cells in Google Sheets
If you need to set the exact size of a cell in Google Sheets, the method above is probably not the best one. There is no simple indicator to identify the size of a row or column while resizing it with the mouse.
Instead, you can access the Resize Rows or Columns menu by following the steps below.
To resize cells in Google Sheets using the Resize menu:
- Open your Google Sheets spreadsheet.
- Right-click the row or column that contains the cells you want to resize.
- From the drop down menu, select resize this column either resize this row.
- In the frame resize, type a new value in the box (in pixels).
- To return to the default size, type 21 for rows or 120 for columns.
- Press okay to confirm.
At this point, your cells will change in size. You may need to repeat the steps for the matching row or column to ensure consistency. For example, if you resize a column, you might want to resize the matching rows to ensure that the cell (or cells) you want to resize are the same size.
Formatting cells in Google Sheets
By following the steps above, you can easily increase the size of cells in Google Sheets. This can be especially useful if you have a lot of data in a cell and want to make it easier to read.