Blog Archives

Excel – How to split a column in 2 or 3

Do you have a column containing a full name, like this:-

Before

….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. Here’s how:- Read the rest of this entry

Excel columns and rows too small?

The default cell doesn’t allow much room for typing text, does it?

Excel pic about cell width 2

To extend a column’s width, move the mouse pointer over one of the small divider lines that separate the alphabetic headers at the top of the sheet.

When the pointer changes to a double-headed arrow (as you can see in the picture above), press the left mouse button and keep it down whilst you drag the column out until it is wide enough.

The same procedure applies for adjusting row height (ideal if you want to use a larger font) as you place the mouse between the rows and drag.

Bonus Tip – You can automatically size Column A to fit the text inside by simply double-clicking on the border whilst you see the double-headed arrow.

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂