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.
If you copy information from an external source, for example an Internet site or from a Word file, many times when you paste it into Excel, particularly if it's a numerical data, it often comes in in the form of a table or comes in neatly structured in the columns and rows. But text information sometimes comes in in one cell. Now let's imagine that the particular item that we see here in cell B17, which is quite long, maybe is to accompany some data above it or some data we are about to put in here. But in this current form, we can't read it all and it would be better if we could somehow restructure.
There is a way to do this, and we want to experiment with it a little bit. Let's imagine this long entry here. We would like to have it essentially rewrap and fit into space maybe only this wide, and what we can't fit here have it appeared below in separate rows. So, select the data in question, and on the Home tab, in the extreme right group called Editing, there is a Fill button. Click the drop arrow and choose Justify, and this is the typical message we get. Text will extend below the selected range.
Now if there is data right below this, you want to be a little bit careful with this. Of course, we will be able to undo, if that's an issue, but it might overlap or take away some of that data. Let's click OK here and watch what happens. So we rewrapped the text in question. Now maybe that isn't quite what we wanted. Well, we could either undo or just take this data here and say well, what I really want to do here maybe is make Column B wider and make it fit right here. In other words, take this data and extend it down here somewhere. So it doesn't make a difference what you highlight really. What if we were to just take this information here, and now by not highlighting columns into the right, let's restructure this agai? Using that same command, in the Editing group on the Home tab, Fill > Justify, and we see the data this way.
So you want to experiment with it a little bit. If the data does look like this and you say why I'd rather have it in just a few rows, explore the option of making columns wider first or just saying in effect no, I would like to restructure this data and make it fit into this space. How about right there? Fill > Justify, and we see what's happening. So it's worth experimenting with. Certainly saves us a ton of time instead of copying and then editing and pasting and all that sort of thing, this is going to get the job done pretty fast.
Fill > Justify, in the Editing group on the Home tab.
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.