Home moves the focus to the start of a row.Pressing the arrow keys on the keyboard moves the focus in the direction of the arrows. Pressing Tab or Shift+Tab moves the focus right or left, respectively.Pressing Enter or Shift+Enter moves the focus down or up, respectively.This method is most useful when the two cells are a large distance apart. To move the focus using the mouse, simply move the mouse pointer to the cell where the focus should be and click the left mouse button. (Left) One selected cell and (right) a group of selected cells Using the mouse In the figure below, the Navigator would select cell G28. Type the cell reference into the top two fields, labeled Column and Row, and press Enter. Or just click into the Name box, delete the existing cell reference, and type in the cell reference you want.Ĭlick on the Navigator button in the Standard toolbar (or press F5) to display the Navigator. Type the cell reference of the cell you want to go to and press Enter. The existing cell reference will be highlighted. Place the mouse pointer over the cell and click.Ĭlick on the little inverted black triangle just to the right of the Name Box on the Formula Bar. Going to a particular cell Using the mouse 2.5 Customizing the effect of the Enter key.2.4 Using Home, End, Page Up and Page Down.Calc also supports a wide range of other file formats, for both opening and saving files, such as CSV, HTML, SXC, DBF, DIF, UOF, SLK, SDC and others. The default file format for Calc (versions 2.x and 3.x) can be set to either Microsoft Excel's native file format or the international standard OpenDocument Format (ODF) ISO/ IEC 26300:2006. Calc is also capable of writing spreadsheets directly as PDF files. It provides a number of features not present in Excel, including a system that automatically defines series for graphing based on the layout of the user's data. Calc is capable of opening and saving most spreadsheets in Microsoft Excel's file format.

Apache OpenOffice Calc is the spreadsheet component of the Apache OpenOffice software package.Ĭalc is similar to Microsoft Excel, with a roughly equivalent range of features.

Openoffice sheets