In other words, you place your cursor in the first cell which is still to scroll left/right and up/down, then use that option. This option means that all the rows toward the top and colums toward the left of the current cursor location will get frozen. In the View menu, there is an option named Freeze Rows and Columns. Now a day, I use Calc a lot more as I'm spending 99% of my time on Linux and OpenOffice runs on that system. Very practical to keep the labels visible in long tables. Now when you scroll your data, these top rows and left columns don't move. Then select the menu option that applies to your case. To freeze more rows and/or columns, place your cursor in the A1 cell, then select the number of rows and the number of columns you want to freeze. If you just need one row and/or column, place your cursor in the A1 cell (the very first top-left cell). You have three selections:įreeze the selected top rows and left columns In the Windows menu (Before Office 2007) and in the View menu (Since Office 2007) you will find an option named Freeze Panes. I have seen that being done many times, but did not know how to do it myself. The first column will represent the name of the employee and the second column is how many guests the employee will bring.I have been wondering how to lock a few rows and/or columns at the top-left in Excel. To make things easy if the person enters "0" that means they are not bringing a guest (the employee, however, IS required to come) and if they enter "1" that means they are which means that employee equals two attendees. We'll do a simple spreadsheet that deals with how many persons each employee will bring to a company picnic. The first example will illustrate a basic IF/ELSE statement that uses only two columns of data. Let's start out with a more simple example and move on to a more complex example.
IF entry A is greater than B THEN C is X ELSE C is Y.īut how does one do this? It's actually quite easy. That third columns' entry will depend upon the information in the first two. Let's say you have two columns of numbers and you want to add a third column based on the other two data. For instance, did you know that Calc can do If/Else statements? In this spreadsheet tutorial you will learn how to use IF/ELSE statements in OpenOffice Calc. Openoffice Calc holds a lot more bang for the users' buck than you might think. Most people know the ins and outs of spreadsheets, but many don't realize just how powerful spreadsheets can be. And when I work in spreadsheets I work in OpenOffice.
0 kommentar(er)
