John -- great tips! Any tips on making it easier to copy formulas between ranges that are transposed? (IE Twenty rows of data have a total at the right of each row, on another page you have to title of each row presented horizontally and want to reference the sum for each title...I know I can reference the first rows total and copy that formula down twenty rows, then copy the column and use transpose to create the row of totals, but is there a faster way? Thanks!
How would I change the color of the 'cursor' if you like. The outline of a cell when selected ... NOT the cell itself or the grid. It is currently a green outline or 'cursor' and I was wondering if could change it back to black like in older versions of excel? I realize you can change the grid line colors and thickness but can you change the 'cursor' (don't know how else to describe it ... not sure if I'm being clear)? I just updated to the newest version of excel and it's a lot different than older versions.