Voyage Tech Blogs

Voyage Technology has been serving the Beaver Dam area since 1999, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: How to Resize Excel Rows and Columns

Tip of the Week: How to Resize Excel Rows and Columns

Microsoft Excel can be a great tool to help your business organize data, but the default size of the cell doesn’t leave much room for you to be productive. You can adjust the size of each cell depending on the purpose of the data stored within, starting with the width and the height of each column and row. Let’s go over how you can resize each individual cell.

How to Resize Columns and Rows in Excel

To start resizing your columns and rows, you first should select the cells you want to adjust. We’re going to use the example of resizing all cells in the spreadsheet. To do this, click the space at the top left corner of the spreadsheet. It should be right next to the leftmost column. If you’ve clicked on the right thing, you’ll see a green outline around all of your spreadsheet.

This will give you immediate control over the width and height of all rows and columns by clicking and dragging the borders of them.

How to Get More Specific Measurements

For more specific measurements on your columns and rows, you can adjust them as well. By default, the size of rows is set to 8.43 points and the size of columns is set to 15 points. You can change these measurements by right-clicking the top or left-most part of the column or row and selecting Column Width or Row Height, accordingly. You enter the measurements into the dialog box, then hit OK. The maximum values you can plug in here are 255 points for columns and 409 points for rows.

How to Use the AutoFit Feature

Another option you have is to AutoFit the size of your cells to fit the size of the data found in them. You’ll find this option under the Home tab in the Format section. Click on AutoFit and adjust the settings for row height or column width as needed. Empty cells will simply stay at the default size.

Hopefully you found this tip helpful for your spreadsheet needs. Excel can be finicky if you’re not used to working in it, so even simple tips like these can help you get more out of it. Be sure to keep your eyes peeled on our blog for more great tips for all of your favorite business technology solutions, and contact Voyage Technology for any of your technology needs.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Saturday, 13 September 2025

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Tip of the Week Best Practices Business Computing Data Business Productivity Software Innovation Hackers Cloud Network Security User Tips Efficiency Hardware Internet Malware IT Support Privacy Google Computer Phishing Email Workplace Tips IT Services Collaboration Hosted Solutions Users Workplace Strategy Ransomware Mobile Device Microsoft Quick Tips Small Business Cybersecurity Passwords Backup Saving Money Communication Data Backup Smartphone Managed Service Android Productivity Upgrade Business Management VoIP Smartphones communications Mobile Devices Disaster Recovery Data Recovery Social Media Windows Browser Microsoft Office Managed IT Services AI Current Events Remote Tech Term Network Internet of Things Automation Artificial Intelligence Facebook Cloud Computing Information Covid-19 Holiday Miscellaneous Gadgets Remote Work Training Server Managed Service Provider Outsourced IT Employee/Employer Relationship Compliance Encryption Spam Office Windows 10 IT Support Data Management Business Continuity Government Wi-Fi Business Technology Windows 10 Bandwidth Virtualization Blockchain Vendor Two-factor Authentication Mobile Office Data Security Apps BYOD Mobile Device Management Chrome Gmail Managed Services Voice over Internet Protocol Budget Apple Networking App Employer-Employee Relationship HIPAA Computing Hacker Applications Information Technology Avoiding Downtime Marketing Access Control Office 365 Tip of the week Conferencing WiFi How To BDR Operating System Computers Router Virtual Private Network Risk Management Website Health 2FA Help Desk Analytics Office Tips Augmented Reality Retail Storage Password Healthcare Bring Your Own Device Managed IT Services Big Data Vendor Management Solutions Customer Service Cybercrime Physical Security Display Printer Windows 11 Paperless Office Infrastructure Monitoring Excel Firewall Document Management Remote Workers Telephone The Internet of Things Scam Data loss Social Cooperation Free Resource Project Management Windows 7 Going Green Patch Management Save Money Microsoft 365 Remote Monitoring Vulnerability End of Support Content Filtering Hacking IT Management Presentation VPN Employees YouTube Meetings Integration Cryptocurrency Wireless Technology User Tip Modem Computer Repair Mobile Security Processor Virtual Desktop Holidays LiFi Data storage Data Storage Smart Technology Supply Chain Word Video Conferencing Outlook Machine Learning Managed Services Provider Professional Services Money Saving Time Virtual Machines Humor Managed IT Service Maintenance Safety Antivirus Sports Downloads iPhone Mouse Licensing Vulnerabilities Entertainment Administration Data Privacy Images 101 Telephone System Multi-Factor Authentication Robot Mobility Customer Relationship Management Cost Management Settings Printing Wireless Hosted Solution Assessment Electronic Health Records Permissions Workforce Unified Threat Management Directions Videos Typing Wasting Time Threats Network Congestion Specifications Security Cameras Workplace Strategies Trend Micro User Internet Exlporer Software as a Service Knowledge Fraud Meta Google Drive User Error Microchip Username Managing Costs Amazon 5G Black Friday SSID Point of Sale eCommerce Unified Communications Database Surveillance Experience Virtual Assistant Outsource IT IP Address Google Docs Bitcoin Network Management Running Cable Tech Support IT Technicians Virtual Machine Environment Media Monitors Cyber Monday Medical IT Google Wallet Proxy Server Reviews Cookies Recovery Tactics Development Hotspot Transportation Small Businesses Hard Drives Windows 8 Laptop Websites Mirgation Hypervisor Displays PowerPoint Domains Drones Shopping Nanotechnology Optimization Addiction Electronic Medical Records Language Employer/Employee Relationships Outsourcing SharePoint Refrigeration Management PCI DSS Halloween Chatbots Navigation Writing Distributed Denial of Service Workplace Public Speaking Lenovo Gig Economy Screen Reader Service Level Agreement Internet Service Provider Virtual Reality Computing Infrastructure Teamwork Hiring/Firing Lithium-ion battery Hacks Server Management Regulations Compliance Entrepreneur Scary Stories Private Cloud Identity Evernote Paperless Fun Co-managed IT Superfish Bookmark Identity Theft Smart Tech Memes Deep Learning Download Net Neutrality Twitter Alerts SQL Server Technology Care Undo Financial Data Error History Business Communications Social Engineering Break Fix Scams Browsers Smartwatch Education Connectivity IT Upload Procurement Remote Computing Azure Hybrid Work Mobile Computing Social Network Telework Cyber security Multi-Factor Security Tech Human Resources Search Dark Web Cables CES Tablet IoT Communitications Application Best Practice Trends Supply Chain Management Alert Managed IT Customer Resource management FinTech Buisness File Sharing Regulations Dark Data Google Calendar Term Google Apps How To Microsoft Excel IT Maintenance IBM Legal Data Analysis IT solutions Star Wars IT Assessment Business Growth Gamification Flexibility Notifications Staff Value Business Intelligence Organization Travel Social Networking Legislation Shortcuts Cortana Ransmoware Techology Fileless Malware Digital Security Cameras Google Maps Smart Devices Alt Codes Content Remote Working Wearable Technology Memory Vendors Competition Health IT Downtime Unified Threat Management Motherboard Data Breach Comparison Google Play Be Proactive

Blog Archive