Bits and Pieces

Did you know that you can choose to format only part of what’s in an MS Excel cell?

Maybe you’ve got some text in a cell and need a couple of words bolded? Maybe a different font style or size is required for just a portion of the cell contents.

Either way, what do you do?

Can it even be done?

The answer you’re looking to hear is yes, right? Well, you’re in luck, because it can be done and it’s easier than you think.

If you simply select a cell and then make formatting changes, they will apply to everything in the cell, so it will take just a bit more than that.

You’ll either need to double click on the cell to get the cursor into the cell contents for editing or you can select the cell and then click into the formula bar for editing.

Once you’ve got a cursor within the cell contents, highlight exactly the portion you need to format.

With your partial contents highlighted, you can make formatting changes as usual. You can use the formatting options on the toolbars or use the Format menu, Format Cells choice (Ctrl + 1). Don’t worry, in this situation, the Format Cells window changes will only apply to the highlighted contents, not the whole cell.

And that’s all there is to it!

The trick is to highlight only the parts to be changed and you will soon be formatting only the “bits and pieces” of your cell contents!

~ April