Changing Cell Padding in Google Sheets


Cell padding is an option available in excel where one can increase the space between the cell border and content of the cell in order to enhance the readability of the cell content and make it much easy to read and thus understand.

But unlike many other options that are available in both excel and google sheets together. This option of cell padding isn’t available in google spreadsheet. But some alternative options can surely work in a similar way thus giving similar effect as a cell padding option.

And these alternate options are-

Horizontal Padding

  1. Select the cells you want to pad.
  2. To select all the cells, click on top left square in your sheet and then press Ctrl +A.
  3. From the menu bar select Format option and further click on Number.
  4. From further pop-up menu select the customized type of number according to your need.
  5. Now in the space provided, tap spacebar to create as much spacing you want between cell content and border and then type @ sign. For example, if you want space area equals to 3 spaces then type –‘ @’.
  6. After this, click on Apply button.

Vertical Padding

  1. Select the cells you want to pad.
  2. To select all the cells, click on top left square in your sheet and then press Ctrl+A.
  3. From the menu bar, select first vertical align and then select middle.
  4. Click on format option from menu bar and then select text wrapping.
  5. Further from the pop-up menu, select either Overflow or Clip.
  6. Now, drag the rows in order to change or increase their height.
  7. Now you will be able to see that while your text remains at the centre, the size of all your rows will be increased according to your convenience.
Vertical Step 5

Thus, both the above methods are make shift ways of accessing cell padding effects in a google spreadsheet that you must try.

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

Recent Content