In this tutorial we will learn How To Center Text In Google Sheets.
How To center text in Google Sheets(Overview of Steps )
- Select the Cell or range that you need to bring at the center.
- Click on the Horizontal align option on the Quick access tool bar
- From the Horizontal align drop-down Select Cebter align
- The Selected text will be aligned to the center as shown below.
Let’s go through the above steps indetail
How To Center Text In Google Sheets : Step by Step Guide
Enclosed are the steps to center text in Google Sheets :
Step 1 : Open Google Sheet.
Step 2 : Select the cell or range that you need to bring at the center.
Any value that you select in a cell or a range will be aligned to center irrespective of the data type for example dates,numbers ,plain text etc.
Step 3 : Click on the Horizontal align option on the Quick access tool bar
Step 4 : From the Horizontal align drop-down Select Cebter align
Step 5 : The Selected text will be aligned to the center as shown below.
Similarly you can center any other text which you want to align it to the center,
How do I center text vertically in Google Sheets?
To center text vertically in Google Sheets,Choose the cell with the content which you want to vertically align .Now Click on the Vertical align button at the quick access toolbar and choose top ,middle or bottom from the drop-down as per your requirement.
How do I move text to next cell in sheets?
To move text to the next cell in Google Sheets follow the below steps :
1.Select the cell with text in googl sheets
2.Now go to the quick access toolbar and click on Text wrapping .
3. From Text wrapping drop-down Select wrap
You Selected text will be shown in two lines and the row height will be adjusted by google sheets automatically.
How To Center Text In Google Sheets(Summary)
We hope this tutorial on How To Center Text In Google Sheets was useful.
Related articles :
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets
How to Count Cells based on Color in Google Sheets