From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Enhance editing tools

Enhance editing tools

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Enhance editing tools

- [Voiceover] We're looking at a budget worksheet here, Projected Budget 2017. We want to do some editing over in column A. I think it's a good idea if you're about to edit, zoom in on the data you're about to edit. Now there are three major ways to start editing. One is rarely used anymore, but a lot of people will click a cell, suppose it's A8, click it, and they'll go into the formula bar. But if you zoomed in sufficiently, the data's often larger in the actual cell itself, maybe even larger if you zoom in. And so you could start the process, and imagine maybe the active cell is somewhere else, double click in the cell. So I can point into A8 here and double click. If I happen to double click on the right side, it puts the cursor at the end of the text. Now maybe the change I want to make here is involving a word for the left side of the cell. Remember the active cell could be somewhere else. Maybe we want to change the word goods or add something to it. So I'll double click maybe…

Contents