You may just want to highlight the cells in question and then right click on the 'Status' bar (right below the 'Sheet1, Sheet2, Sheet3). When you look on the right half, you'll see the results of your selection. You may choose to see any of the following choices: 'Average', 'Count', Count Nums'...
Dreamboat is absolutely correct. You'll want to remember to click outside the left edge of the table to highlight one or more rows and then right click and then click 'Insert Rows'. Of course, you can always use 'Tables' and then click 'Insert' and then click 'Rows Below' or 'Rows Above'.
From the Help section of Excel:
Switch rows of cells to columns or columns to rows
Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.
1. Select the cells that you want to switch.
2. Click 'Edit' and then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.