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

One thought on “2 Ways to Resize Sheets Columns

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.