In this tutorial, we will learn How to Change Cell Padding in Google Sheets.
- While working with Microsoft Excel it is very easy to change the cell padding in a spreadsheet as it allows you to do. However the same is not true in the case of Google Sheets.
- Google Sheets doesn’t provide any feature to change the cell padding.
In this tutorial, we will provide you with two alternatives that are very close to Cell padding.
Enclosed are the steps on How To Change Cell Padding in Google Sheets :
Change Vertical Cell Padding
- Identify and Select the cells where the Vertical padding needs to be changed.
- Now Click on Vertical Align from the top Menu.
- Change the alignment
- Adjust the height of your rows.
- Now go format menu and change the wrapping.
- Your rows will appear bigger now which is a workaround for adding vertical padding.
Change Horizontal Cell Padding
- Select the cells for which you want to Change the Horizontal Padding
- Now go to Custom number format using the Format Menu.
- Based on your requirement enter the spaces followed by the “@” Sign.
- Horizontal padding will be added to your spreadsheet
How to Change Cell Padding in Google Sheets : Step by Step Guide.
To Change Change Cell Padding in Google Sheets follow the below steps :
Vertical Padding
Step 1: Identify and Select the cells where the Vertical padding needs to be changed.
- Use the keyboard Shortcut CTRL+A if you want to select all the cells in your spreadsheet.
- You can also hover over the mouse cursor to the top left corner of your Google Sheet and click on it which will select the entire sheet.
In the below example we have selected Column A
Step 2: Now Click on Vertical Align from the top Menu.
Step 3: Change the alignment
We have Changed the alignment to Middle
Step 4: Now go format menu and change the wrapping
- Click on Format menu on the main menu bar
- Under the Format Menu drop-down Select Wrapping.
- Under wrapping Select either Overflow or Clip
Step 5: Adjust the height of your rows.
Hover over your mouse cursor to the top-hand side of your sheet where you need to adjust the height and simply drag it down.
This will be the height of your rows.
Step 6: Your rows will appear bigger now which is a workaround for adding vertical padding.
Horizontal Padding
Step 1: Select the cells for which you want to Change the Horizontal Padding.
In the below example we have selected all the cells.
Step 2: Now go to Custom number format using the Format Menu.
- Click on Format Menu
- Now Select Number.
- Under Number Scroll down and Select Custom number format.
Go to Format ->Number ->Custom Number Format
Step 3: Based on your requirement enter the spaces followed by the “@” Sign.
- Type spaces using the space bar depending on your need and then type at the rate sign “@” without quotes.
- Now Click on Apply
For example, to add padding by two spaces we have added two spaces followed by “@”.
Horizontal padding has been added with two spaces as shown below.
Conclusion :
Although there is no perfect solution to add padding in Google Sheets. The above-provided solution will help you to get the work done while working with Google Sheets.
We hope this tutorial on How to Change Cell Padding in Google Sheets.
Related article :
How to recover deleted google sheets (Easy 3 Step Essential Guide)
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets
