Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.
For most proficient Excel users adjusting column widths doesn't even involve using commands. Usually it's just a simple double-click or a drag. Column D isn't wide enough. We see the telltale pound signs there, so we're adjusting only that. We'd simply double-click the boundary between columns D and E right there. Easy and fast. You can certainly drag, but double- click is better because it automatically adjusts this to handle the widest entry in the column. Sometimes we've got a worksheet like this one here and who knows how this happened, but let's say as I press Ctrl+Z to go back a little bit.
You know suppose some of these are too narrow as we see some of them obviously are. Column B is also. Some of these might be too wide. And furthermore, we might even have some hidden columns. Let's hide a column to bring this issue into play as well. Sometimes you get a workbook from other sources. You happened to look at a certain worksheet. You might have hidden columns. You've got column widths that are all out of whack. Let's quickly adjust all of them at once by clicking in the upper-left corner and then double-clicking a column boundary between letters. It doesn't make any difference which one we choose.
This will automatically readjust all columns, and in the process reveal any hidden columns. Double-click. And keep in mind that some worksheets that have many, many columns it gets a bit laborious to go out and check every single alphabetical letter out there and to the double digits and so on to be looking for hidden columns. Bring them all back at the same time and in the process make every column be exactly the width you need to see all the information that's in it. And similarly you might do this with rows, but perhaps for a different rationale here and there.
Sometimes you are about to print a worksheet, maybe this one, maybe this is going to be more readable. If we have more vertical space here, you might click in the upper left-hand corner and simply point to one of the row boundaries. It doesn't make any different which one. Click and drag. And maybe make it about twice as tall, and it stimulates to look of double-spacing them. It might be just what we need. On the other hand if you had received this data you might want to say, "well, I want to readjust all these quickly at once. I don't need this look at all." Click in the upper-left corner and what you are going to do? Double-click one of those boundaries, double-click, and we are back to so-called normal display.
So you can easily throughout the entire worksheet adjust column widths and/or row heights as necessary.
Find answers to the most frequently asked questions about Excel 2010 Power Shortcuts.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.