Resize Columns in MS Excel the Quick Way
I bet you didn't know that you could make MS Excel resize multiple columns in one fell swoop did you? Yes, that's right, you can resize them so that each will accommodate its longest line perfectly.
I am sure that you all know how to fiddle with the width of columns in MS Excel by now. You can go to each column and click your mouse and then drag the column to widen it. But that is the old fashioned way! We are all about saving time and keystrokes right? Darned right we are!
Follow the steps below to learn how to save some time and keystrokes:
- Position your mouse at the right-hand column header. You will know when you are in the right spot when your cursor changes to a left-right arrow.
- Just double-click in that spot and presto! chango! the column is now just large enough for its widest text.
You can perform this feat with multiple columns as well.
- Select a contiguous group of columns by clicking one column header and dragging sideways until they are all selected.
- You can also select a non-contiguous group of columns by clicking one column header and then using your CTRL key while clicking the rest of them.
- Once you have selected your columns, simply double-click the divider at the right-hand edge of any of your selected columns and they will all automatically adjust to the perfect width.
You can always use the Text Wrapping option too, if you prefer.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Infopackets Top Windows 10 FAQs
How to Upgrade from Windows 10 32-bit to 64-bit
How to Fix: Windows 10 Antivirus Missing, Not Compatible
How to Fix: Windows 10 Display Shifted; Screen Fuzzy
How to Upgrade Windows 7, 8 32-bit to Windows 10 64-bit
to Downgrade from Windows 10
- How to Fix: Windows 10 Upgrade Failed Error C1900208
- How to Fix: Windows 10 Upgrade Failed Error 80240020
- Can I Cancel my Windows 10 Reservation and Reserve Later?
- How to Clean Install Windows 10 using Windows 7, 8 License
- Will Windows 10 Install Automatically?
- Windows 10 Upgrade: Do I have to Reinstall Programs?
- Windows 10 Upgrade: Can I choose 32-bit or 64-bit?
- Which Version of Windows 10 Will I Get (Home or Pro)?
- How to Reserve Windows 10 Upgrade (Free)
- How to Fix: CPU Not Compatible with Windows 10 Error
- Windows 10 Upgrade: Can I keep my Old Windows Install?
- How to Cancel Windows 10 Reservation (Properly)
- Download Windows 10 .ISO (DVD) for Clean Install?
- Microsoft: Windows 10 Will Be The Last Version
- Does Windows 10 require the CPU to support PAE?
- Windows 10: Can I Upgrade or do I need a Clean Install?
Click here for more Windows 10 articles.