This function is especially useful in large workbooks with many different sets of data.Some quick tricks for you to select and highlight the row differences in Excel.
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.
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.