How to Make a Box Bigger in Google Sheets

Have you ever found yourself working on a large spreadsheet in Google Sheets and realized that the box you're working in is too small? Maybe you can't see all the data you need to or you're constantly scrolling left and right to view everything. Fear not, my fellow spreadsheet enthusiasts, because I have the solution to make your box bigger in Google Sheets.

Step 1: Select the Cell(s)

The first step is to select the cell or cells that you want to make bigger. You can select a single box by clicking on it, or you can select multiple boxes by dragging your cursor over the cells. If you want to select an entire row or column, simply click on the number or letter corresponding to the row or column.

Step 2: Adjust the Size

Once you've selected the cells, it's time to adjust the size. You can do this in two ways:

  • Method 1: Hover your mouse over the line separating two rows or columns until you see a double arrow. Then, click and drag the line to make the box bigger. This method is great if you only need to make the box slightly bigger.
  • Method 2: If you need to make the box significantly bigger, use this second method. In the top menu, click on "Format" and then on "Row height" or "Column width," depending on the direction you want to adjust. In the pop-up box, enter the size you want the row or column to be and click "OK."

Step 3: Apply Changes

After you've adjusted the size of the cell(s), you need to apply the changes. Simply click on any other cell outside of the selected ones to apply the changes. If you want to cancel the changes, press "Ctrl+Z" (Windows) or "Command+Z" (Mac).

Bonus Tips

Now that you know how to make a box bigger in Google Sheets, let me share some bonus tips to make your experience even better:

  • Zoom in and out: If you're working on a big spreadsheet and need to see everything up close, zoom in by pressing "Ctrl+" (Windows) or "Command+" (Mac). To zoom out, press "Ctrl-" (Windows) or "Command-" (Mac).
  • Freeze panes: If you're working with a lot of data, it can be helpful to freeze certain rows or columns so they stay visible while you scroll through the rest of the sheet. To freeze panes, click on "View" in the top menu, then "Freeze panes," and select the option you want.
  • Auto-fit: If you want Google Sheets to automatically adjust the size of a column or row to fit its contents, simply double-click on the line separating the cells.


There you have it, folks! Now you know how to make a box bigger in Google Sheets. This simple trick can save you time and make your data analysis a lot easier. Don't forget to apply the bonus tips to make the most out of your Google Sheets experience. Happy spreadsheeting!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.