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.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Monday, 29 May 2023
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Blog Archive