If you are just starting to use LibreOffice, then it will probably be difficult for you to intuitively implement it. Yes, by default the keyboard shortcut for this action is not assigned, but you can do it yourself.
#Openoffice calc freeze row how to
Therefore, another question may arise: how to do it faster? Correct answer: assign hotkeys. Obviously, this can be done in two steps: first, unpin the existing range, and second, lock the desired range.
Sometimes we need to change the docked area, this may be due to the fact that we did not select it correctly or we now need another docked area. Where our cursor will be at this time does not matter, the entire fixed range of both rows and columns will be released.
#Openoffice calc freeze row windows
Unpinning a locked range is also easy - uncheck the Lock box in the Windows menu. But sometimes there is a situation when several rows (columns) are allocated for the table header, and we only need one for work, what should we do in this case? Just hide all unnecessary parts of the title. 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 lines, both in LibreOffice Calc and in MS Excel, is always to fix the entire area (rows and columns) above and to the left of the selected cell. The result will be the committed first line. Select cell A2 and go to the main menu "Window" and check the box in the item "Fix". Naturally, the table can go to the 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 pinning the table headers. I will talk about the basic principles to move around the sheet as quickly as possible, and you yourself decide what to adopt 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 navigate the sheet in the spreadsheet, the less time we spend editing it, which means we have more time to analyze its contents. The main thing then is not to forget that there is also column A, removed from the screen in this way. We go to cell C1 and achieve the desired result. Scroll with the horizontal scroll bar until the first column B is on the screen: Sometimes a problem arises: to fix, for example, the second column, but so that the first one is not visible. To cancel the commit, uncheck the menu item Window -> Freeze. For example, to simultaneously fix the first row and the first column, you need to become in cell B2: To do this, it is important to stand in the cell next to the row and column that you want to fix and mark Fix. In a similar way, you can freeze a column, or even both a column and a row. The title now remains in place when scrolling through the table. To complete this task, we stand in cell A2 and select Window -> Freeze Objective: to fix the title (highlighted in blue in the screenshot) so that when the table is scrolled down, it stays in place and the content scrolls. OpenOffice: Calc for Beginners home / LaptopsĪt the request of readers, I publish material on how to fix the headings of the table so that they do not scroll when viewing, but only the content of the table changes.
0 kommentar(er)
