Editing and manipulating data can be tough. Excel can be tough to use if you don't know all of its capabilities. This is a beginner's guide on how to edit data in Excel.
1Copy Text: Sometimes you will come across text that you want to paste into Excel. When you press paste, you get all the formatting and preferences from the source you pasted from. You can choose what you want to paste by going to Edit > Paste Special. A dialog box will pop up with options of what you want to paste into Excel.Ad
2Move Text: Highlight by clicking the cells you want to move. Then grab the outer line, bold black border around cells, and drag it to the cells you want to move that text to.
3Track Changes: You can track changes by selecting Tools > Track Changes > Highlight Changes... If this option is not available, you are in a Read-Only format. Then check the option next to "Track changes while editing. This also shares your workbook". Once this option is selected, then you can make changes and then view the changes by selecting this option again and check the box next to Highlight Changes after specifying the Criteria.Ad
We could really use your help!
- Sometimes while editing, it may be hard to see which column or row you are editing when you have column or row headings. To display the column or row headings as you scroll, you can use the Freeze pane option. To show only the column headings as you scroll, highlight the row directly below the column headings. DO NOT highlight the column headings row. Then select Windows > Freeze Pane. Now when you scroll, the column headings will always show. If you want to show row headings, select the column directly after the row headings and select Windows > Freeze Pane. If you want to show column headings and row headings then select the cell that is directly below the column headings and the row headings and select Windows > Freeze Pane.