I have a question about adding rows and inserting copied cells. In Microsoft Excel I could copy a group of cells, then paste them, and it would move the rows below where I want to insert the cells down further. For example, I want to copy cells A80 to S100 and insert them after row 79, and have the original rows 80 to 100 to move down. I would accomplish this by selecting cells A80 to S100, click on “copy”, then click on row 80 to highlight the row, then right click and select “Insert cells and move rows down”. Now I will have an additional 20 rows with the exact formatting that were in the original rows 80 to 100.
So far, the only method that I can see with Only Office is to insert the additional rows one at a time, then go back and insert the formatting into each cell. Is there a way to do this with Only Office? I hope that I am explaining my request correctly.