How to Change Cell Padding in Google Sheets (Easy 2022)

Written by Abid Akon

Here's what we'll cover:

Cell padding means adjustment of cell size and width. In Google Sheets, there are no inbuilt features and tools to aid cell padding but there are two alternative methods to changing cell paddings on your worksheet. 

Cell paddings increase concise reading flow and clarity of words. In this tutorial, we are going to learn how to Change Cell Padding in Google Sheets.

There are two known types of padding. These are Vertical padding and Horizontal padding.

How to Change Vertical Padding In Google Sheets

The vertical padding adjusts the width of the cells in each column, vertically. This is done by using the text wrapping feature in Google Sheets

In the sample worksheet below, we have a list of items and the sales made off each item monthly. To make the vertical padding uniform, we adjust all cells in the worksheet by following the stated steps below.

Step 1: Highlight all the cells in the worksheet by clicking on the gray box at the top left of the worksheet or using the keyboard shortcut Ctrl key + A. By doing so, all changes and formats applied are made throughout the worksheet.

1 How to Change Cell Padding in Google Sheets
2 How to Change Cell Padding in Google Sheets

Step 2: On the far right of the toolbar, multiple icons serve as shortcuts t0 other significant tools in Google Sheets. Search and click on Vertical Alignment.

3 How to Change Cell Padding in Google Sheets

Step 3: The three icons are displayed. Each icon represents the type of alignment which are Up Alignment, Middle Alignment and Down Alignment.

4 How to Change Cell Padding in Google Sheets

Step 4: Click on Middle Alignment. All texts in the cells are shifted to the middle of the cells.

5 How to Change Cell Padding in Google Sheets

Step 5: Click on Format on the toolbar.

6 How to Change Cell Padding in Google Sheets

Step 6: From the drop-down menu, select Text Wrapping.

7 How to Change Cell Padding in Google Sheets

Step 7: Select either Overflow or Clip wrapping styles. Do not select Wrap because It reduces the column size to fit in accordance with the content of the cell.

8 How to Change Cell Padding in Google Sheets

Step 8: Now you can adjust the height of the cell by dragging the line below the row number. To increase the cell height, you drag the line lower and to decrease the cell height, you drag the line higher above the original height.

9 How to Change Cell Padding in Google Sheets

We’ve successfully changed the vertical padding easily.

How To Change the Horizontal Padding In Google Sheets

Using the worksheet used above, we want to adjust the length of the rows.

 Step 1: Highlight all the cells in the worksheet by clicking on the gray box at the top left of the worksheet or using the keyboard shortcut Ctrl key + A. By doing so, all changes and formats applied are made throughout the worksheet.

10 How to Change Cell Padding in Google Sheets
11 How to Change Cell Padding in Google Sheets

Step 2: Select the Format tool on the toolbar.

12 How to Change Cell Padding in Google Sheets

Step 3: From the drop-down list, select Number.

13 How to Change Cell Padding in Google Sheets

Step 4: Select Custom Number Format.

14 How to Change Cell Padding in Google Sheets

Step 5: A different tab is opened. In the empty text bar at the top, enter some spaces with the at (@) sign. For instance, we’ve added five spaces and a “@”  in the text bar.

15 How to Change Cell Padding in Google Sheets

Step 6: Click Apply. The horizontal padding is applied to the worksheet.

16 How to Change Cell Padding in Google Sheets

Final Thoughts

Now you know How to Change Cell Padding in Google Sheets. Unlike Google Sheets, there is no tool for this so we’ve improvised and developed workarounds to overcome this problem. 

If you know of other methods, do let us know. Thanks for reading. I hope you found this guide informative.

Abid Akon

Abid Akon

I am a tech content writer. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I am writing articles to share my tech knowledge with you.

Related Articles

MD Abid Akon

Abid Akon

Hi, I am Abid. I really love to talk about different Modern Technology. It is very important that people know how to fix their tech related problem. That’s why I’ve created this website to share my technology keeping knowledge with you. Welcome to ”abidakon.com”

Abid Akon

My Personal Favorites
YouTube Channel