Year: 2013

Have you ever used the TODAY() or the NOW() function in Excel? They make it super easy to insert the current date and time into your worksheet. So long as you want the value to always be current those functions are great. If you open the worksheet tomorrow, the date or time information will reflect that moment in time. But, what if you wanted to put this moment in time into your worksheet -- and have that date or time be persistent. Or, what if you wanted to insert more of a timestamp than a dynamic date or time value? Here's a hot-key combination that makes that super easy too. Press CTRL+; (that's control and the semicolon) to insert the current date. Press CTRL+SHIFT+; (that's control, shift, and the semicolon)…

Enter Multiple Lines of Text in One Cell [caption id="attachment_84" align="alignnone" width="300"] Entering multiple lines of text in one cell[/caption] Have you ever needed to enter multiple lines of text within a single cell in Excel? But when you press ENTER you wind up in the next cell - which is not what you wanted. In order to get the multiple lines of text in one cell, you need to press the ALT key along with the ENTER key. This ALT+ENTER key combination lets you put multiple lines within a single cell. If you need multiple lines, just repeat the key combination. It can make your data contained within a cell much easier to read. There you go.