From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Try these editing tips and keystroke shortcuts to use with long formulas

Try these editing tips and keystroke shortcuts to use with long formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Try these editing tips and keystroke shortcuts to use with long formulas

“

- [Instructor] If you double click 2 cell A15 in this worksheet, 3 you're seeing a really long, really wide formula here, 4 and there are techniques for working 5 with this more efficiently. 6 A not so obvious shortcut here, 7 and in a certain sense, not really a shortcut, 8 but something that's going to clarify this is the ability 9 to introduce line breaks in a function. 10 And I'm going to press Escape here too, to point out the idea 11 that although you can edit a cell in the formula bar, 12 and I think most people recognize 13 that's certainly common and easy to get to, 14 the text isn't very large though, 15 I know that's a relative term. 16 But if you zoom in on a worksheet, 17 perhaps holding down Control, rolling the mouse wheel 18 or Control Alt Plus, then double click a cell. 19 Now in this case, notice that 20 because I've zoomed in more, 21 we've got some line breaks in here, 22 we can see this much…

Contents