Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Before printing a worksheet or making a presentation using a worksheet it's often better to first consider some alignment techniques that will make the presentation more appealing. It's going to make sense here for example in row 1 and in row 2 to center this data from left to right and one easy feature is simply to highlight the cells. Now the color is added that is your own discretion, but it makes sense to center this title across these cells here and of course Merge & Center. I say "of course" because it is widely known it's great tool for centering. But before doing that what you might also consider doing is selecting not just this data but the row below it.
Let's center both of these from left to right. Merge & Center, and we get a prompt saying that in effect this is going to throw away our second row. So if we click OK here at least throw away the data. What happens? It's gone. We don't want to do that. So it looks as if we got to do this in two steps. Well not really. Highlight this data and then letting go with the left mouse button, and now using the Ctrl key, highlight this data here left to right. Merge & Center to take care of both of those at the same time. Not so well known and probably not as much needed is the fact that you can also center vertically.
So I am inserting a new column to the left of column A here and I want to put in the word Item, or Items. This may not be the best of words, but it will work here and what I am going to do here is merge these cells, Merge & Center, and then change the orientation using the Orientation button in the Alignment group to make this be Rotate Text Up and use this button here to center the data there. Double-click to make that little bit narrow or maybe apply color. So we can do that as well to provide little bit of flair to a worksheet.
Perhaps you know also that this sort of numbers here we can easily change the alignment of these. Now this isn't truly necessary here. Sometimes it might be. But in the Alignment group on the Home tab in the Orientation group we might choose for example Angle counterclockwise. Now it either gives your worksheet a little bit of flair or maybe in some cases it saves you a little bit of space. It's interesting also that if you have applied this alignment, if you accompany it with one of the border features, this one right here for All Borders, most people agree it tends to look a little bit more interesting than it did before.
So before this it looked like this, and now it looks like this. So take your pick. That's easy to get to and on these orientation buttons you might occasionally try some of the other approaches. I haven't met anybody yet who likes this one, but there it is. Another one you might try is Rotate Text Down. I don't see that very often. Or Angle counterclockwise I rarely see this one, but again, you have got your choices that are easy to get to and here and there it makes the worksheet have a little bit more possess perhaps, a little bit of flash to it, easy to get to.
Now with certain kinds of data, for example on this budget sheet here notice the data here in Sales A5 and A6. Now let's hope that whoever put this in didn't type leading spaces. Well, whoever did this did not do that you can look in the Formula bar and see that. So, how do we get this data moved over? It certainly enhances readability, and it would make good sense to do that right here as well. It's not strictly required, but this is going to look better if it's offset a bit to the right and sure enough we have got our Alignment buttons here. There it is. Increase the Indent. Notice the keystroke shortcut Ctrl+Alt+Tab.
You might click that a few times. Want to go leftward? Try it here, and I don't know if you use it for this purpose, but it also can be used to move dollars signs over. You probably wouldn't use it here, but if this column is wider and you simply want to pull in the dollar sign then you can increase the indent this way in stages. I think that's more obscure use of it, but getting back to the idea here, it makes good sense sometimes to offset text data from the headings. It's easier to read and don't waste time putting in leading spaces. So there are quite a few alignment tools built into Excel.
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.