In both Calc and Excel, the fill handle can be used to copy contents of a cell down or to the right. The menu path is: Edit > Fill > Down (or Up, Right, or Left). Also, in Calc, it is possible to fill up and to the left.

In Calc, the same features are available, but only through a menu path, not through keyboard shortcuts. There is also a menu path that accomplishes the same task as the keyboard shortcuts. In Excel, it is possible to copy and paste a cell to a range of cells below or to the right of the target cell by selecting a range, with the source cell at the top (when filling down) or at the left (when filling to the right) then use the keyboard shortcut Ctrl+D (to fill down) or Ctrl+R (to fill to the right). You can bypass the dialog and instantly delete the items checked by default by pressing the Backspace key rather than the Delete key.įilling down or to the right Using the Fill Down (or Fill Right) feature Thus, pressing Delete and then Enter will delete the items checked by default. The items checked by default are: Strings Numbers Date & Time Formulas and Comments. In Calc, pressing Delete calls up a dialog box where you can specify what to delete: In Excel, pressing the Delete key instantly deletes the contents of the cell. =INDEX((A2:A3 C2:C3) 1 1 2) returns the first cell of the second range in the range list. =SUM((A1,A3)) is the same, but with one parameter being a range list.Ĭalc only allows range lists in the INDEX function. =SUM(A1,A3) is the sum of two cells (function has 2 parameters). Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input fieldĮdit cell comment (known as “notes” in Calc)Īlt+Shift+Enter (also applies the cell format)Įxcel allows all parameters to be range lists. Keyboard shortcuts Selected Excel and Calc default keyboard shortcuts In Calc, to leave the source cell or range intact while dragging and dropping (in other words, to create a copy of the source cell or range), first drag in the normal way, then just before dropping, press and hold the Ctrl key, then release the mouse button.Then the cell can be dragged and dropped.

Drag back so that only the desired cell is selected.

Drag to select at least one additional cell.

In Calc, to drag and drop a single cell, do this:.

In Calc, after selecting the cell or range, you can position the pointer anywhere within the range.

In Excel, after you select the cell or range to be moved, you need to position the pointer fairly precisely on the border of the cell or range for drag and drop to be available.

Use the Alt+Tab shortcut keys to cycle through the open documents.ĭrag and drop works slightly differently in Calc than it does in Excel:.

Close the current document to access other open documents.

Select a document from your desktop’s Panel or Taskbar to activate it.

Use the Restore Down button on the Title Bar to minimize the active document and reveal other open documents.

From the Window menu, select the document you want to become active.

When more than one document is open, you can switch between the active document and other open documents in several ways: Each Calc window provides menus, toolbars and other features that directly relate to the document open in that window. Two of Calc’s strong points are the accessibility of information about the active document and the ease of navigation of an SDI. When you close the parent window, all files are also closed. Excel uses a Multiple Document Interface (MDI) where all open documents are displayed within one parent window. This means that each document has its own window in which only one document is displayed at a time. Table below summarizes some terminology differences between Calc and Excel.Īll of the chapters in this guide and in the Calc Guide use the AOo Calc terminology.Ĭallouts in cells which appear when the mouse pointer is positioned over the cellĬalc uses a Single Document Interface (SDI).

The information in this chapter builds upon the information given in Chapter General Differences in Use between and Microsoft Office.

This chapter summarizes the differences in use between Calc 2.0 and Microsoft Excel (various versions).

Openoffice spreadsheets