Match The Two Columns Row-By-Row With Comparison Operators If you need to compare two columns in Excel row-by-row instead ... default TRUE or FALSE, you can add an IF function to your formula ...

Freezing Pane keeps rows and columns visible while the rest of the worksheet scrolls (based on the current selection). Freeze Top Row: Keep the top row visible while scrolling through the rest of ...