To copy the same formula to other cells in Excel is easy, and you can use keyboard shortcuts, AutoFill or Copy and Paste command.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

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.