Cara Meningkatkan Ukuran Sel di Google Sheets

This process outlines how to modify the size of cells in Google Sheets by adjusting the dimensions of rows or columns.

If you need more space in your cells either vertically or horizontally you can easily adjust the row height or column width. Google Sheets offers both manual drag options and precise input for resizing.

1. Resizing Columns:

Drag the column border:
Move your mouse to the right edge of the column header (where the letters are). When the double-sided arrow shows up, click and drag to make the column wider.
Right-click and resize:
Right-click on the column letter, select “Resize column”, and then enter the width in pixels. You can also choose “Fit to data” to let Google Sheets adjust it automatically based on the content.

2. Resizing Rows:

Drag the row border:
Hover your cursor over the bottom edge of the row number. When you see the double arrow, drag the border to increase the row height.
Right-click and resize:
Right-click on the row number, choose “Resize row”, and type in your preferred height. You can also select “Fit to data” here if needed.

3. Other Options:

Autosizing:
Double-click the edge of a row or column to auto-resize it to fit the content perfectly.
Resize multiple at once:
You can select multiple rows or columns and drag one of the borders—or right-click and resize—to adjust all of them together.
Use the Format menu:
For more control, go to the “Format” menu where you can fine-tune cell sizing along with other layout options.

Step-by-Step Guide: How to Increase Cell Size in Google Sheets

Step 1

To change the size of a row or column, begin by selecting the specific row number or column letter header. In this example, column D is selected.

Step 2

Next, right-click on the selected row or column header. From the context menu that appears, choose the option to resize either the column or the row, depending on your selection.

Step 3

You can enter a new pixel size if desired. Alternatively, you may choose to automatically fit the data. After making your choice, click on "OK" to apply the changes. The row or column will now be resized accordingly.