The total number of characters that a cell can contain is 32,767. That’s a lot and it can therefore sometimes be tricky to read or edit text. Although you can use the up or down arrows at the end of the formula bar to cycle through the content, line by line, it might be easier to expand the formula bar to display the entire content of the cell. (With thanks to Sonia Woodend for the inspiration for this week’s tip.)
Here’s how:
1. Click the chevron button at the end of the formula bar. The button looks like a v but if you cannot spot it or prefer keyboard shortcuts press CTRL+SHIFT+U.
OR
2. Hover over the formula box until the pointer changes to a vertical double arrow and then double-click the vertical double arrow (or drag it to where you want it).
This will make it easier to format part of the cell (see tip 141) or enter line breaks. (Remember ALT + ENTER?)
PS I'm committed to sharing the best of what I know with others so please don't keep these tips a secret. If you enjoyed today's tip, please forward it to anyone you feel may benefit or reprint it (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.
10 September 2013
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at http://www.roem.co.uk
Please note: The Learning Collaboration and Cambridge Network members have the opportunity to book places on our courses at a reduced rate.
_________________________________________