Editing Data

After entering the data in every cell of the worksheet and you might want to edit or adjust to make it more visible and display the way you want, you can do that anytime in Excel.

In this article you will learn how to edit data, from copying, moving, wrap text and AutoFit the column width and Row height.

Copy Text

To copy text or any number in Excel, select the cell/cells that you want to copy and right click on the selected cell, then select “Copy” or you can make a keyboard shortcut “CTRL+C” and select the cell when you want it to copy, then perform CTRL+V to paste the copied text. All the formattings and formulas in the cell are also copied.

Copy Text

Moving Text

Highlight the cells to select which one you want to move, then position your mouse pointer into the edge of the selected cells to turn the pointer into four-headed arrow and drag the selected cells where you want it to be. You can also use a keyboard shortcut, CTRL+X and CTRL+V.

Move Text - Editing Data

Wrap Text

You can use wrap text formatting in any cell if you want the width of the column to be fixed. To apply wrap text, select the cell/cells that you want to format, then on the “Home” tab in the “Alignment” group, select “Wrap Text”

Wrap Text - Editing Data

Adjust the Column Width and Row Height

To adjust the column width, position your mouse pointer on the column heading between the 2 column to make the pointer 2 headed arrow, then click and drag to resize the width, do the same in the row. See the screenshot.

Adjust Column Width and Row Height

If you find it difficult to adjust the width and height of the cell you can format it to AutoFit. While the cell/cells are selected, on the “Home” tab, in the “Cells” group, select “Format”, on the drop down menu select “AutoFit Row Height” and “AutoFit Column Width”

AutoFit Cell Width and Height

Track Changes

You can setup your Workbook to track your every changes when you edit, to setup, on the “Review” tab in “Changes” group click “Track Changes” and on the drop down menu select “Highlight Changes”

Track Changes - Editing Data

On the popup menu, check the “Track changes while editing. This also shares your workbook” then click OK. Save your workbook again to start tracking every change that you make.

Track Changes

Leave a Reply

Your email address will not be published. Required fields are marked *