You can find this by clicking on the Function icon, which is just to the left of the Sum icon. Now all we need to do is put some data in there.įor this purpose I am going to introduce a couple of functions that produce random numbers. Repeat on Sheet 2, only call it February. A common use for something like this is financial data where each month is on its own sheet, so rename this sheet to “January” and click OK. A window opens that lets you type in a new name. Place your cursor over the tab where it now says “Sheet 1”, and select Rename Sheet…. So begin by renaming your sheets with descriptive names. If you only have one sheet in your spreadsheet, you needn’t worry about this, but if you had several sheets you might want to use data from all them in combination, and then it really matters. And the thing we want to mention here is that the sheet name is implicitly part of the cell address, and can be explicitly addressed.
You can leave your sheet named as Sheet 1 and so on, but it is often better to rename each sheet with something more descriptive like I did in my model example. A CSV file would be a very good choice here, such as if you wanted to bring in data from a database or another spreadsheet for use in the current spreadsheet. look at what I did when I created the simple model for “What-If” analysis.) And if I need to add a sheet, I can just go to Insert–>Sheet to bring up a window to specify where the sheet should go, what it should be named, or even insert a sheet from a file. I never bother with this though, because I will always name my sheets for what they are doing in a given spreadsheet (e.g. I could make it something else, like “Tab 1”, “Tab 2”. Instead of each sheet being “Sheet 1″, Sheet 2”, etc. I can also change the default naming of new sheets here. On my copy of Calc I changed it to 1, because most of the time I never need more than one sheet for my work. While the default as it comes is three (similar to Microsoft Excel) you can change it. On this screen you can decide how many sheets you want to have on a new document. But these defaults can be changed by going to Tools–>Options–>LibreOffice Calc–>Defaults. They will be called Sheet 1, Sheet 2, and Sheet 3 at this point. But in fact the address can be larger because we never discussed sheets.īy default, when you create a new Calc spreadsheet you will have three sheets in it, which you see as tabs along the bottom of the screen. As we saw previously, each cell has an address, which is marked by the column (letters) and the row (numbers), always in that order. LibreOffice Calc, like all spreadsheets, contains a large number of cells in various rows, columns, and sheets, and navigating that can get a little tricky.
0 kommentar(er)
