21. January 2017

How to freeze 1st row and 1st column in Google Docs Spreadsheet

Freezing 1st column and top row in Google Docs Spreadsheet is little bit different than in Excel or Calc.

Click View, select Freeze from menu, click 1 row.

Click View, select Freeze, click 1 column.

Done 🙂

21. January 2017

How to freeze 1st row and 1st column in LibreOffice Calc 5

I was wondering how to freeze 1st row and 1st column in Calc. The solution is quite simple. Here is how to freeze cells in Calc for Linux.

Select cell B2 (it will serve as reference point), click Window (documentation often refer to View menu, which was not my case), click Freeze.

Done 🙂

21. January 2017

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 🙂

  • Where is the fish?

  • Translations

  • Further info

  • Twitter

    Follow @jurajmichalek on twitter.

  • Comments

  • Tags

  • Topics