Manipulating Cells and Cell Content

As you enter data in Excel, you might find that you need to add additional cells to the worksheet to accommodate the information that you need to include in the sheet. You might also find that there are occasions when you want to add long text entries or explanatory text, and want the information to span several cells and to wrap in the cells as text would in a paragraph. The solutions to these various minor issues are easy to come by in Excel.

You can easily insert cells and join cells, if necessary, and then wrap text in a cell or joined cells as needed. In cases where you have entered repeating labels or values into your sheet and find that you need to either change the text entries or change the values, ...

Get Office 2013 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.