chemjas.blogg.se

: (Optional argument) It is a cell reference for which you want the row number. Double click on the ROW Function.Ī dialog box appears where arguments for the ROW function needs to be filled or entered, i.e. Let’s apply the ROW function in cell “B8”, Select the cell “B8” where the ROW function needs to be applied.Ĭlick the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “row” in the search for a function box, ROW function will appear in select a Function box. In the below-mentioned example, For the Cell “B8”, I need to find out the row number of that cell with the help of the ROW function. If you enter =ROW() in any cell in excel, it will return the cell’s row number. You can download this ROW Function Excel Template here – ROW Function Excel Template Example #1 – To Find out the ROW Number of the Current Cell

For one, there is not a Insert -> Copied Cells option after I copy the cells. Now, the problem is, this method does not work in OpenOffice. Once all of this was done, the person would be in all of the sheets, and the formulas would match up for that row. After this, I would change the name of the person in the name field. Now, in excel, if we needed to add a new agent, and keep all the formulas setup, I would just highlight the row I wanted to copy in a week, copy it, then select all the sheets at the bottom, click Insert -> Copied Cells, then shift cells down. We add what an agent did that week to the column in that week, and once done, it totals over to the monthly sheet.

1 sheet is Monthly Totals, and the other 5 sheets are weekly totals. I am using a spreadsheet here at work, that was created in Excel 2003. I'm using the latest version of OpenOffice.