Realigning imported text

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.…

Resume Transcript Auto-Scroll

Author

Released

8/12/2010

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.

Topics include:

Creating charts with keyboard shortcuts

Converting formulas to values by dragging

Repeating Undo and Redo actions

Displaying formulas instantly

Navigating quickly through worksheets and across workbooks

Formatting numeric, and date/time data in a flash with keystroke shortcuts