Tag Archives for " format cell "

7 Creating a custom timeline in Excel

Recently, a fellow reader, Jessica from Miami, asked if I would help her figure out a way to create an event timeline in a format her boss is partial to:

Example of a timeline created in Microsoft Excel

She tried to find templates online, but nothing really seemed geared to a legal context.

I tried solving this problem in Word, but no real luck.  So, since Jessica was pretty comfortable with Excel, I developed a template for her there.

Changing the orientation of text within cells (vertical, horizontal, or diagonal, as in the example above) is actually pretty easy. Here, I'll show you:

Keep reading →

58 How to put multiple lines into cells in Microsoft Excel

If you use Microsoft Excel to organize data (say, a timeline or a list of documents being produced), you may have run into the problem of having more text than will fit into a normal cell.  You need to either wrap text like a paragraph or insert line breaks in the middle of the Excel cell, because otherwise the text just breaks out of the borders of the cell and keeps on going:

Text in an Excel cell not wrapped

And if that's not annoying enough, if you have to type something into the cell to the right, then you've just cut off the last part of that other cell:

Text in an Excel cell that's not wrapped and is cut off

What you want to be able to do is either (a) have the information in the first cell wrap text in Excel like a paragraph so it appears on multiple lines within that cell or (b) insert a line break like you would in a word processor.  


Here's how you do each:

Keep reading →