how to freeze the top row in openoffice excel

#How to freeze the top row in openoffice excel how to

You can also just scroll through the list and see what is assigned to what, and choose what you like best.

If the combination is free, then there will be an empty space opposite it. Highlight any item in the 'Keyboard Combinations' list and press the desired combination on the keyboard (for example, Ctrl+Shift+X). ' and in the window that opens, go to the 'Keyboard' tab. We pass in the main menu 'Tools' → 'Settings. If you have just started using LibreOffice, then it will probably be difficult for you to intuitively do this. Yes, by default there is no keyboard shortcut assigned for this action, but you can do it yourself.

#How to freeze the top row in openoffice excel how to

Therefore, another question may arise: how to make it faster? Correct answer: assign hotkeys. Obviously this can be done in two steps: first, unpin the existing range, second, pin the required range. Sometimes we need to change the pinned area, this may be due to the fact that we did not select it correctly or we now need a different pinned area. Where our cursor will be at this time is not important, the entire fixed range of both rows and columns will be released. But sometimes there is a situation when several rows (columns) are allocated for the table header, and we need only one for work, what should we do in this case? Just hide all unnecessary parts of the header.ĭetaching a fixed range is also easy - uncheck 'Fix' in the 'Windows' menu. I'll tell you a secret, the program doesn't care how many rows and columns will be fixed. That is, if we need to fix only the first column, then we must put the cursor in cell B1, and if we need to fix the first row and column, then in cell B2. The basic principle of fixing rows, both in LibreOffice Calc and in MS Excel, is that the entire area (rows and columns) above and to the left of the selected cell will always be fixed. The result will be the committed first row. Select cell A2 and go to the main menu 'Window' and check the box in the 'Fix' item. Naturally, the table can go right and down, so it is desirable to be able to fix both rows and columns. The first thing that comes to mind when working with large tables in LibreOffice Calc or MS Excel is fixing table headers. I will talk about the basic principles of moving around the sheet as quickly as possible, and you yourself decide what to take into service and what not. And each person creates his own workspace based on his habits and ideas. Of course, convenience is a very relative thing. The more convenient it is for us to move around the sheet in the spreadsheet, the less time we spend editing it, which means we have more time to analyze its contents.