How to Edit and Delete Cells in Excel, Excel for Financial analysis

This is the third post in the series, Excel for Finance Professionals. In this post, we will see how to edit individual cells in excel.

First, we will see how to edit/delete individual cells.

To insert an individual cell, press Ctrl+Shift+Plus keys.

editanddeletecells

 

editanddeletecells

Please note that even though this shortcut can be useful at times, one should avoid using it because it changes the cell alignment in excel. Instead, one should keep the practice of adding entire rows or columns instead of individual cells.

To edit a particular cell, press F2 key. If the cell contains more than one word, then you can use the combination of Ctrl+Arrow keys to skip the words in the cell.

For example, if there are two words “Pune City” in a cell and if you press Ctrl+Left arrow key near the word “City”, then the control skips the word “City” and goes to the previous word i.e. “Pune”.

- While editing a cell, Ctrl+Shift+Arrow keys highlight the word in the cell.

editanddeletecells

- We can add a new line in a cell by using Alt+Enter.

editanddeletecells

 

- To delete the contents of a cell, just go to the cell and press Del key.

 

Note: NEVER use backspace key for deleting as it creates unnecessary white spaces and distortions.

Suggested: Read more about excel for finance

However, you can use the backspace key to delete individual text but not entire cell.

Another way to delete the cell contents is simply pressing F2 key to get the cell in editable mode and then delete whatever is required.

 

So these were the shortcuts to edit/delete cells.

 

Now try solving the sample exercise using the keys mentioned above.

 

How to Edit and Delete Cells in Excel, Excel for Financial analysis

Now try this:

1. Create an excel sheet with some data, go to any particular row, go to any cell in that row and try modifying data in that cell. For example, in the first row, modify the Product Quantity to 20 instead of 10.

2. Go to the Customer name in the excel sheet, delete one Industry and enter some new industry name there.

 

How to Edit and Delete Cells in Excel, Excel for Financial analysis 1
How to Edit and Delete Cells in Excel, Excel for Financial analysis 2
Next Classroom Batches in India
- Classroom Course with Placement Assistance: Our Full-Time Financial Modeling Investment Banking Course (6 Weeks) starts on 16 September, 2019 and 2.5 Months Weekend Workshop starts on 27 September in New Delhi, India and on 16 September, 2019 in Gurgaon, India.

- Online Course with Placement Assistance: Join our Online Financial Modeling Investment Banking course with Placement Assistance from anywhere in the world.

- CFA Level - I: 16th November, 2019

- Big Data: 29th June, 2019

- Financial Modeling Investment Banking Weekend in Gurgaon: 27 September, 2019

- See Testimonials.

Only a few seats remain. Interested candidates can contact me.

Leave a Comment