You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

If you need to add a comma after the first word in each cell in Excel using the Replicate or Substitute function, read through this article.

Even if you've never created a merged cell in a business spreadsheet, you may receive a spreadsheet that has one. Excel allows you to combine multiple cells into a single cell by clicking a button ...

End Function Then, show the user how to call the function from conditional formatting as follows (in Excel 2007 and 2010): Select the range where you want to identify formula cells.