How to modify or resize all rows or columns at the same time?

To resizing rows and columns individually will be time-consuming, you can modify the height and width of every row and column at the same time. This method will make your all columns, rows, and cells will be the same size.

Locate and click the Select All button just below the formula bar

Position the mouse over a row line so the white cross changed to double arrow.
Click, hold, and drag the mouse to increase or decrease the row height or columns width
Release the mouse when you are satisfied with the new row height or Columns width for the worksheet. 

No comments:

Post a comment