• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Google Sheets: Set Cells to Same Size

Google Sheets: Set Cells to Same Size

Posted on December 5, 2019 by Mel Hawthorne Leave a Comment

Using Google Sheets to keep track of your data is great – there are a lot of styling and formatting tools available to make things easier. One such formatting tool is the ability to control the width and height of cells in batches. Here’s how to do it.

First, select the range of cells you want to transform. To do this, click on the letter or number at the beginning of each column or row to select it. You can select multiple rows or columns, but not both at the same time. Press Ctrl and click on all the rows and columns you want to select at one time.

Then right-click on one of them and select the option resize selected rows/columns.

Resizing options

A new window will pop up and present you with two options – you can either have it fit to the data entered, or you can set a specific width or height. Click Ok and your cells will change!

Tip: If you only want to change one row or column instead of multiples, you can drag the edges of it to do so – if you want to set a specific pixel-width or height though, you should still use the method above!

You Might Also Like

  • Google Sheets: Protect Cells
    Google Sheets: Protect Cells
  • Google Sheets: Remove Formatting From Cells
    Google Sheets: Remove Formatting From Cells
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not Working
    Troubleshooting Google Sheets Not Working
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know! Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Recent Posts

  • How to Set Up a Recurring Meeting in Teams
  • Fix: Microsoft Teams Keeps Freezing My Computer
  • Are you having problems with the Galaxy S21 Wi-Fi? Here’s how you can fix it
  • How to Migrate Skype For Business Users To Teams
  • How to Get the Most out of Google Files App
  • Fix Microsoft Teams Channel Email Not Working
  • Microsoft Teams: Cannot Create New Folder in Files
  • Fix: Microsoft Teams Guests Can’t Chat

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

Follow me on Twitter, or visit my personal blog.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2021 Technipages · All Rights Reserved · Privacy