To get started, you need to open the Excel spreadsheet on your computer and select a row or column you want to cut or copy to another location. You have two options to cut or copy the row and column.

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.

Although you can see only the totals, if you copy them now Excel will include the hidden rows. Press "Ctrl-G" or "F5" on the keyboard to bring up the "Go To" dialog box.

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.

How to insert multiple rows in Excel. 1. Select the row below where you want the new rows to appear. 2. Right-click on the highlighted row, and then click Insert in the context menu. This will ...