Showing posts with label text. Show all posts
Showing posts with label text. Show all posts

Thursday, 25 July 2013

Use Comments for Storing Large Amounts of Text

Excel was built to handle records of data that contain labels, values and formulas. Storing large amounts of text is not its priority meaning your spreadsheets can become long, wide and awkward.

Typically to accommodate bulk text columns such as for descriptions and notes you will make the column wider, apply wrap text to the cells, or a bit of both. These features can help, but another option available to you is to store the text in a comment.

By storing the text in a comment box it is only visible when you want it. By not storing it in a cell your spreadsheet remains easy to navigate and use daily.

.