![]() ![]() While we talked about clicking on the first column letter, then holding down the Shift key and scrolling to the right and clicking the last column letter to select everything, you could also click and drag to select column letters. More Information on How to Make All Columns Same Width – Google Sheets You also have the option to Fit to data, but that will likely result in differing column widths, as they will adjust based on the size of the largest cell in each column. Note that the default column width is 100 pixels. If you don’t like the size of the columns that you set, you can press Ctrl + Z on your keyboard to undo the resizing, then follow the steps above again to retry. Now that you know how to make all columns the same width in Google Sheets you will be able to better structure your spreadsheets with equally-distributed columns. Step 2: Click and hold on the column letter of the leftmost column to adjust, then drag right to select the rest of them.Īs we discussed above, you could also click on the first column letter, then hold down the Shift key on your keyboard and click on the last column letter that you wish to resize. Step 1: Sign into your Google Drive and open the Sheets file you wish to edit. This article was performed in the desktop version of the Google Chrome Web browser, but you can use other desktop browsers like Firefox, Edge, or Safari instead. How to Set the Column Width for Multiple Columns in Google Sheets (Guide with Pictures) Our guide continues below with more additional information on setting the column width for multiple Google Sheets columns, including pictures of these steps.Ĭheck out our tutorial on how to make a title in Google Sheets if you need to include the name of your worksheet on each page as you print.
0 Comments
Leave a Reply. |