As you can see the columns are much more narrow, and are all the same width. The picture below shows what your sheet should look like after following the steps above. Click and drag your mouse to the left, until the columns are about half as wide as they were before.Hover your cursor at the top of the columns, on the line between columns A and B.To shrink the columns in this example to the same width, follow these steps: We will use this click and drag method to shrink these columns, so that each column is the same width. I have put borders on the cells to make their size easier to see. The picture below shows columns in Google Sheets at their default width. Dragging the cursor right will expand the columns, and dragging your cursor left will shrink the columns. Now click and drag your mouse to either expand, or shrink the columns. When your cursor is in the correct place to adjust columns, your cursor will appear as two horizontal arrows. Hover your cursor at the top of the selected columns, on the vertical line separating any two of the selected columns. For reference, the default column width is 100 pixels in Google Sheets.Ĭlick "OK" and the width that you set in pixels will have applied to all of the columns that you had previously selected. When a new menu pops up, enter the new column width by typing a number of pixels. Method 1: Right-click on one of the columns that you selected, and after the menu pops up, click "Resize column…" Step 2: Use either of the methods listed below to make the columns the same width: Step 1: Select the columns that you would like to adjust to the same width To evenly space columns in Google Sheets, do the following: Now let's go over our first example, and while doing so I will give more detail than I did in the basic instructions above. Option 3: While holding the "Ctrl" key on the keyboard, click on each individual columns that you want to select (This will allow you to select non-adjacent columns) Option 2: Click on the top of the first column that you want to select (release click), then while holding the "Shift" key on the keyboard, press the right arrow until you have selected all of the columns that you desire Option 1: Click on the top of the first column that you want to select, and while holding your mouse click, drag your cursor right until every column that you want to select is highlighted, then release your mouse click To select multiple columns before adjusting their width, use any of these methods: There are two ways to quickly make columns the same width in Google Sheets.īoth methods will require you to select multiple columns at once, so just in case you don't know how to do this I will show you right now. How to make columns the same width in Google Sheets If you want to learn how to do this, check out this article: "Automatically resize columns in Google Sheets"īelow, is a more detailed set of instructions on evenly spacing columns, along with several examples. There is also a way to automatically resize multiple columns at once, so that each column fits the longest piece of text in the cells. Then click and drag your cursor left or right Optional shortcut: Hover your cursor at the very top of one of the select columns, over the barrier that separates two of the columns (Cursor will turn into arrows that point left and right).Enter the new column width in pixels (Defaults is 100), then click "OK".Right-click on the top of one of the selected columns, then click "Resize column…".Select the columns that you want to evenly space.To distribute columns evenly in Google Sheets, follow these steps: Have you ever needed to quickly make your columns the same width in a Google spreadsheet? There is a very simple way to evenly space columns in Google Sheets, that will allow you to quickly expand or shrink multiple columns to the same width at one time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |