Open an Excel spreadsheet on your computer. Select a row or column you want to copy or cut. Press the Ctrl+Cto copy or Ctrl+X to cut. Select the destination row or column where you want to paste it.

Figure F: Copy the format from a single cell to the entire row. Image: Susan Harkins/TechRepublic ACADEMY: Master Microsoft Excel with these 16 courses in this bundled deal.

After entering a row or column of expressions, you can copy them, and Excel will update the cell references according. Otherwise, you’d have to enter all expressions manually and that would be ...