Learn how to use the Freeze Panes feature in Excel to freeze rows or columns in Excel so that no matter where you go in a spreadsheet certain data remains visible.
Use the ‘Paste Special Transpose’ option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.
Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet.
Normally, we hide or unhide rows and columns by using the Hide or Unhide features from the right-clicking menu. Besides this method, we can hide or unhide rows or columns easily with plus or minus sign in Excel.
I don’t know how “cool” it is, but the most useful thing I have come across at some point in the past was the way to reference the last value on a row or on a column.
it depends on the Excel version you are using.