Learn both methods to decide which approach best suits your needs.
Change Column Widths and Row Heights With the Mouse
Change Individual Column Widths With the Mouse
The steps below cover how to change individual columns widths using the mouse. To widen column A for example:
AutoFit Column Widths Using the Mouse
Another way to narrow or widen columns with the mouse is to let Excel or Google Spreadsheets auto fit the width of the column to the longest item of data contained in the column. For long data, the column will widen, but if the column contains only short items of data, the column will narrow to fit these items.
Example: Change the Width of Column B Using AutoFit
Change All Column Widths in a Worksheet Using the Mouse
To adjust all of the column widths
Change Row Heights With the Mouse
The options and steps to changing row heights in Excel and Google Sheets with the mouse are the same as for changing column widths, except that you place the mouse pointer on the boundary line between two rows in the row header instead of the column header.
Change Column Widths Using Ribbon Options in Excel
Change Column Widths Using the Ribbon Options
Microsoft Excel has a tool on the ribbon that will change the width of a column to any desired size.
Resize Columns and Rows in the Google Sheets Menu
Google Sheets features a right-click menu function to change the column width.
