How to freeze 1st row and 1st column in Excel

Tables in Microsoft Excel could be really big and it’s easy to loose track about information from the first column or the top row. There is simple way how to lock these two parts on screen.

Select cell B2 (it will serve as reference point), click View, click Freeze Panes.

Select Freeze Panes from drop-down menu.

Done 🙂

21. January 2017 at 11:15 - Office automation (Tags: , , ).

  • Where is the fish?

  • Translations

  • Further info

  • Twitter

    Follow @jurajmichalek on twitter.

  • Comments

  • Tags

  • Topics