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

Blog Archive