To separate first and last names using delimiters: Excel will split the first and last names into two columns. You can also use this to separate first, middle, and last names. Another easy way to ...

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 ...