How to Make Google Sheets Cells Fit Text

Google Sheets app provides various options and features for a beautiful format and you can also make Google sheets cells fit the text.

Yes, you read that right! You can actually make the cells in the Google sheets app fit your text. This not only makes your sheet look organized but it is also a good practice to edit and format Google Sheets on the app. This is not a very easy technique if not learned properly. So, let's begin our article by learning how we can make cells in the Google sheets app fit the text in just 4 easy steps.

How to Auto Size Cells to Fit in Google Sheets

Make Google Sheets Cells Fit Text in 4 Steps

Step-1 Open Google Sheets: in the first step you have to open the Google Sheets app if you are using your mobile phone.

In this article, we are going to use Google sheets on a desktop/PC. So, to open Google sheets on your PC you have to do the following:

• Open your web browser.
• Type the link of the Google sheets spreadsheet that you want to open. You can also open a new spreadsheet by going to 'Google Sheets'.
• Then, click on the search button in your spreadsheet will open up.

Step-2 Click Between the Columns: After entering your data in the spreadsheet, it will look somewhat like the picture below.

In this step, you have to click on the area in between the two columns. This is basically done in order to resize the column as per your text.

Step-3 Double Click Here As Shown: The area between two columns with getting highlighted in blue color as you can already see in the picture below. All you have to do with double click on this blue area.

Step-4 Your Text is Fitted to Cell: When you double click on the Blue area in the previous step, your text which is written in the cells of that column will automatically fit the size of the cell. It is very simple and fast!

FAQ

How Can I Make Google Sheets Cells Expand to fit The Text Automatically?

In order to make the Google sheets cells expand so as to fit the respective text, you have to consider doing the following in the same sequence:

• First, you have to select the column or columns that you want to expand in order to fit the text.
• Then, just right-click on any of the selected columns.
• The 'Resize' option will appear. Click the 'Resize Columns' option now.
• After that, in the 'Resize Column' dialog box that opens, you have to find and then click on the 'Fit to Data' option.
• Finally, click on 'OK'.

Is It Possible To Shrink Columns to fit The Text in Google Sheets?

Now you have how to expand the columns to autofit the text. But, a very obvious question arises is it possible to shrink the columns in the same way?

Right now, the answer to this question is a big no. For now, there are no methods for automatically resizing the font size for fitting the cell width in Google Spreadsheets.

We are working hard to look for alternatives that can be helpful in this situation. Hang in there, and we will come up with a solution soon.

Can I Also AutoFit in The Google Docs Application?

Just like the Google Sheets app, you can also use the autofit feature in the Google docs applications for various word documents and text files. You can also save Google sheets as pdf to open them in Google docs.

You can read the process to achieve this in the steps below:

• Firstly, you have to open the presentation in the Google Slides app or your browser.
• Then, you can go to the Format tab and then click on the 'Format' options.
• In the sidebar, you will find the 'Text fitting' option. Click on that.
• Then, simply right-click on a text placeholder or a box.
• A menu will appear on the right side.
• From the menu, click on 'Text fitting'.
• The text will now fit automatically.

Another Method

Making the Google Sheets cells fit the text is a very easy 5 step process.

In many cases, the text in a cell of a Google Sheet is too long and doesn't fit in. You can shrink or enlarge the row height or column width to make the text fit. But there is an easier way. In this article, we will show you how to make Google Sheets cells fit the text.

Make Google Sheets Cells Fit Text: 5 Steps

Step 1 - Open the Google Sheets App: Before we go into specifics on how you can make the cell fit text in google sheets, we need to have the application of google sheets installed on our device.

• Look for the green-colored icon in the shape of an A4 size paper. It has white outlined cells over it.
• Assuming you can't track down it, go to the play store, and look for 'google sheets'.
• You can now proceed to install the application from the play store.

Step 2 - Tap on B present in the gray box: Moving on to the next step, right-click on the column (or row) you want to resize because the cell is overflowing with data. The column will grey out. You can see the snapshot of google sheets given below for reference.

Step 3 - Click on the 3 dot option: After you right-click the column (or row), you can see some options come up. Tap on the 3 Dots which will open a drop-down menu; the 3 dots button in the spreadsheet tab is used to access settings.

• Settings include toggling features such as comments, sorting, column widths, etc.
• You can hide the particular column so that it becomes easy to operate the sheet without getting burdened with the enormity of the sheet.

Step 4 - Click on resize column: Moving onto the next step quickly, we can see two options in the menu. "Hide column", Resize Column". Click on the "Resize Column" to change the size of the column selected so as to fit the text perfectly inside the boundary of the cell.

Step 5 - Click on fit to data to make google sheets cells fit text: After you tap on "Resize Column", You can see two options. Firstly either you can change the number of pixels from 21.

• 21 Pixels is the default setting in google sheets. Or you can also select "Fit to data".
• This will automatically resize the column according to the text in the cell without doing it manually.
• Selecting fit to text is more efficient and time-saving.

Conclusion

In many cases, the text in a cell of a Google Sheet is too long and doesn't fit in the cell. You can shrink or enlarge the row height or column width to make the text fit. But there is an easier way.

Certainly, the resize column feature is a great way to fix a messy spreadsheet. For example, we can use this feature to resize the width of the columns, so that our data is arranged in an orderly fashion. In conclusion, this helps to beautify the spreadsheet and makes it easier for us to work on it.