
Effortless Excel Resizing with Keys: Learn to Modify Row Heights & Column Widths Quickly

Effortless Excel Resizing with Keys: Learn to Modify Row Heights & Column Widths Quickly
Setting the row height and column width in Excel is easy, but if you’d rather use the keyboard to do this, it’s not very intuitive. We’ll show you a couple of different ways to set the row height and column width without using your mouse.
Related: How to Set Row Height and Column Width in Excel
To begin, use the arrow keys on your keyboard to move the cell selection to the row or column you want to change, then press the Alt key to go into shortcut key mode. Press “H” to access the Home tab.
Shortcut keys display for all the commands on the Home menu. Press “O” to open the Format menu in the Cells section.
To change the row height for the row corresponding to the selected cell, press “H” for Row Height.
Enter a value on the Row height dialog box and press Enter.
Changing the column width is similar to changing the row height. Press Alt, then H, then O (one key after the other, like we mentioned above) and then press “W” for Column Width.
Enter a value on the Column Width dialog box and press Enter.
We changed the height for row 2 to 20 and the width for column B to 15, as shown below.
Another option for changing the row height is to press Shift+Spacebar to select the entire row containing the selected cell. Then, press Shift+F10 to bring up the context menu and press “R” to open the Row Height dialog box. Enter a new row height on the dialog box and press Enter.
You can do the same thing with the Column Width, except you would press Ctrl+Spacebar to select the entire column and then press “W” to open the Column Width dialog box.
If you like using the keyboard rather than the mouse, a lot of the commands on the ribbon have shortcut keys assigned to them. You can display those shortcut keys in the Screentips so you can easily learn what they are and start using them.
Also read:
- [New] Adding Tag to YouTube Video? Better Read This First
- [Updated] Redefining the Sony S3700 Video Experience
- 1. Top Hidden Evernote Functionalities Boosting Productivity
- 2024 Approved Vlog Like a Pro Best Video Editing Software for Popular Platforms
- ASUS ExpertBook P5: Revolutionary Ultrabook with Cutting-Edge Energy Saving and Expandable Memory Up to 32GB
- Clearing Windows Updates Cache: A Comprehensive Tutorial for WINDOWS 11 & 10 Users
- Complete Guide: Using FaceTime on Your PC via Windows
- Complete Tutorial: How to Permanently Delete Items From the Windows Eboard History
- Comprehensive Solutions for Dealing with Xbox Series X/S Headset Failures
- Discover the Ultimate Selection: 3D Animation Software for Free in 2
- Easy Steps to Restore Accidentally Deleted Outlook PST Files Instantly
- Expert Insights on the Enhanced Features of Ring Video Doorbell Pro+
- In 2024, How to Fix Pokemon Go Route Not Working On Vivo V29e? | Dr.fone
- No Cash, Only Computers Recording YouTube Video Playback for Screenshots
- Upcoming Windows 11 April 2024 Enhancements: What to Expect From the Next Major Update
- Why Your Personal Touch Is Missing on Your Windows PC: Reclaiming Ownership
- Wireless PS5 DualSense Integration with Windows 11: A Step-by-Step Guide
- Title: Effortless Excel Resizing with Keys: Learn to Modify Row Heights & Column Widths Quickly
- Author: Mark
- Created at : 2024-10-29 07:53:48
- Updated at : 2024-11-05 09:35:55
- Link: https://win-solutions.techidaily.com/effortless-excel-resizing-with-keys-learn-to-modify-row-heights-and-column-widths-quickly/
- License: This work is licensed under CC BY-NC-SA 4.0.