Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets Tip: Increase Row and Column Width

Google Sheets Tip: Increase Row and Column Width

Spreadsheets are great for so many purposes. The default height and width of the cells can be adjusted to allow you to view more (or less) information.

Column Indicators

You can increase or decrease the width of a column or the height of a row in a spreadsheet by placing your mouse in between the column or row indicators. This is the letters across the top or the numbers along the side. Your cursor should change when you are between the column indicators. Clicking and holding down between the column indicators will allow you to drag the column width.

Column Width


Multiple Rows and Columns

You can increase the width and height of multiple spreadsheet rows and columns at once. Highlight the desired rows or columns. Place your mouse pointer between any of the column or row indicators that are highlighted. Resizing one row or column will resize the the selection.
Resizing Rows in Sheets

Skip Select

If you hold down the Control key (Command on a Mac) and click on selected rows or columns they will be selected individually. Resizing one of the selected rows or columns will resize all of the selected rows or columns.
Resizing Selected Columns

Resizing All

You can resize all of the rows or columns by clicking on the “awesome box” in the upper left corner of the grid. Resizing one row or one column will resize all of the rows or columns to the same width or height.

You will find the “awesome box” to the left of the column indicators and above the row indicators.
awesome box

Awesome box demo Google Sheets

Educational Applications

Spreadsheets are great for organizing information, but there are so many other uses. Being able to give yourself more room makes the spreadsheet more attractive and functional. Throw in merging cells and text wrapping and you’re really getting going! (Those are for another blog post).

Here are some suggestions for using spreadsheets with students that require changing the row or column width.

  • Give students room to type a short response.
  • Make the spreadsheet collaborative, each student can submit their answer to one of the cells (boxes).
  • Be able to read student responses from a Google Form.
  • Make room to insert images (use =image(“URL”) ).
  • Increase readability of data.

Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

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