To select multiple sheets in a spreadsheet one at a time, hold down the Control key, and then click the sheet name tabs at the lower edge of the workspace.Clicking on a selected sheet tab while pressing the Control key will deselect that tab only.To select a contiguous range (or group) of sheets, hold down the Shift key, and then click the name tab of the sheet at either end of the grouping. You can start selecting multiple individual cells just by holding down Control. In OOo 2.0 you no longer need to highlight a selection of cells before you can select an individual cell as you did in OOo 1.1.x. Learn about the Name box from Help → Index → formula bar sheet area names.To select multiple cells in different areas of a sheet, hold down the Control key and click, or click and drag on the cells or areas of cells with the mouse. Click File at the top of the Calc window, followed by. After you execute the macro on sheets 2, 3, 4, … you will have all the data on the main sheet and all the others will have been deleted. Launch OpenOffice Calc and open the Excel sheet you want to transfer to the OpenOffice format. It may be helpful to bind your macro to a keyboard shortcut. The macro recorder is unable to record the Yes response to 'Are you sure you want to permanently delete the current sheet?' but you can just press the space bar to indicate Yes. This moves the data on the current sheet to beneath the data on the main (first) sheet, deletes the now empty sheet, then positions Calc on the following sheet, so one can just execute the macro again. Shift+Command+End (Mac) / Shift+Ctrl+End (Other)Įnter σ.A1 in the Name Box, where σ represents the name of the main sheet You can see which file formats are supported and what you can do with it if you follow. /Calc Contents What is CalcEdit Spreadsheets, sheets and cellsEdit Understanding functionsEdit Understanding the structure of functionsEdit.

Recorded macros have many limitations, but I think one can help here. With either app, you get access to Writer, Calc, Impress, Draw, and Math. Fatgreta wrote:Is it possible to combine all the data on multiple sheets within a single spreadsheet into one sheet, so I'd end up with the data showing as if I'd copied / pasted all the cells from each subsequent sheets below the cells currently in the main sheet? Writing a macro is hard, but recording one is easy.

Openoffice sheets