---
title: "Tip of the Week: Resize Rows in Excel"
description: "For this week’s tip we show you how to resize rows in Excel."
url: "https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-resize-rows-in-excel"
date: "2026-07-05T12:59:21+00:00"
language: "en-GB"
---
## Omega Technical Solutions Blog
Omega Technical Solutions has been serving the Haymarket area since 2007, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.
[ Categories ](https://www.omegatechnicalsolutions.com/blog/categories "Categories")
[ Tags ](https://www.omegatechnicalsolutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
# Tip of the Week: Resize Rows in Excel
[Omega Technical Solutions Blog](https://www.omegatechnicalsolutions.com/blog/categories/blog) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/categories/tip-of-the-week)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Friday, 17 March 2023
[ 0 Comments ](https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-resize-rows-in-excel#comments)
[  ](//www.omegatechnicalsolutions.com/images/easyblog_shared/March_2023/03-17-23/excel_computer_woman_413811967_400.jpg "Tip of the Week: Resize Rows in Excel")
Microsoft Excel is an amazing tool that gives you a ton of power over your spreadsheets and the data contained within, but the default size of each cell is a bit… small. You can adjust the size of these cells to suit your needs by adjusting the width and height of each column and row. Better yet, you can easily do it all at the same time without resizing each individual cell. Here’s how it’s done.
## Resizing Columns and Rows in Excel
To get started with resizing your columns and rows, first start by selecting the cells you want to adjust. In this example, we are going to be selecting all of the spreadsheet. You can easily do this by clicking in the space at the top-left corner of the spreadsheet, right next to the leftmost column, with a green triangle in it. If you have done it correctly, you’ll see a green outline around the entirety of your spreadsheet.
Next, you can adjust each row and column by clicking on the borders of one of them and dragging to your liking. It’s that easy.
## More Exact Measurements
Now, if you want a more exact measurement, that’s easy to handle too. The default sizes are 8.43 points for rows and 15 points for columns. To adjust these measurements, all you have to do is right-click on the columns at the top of the page and select **Column Width** or select the rows to select **Row Height**. Enter your measurements into the dialogue box that appears, then select **OK**. For reference, the maximum values you can place in here are 255 points for columns and 409 points for rows.
## Use the AutoFit Feature
One other option you have is to set your spreadsheet to accommodate the size of data within each cell. Under the **Home** tab in the **Format** section, you should see an option for AutoFit. You can AutoFit according to row height or AutoFit according to column width. If the cell is empty, it will remain at its default size.
We hope you found today’s tip helpful. Excel sometimes isn’t the easiest program to use, but you can make it a bit more user-friendly by learning little tidbits on how to use it more effectively. To keep up with more tips and tricks for not just Excel, but all Office suite products, be sure to subscribe to the COMPANYNAME blog.
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
Tags:
[Excel](https://www.omegatechnicalsolutions.com/blog/tags/excel) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/tags/tip-of-the-week) [Microsoft 365](https://www.omegatechnicalsolutions.com/blog/tags/microsoft-365)
[ Getting the Right Phishing Awareness Strategy Can ... ](https://www.omegatechnicalsolutions.com/blog/getting-the-right-phishing-awareness-strategy-can-save-your-business-from-major-headaches)
[ Is It Time to Upgrade Your Sales Capabilities? ](https://www.omegatechnicalsolutions.com/blog/is-it-time-to-upgrade-your-sales-capabilities)
About the author
[  ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Mr. Holmes is responsible for the structure, strategy and execution of Omega Technical Solutions’ team. He also has an extensive background in designing, engineering, and securing Enterprise and Data Center networks.
Author's recent posts
[More posts from author](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ Tuesday, 28 July 2026 Is Your Team Losing Hours to Slow Systems? ](https://www.omegatechnicalsolutions.com/newsletter-content/is-your-team-losing-hours-to-slow-systems)
[ Friday, 24 July 2026 Building a Productive and Protected IT Environment ](https://www.omegatechnicalsolutions.com/newsletter-content/building-a-productive-and-protected-it-environment)
[ Sunday, 19 July 2026 Ditch the Distractions: Effective Time Management for Modern Professionals ](https://www.omegatechnicalsolutions.com/newsletter-content/ditch-the-distractions-effective-time-management-for-modern-professionals)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.omegatechnicalsolutions.com/component/users/login?return=aHR0cHM6Ly93d3cub21lZ2F0ZWNobmljYWxzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXJlc2l6ZS1yb3dzLWluLWV4Y2Vs&Itemid=101)
Sunday, 05 July 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**
## Schema
```json
{
"@context": "https://schema.org",
"@type": "BreadcrumbList",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.omegatechnicalsolutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.omegatechnicalsolutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "Steven Holmes",
"item": "https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes"
},
{
"@type": "ListItem",
"position": 4,
"name": "Tip of the Week: Resize Rows in Excel",
"item": "https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-resize-rows-in-excel"
}
]
}
```