In this tutorial we will learn How to center horizontally vertically in Google Sheets.
To center horizontally vertically in Google Sheets,Select the data ,Navigate to Horizontal align in quick access menu and Select “Center” from the drop-down .For vertical alignment Navigate to vertical align in quick access menu and from the drop-down select “Middle”
Let’s go through the above steps in detail.
How to center horizontally vertically in Google Sheets : Step by Step Guide
Enclosed are the steps to center horizontally verticallally in Google Sheets.
Step 1 : Open Google sheet with data
Step 2 : Select the worksheet that you want to align .
Step 3 : Navigate to the quick menu tool bar and Select Horizontal align
Click on the Horizontal align option on the quick access menu .
Step 4 : From the drop-down select “Center” or “Right” as per your requirement.
Your text will be aligned horizontally in center.
Step 5 : Now navigate to the quick access menu tool bar again and Click on Vertical Align
Step 6 : Under vertical align drop-down Select “Middle”
Your worksheet data will be aligned vertically in the Middle.
The above steps were performed in Windows PC with Google Chrome browser .Preceding steps will remain the same if your are going to perform the steps with Google Sheets on Mobile App.
We hope this article on How to center horizontally vertically 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