When you apply cell formatting in Microsoft Excel, you quickly standardize how dates and other kinds of data appear in individual cells, workbooks and spreadsheets. After you assign the cell type ...

But cell ranges also might have more complicated borders, mixing solid and broken lines or incorporating several colors. Copy and paste these styles with Excel's Format Painter tool.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop.

J. Carlton Collins, CPA, explains how to paste a bullet list from Word into a single cell in Excel.

Got a problem with an Excel spreadsheet. I have a non-specific data column in an Excel 2007 spreadsheet. The data in one column is zip codes in the form of both zip (5 digit, 00000) and zip+4 (10 ...