When you want to split your heading over more than one line
but within the same cell, you may be familiar with the Wrap Text button on the ribbon. However there is a quicker method that can be implemented as you are typing: ALT Enter.
Using the example below, type Stock then press ALT ENTER to
move your cursor into the next line, then type MVMT and press ALT ENTER to move
down again and then type Boxes. Press
ENTER when you are done.
You can even edit a cell afterwards to add a line break if necessary, you'd just have to press ALT ENTER at the appropriate spot in the formula bar (or in the cell itself if you're in edit mode).
Please share this using one of the buttons below if you think others will find this useful, or leave me a comment if there is something else you'd like to learn about.
No comments:
Post a Comment