2 Ways to Resize Sheets Columns

When using different technology tools I always look for the quickest and most efficient way to complete a task. Sometime the “Simplest” features are the ones which pack the most powerful punch. Today I’m going to share how to resize the width of several columns at once. There are two different approaches a teacher or student may take for resizing a sheets column. The following steps may be added to ones “Timesaving Tips Bags of Tricks.”

First Approach for Resizing Columns

I find this approach to be the quickest and easiest to use.

  • Highlight and Drag the columns

Drag columns

Second Approach for Resizing Columns

If you are better with converting size into number this approach is for you.

  • Highlight the Columns
  • Click down arrow or right click
  • Select Reset Columns a to ?
  • Enter cell size number or fit to data

Change cell sizes.gif