Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




10.3.2. Gnumeric

Gnumeric is a spreadsheet optimized for the GNOME desktop.
Start Gnumeric by clicking on Applications > Office > Gnumeric Spreadsheet in GNOME or the Kickoff Application Launcher > Applications > Office > Spreadsheet menu entry for Gnumeric in KDE.
Major functions of the top menu are:
lets you create New documents, Open , Save , Page Setup , Set , Clear and Show the Print Area . File also provides options to Print , Send To an email address, view and add to the program's Properties , set Preferences , access a Full History , and Close a file, or Quit the program.
allows you to Undo and Redo actions, Cut , Copy , and Paste and Fill , Clear , and Delete Rows , Columns , and Cells . Edit also provides options to Find , Replace or Goto a Cell , manage the Sheets , Select various ranges in the spreadsheet, and Recalculate .
allows you to create a New View of the workbook, to Freeze Panes , select a different Workbook , choose Toolbars , View Statusbar , Full Screen and Zoom in and out.
lets you insert Cells , Columns , Rows , Charts , Images , Functions , Names , Comments , Hyperlinks and Special fields such as Current Date , Current Time and Current date and time .
lets you format the Cells , Rows , Columns , Sheets and Workbook can be formatted and Preferences changed. Use Autoformat to format a region of cells according to a pre-defined template.
provides Auto Correct , Auto Save , Goal Seek , Solver , View and Add Scenarios , Simulation , Statistical Analysis and manage Plug-ins .
allows manipulation of the data such as Sort , Filter , Validate , Consolidate , create a Table , Group and Outline , convert Text to Columns and Get External Data .
Help > Contents
opens the Gnumeric help manual (as does the F1 key), Gnumeric on the Web , Live Assistance , and Report a Problem .
The row of icons under the top menu bar contains the most frequently used functions that are listed in the top menu.
The third menu panel allows you to configure the appearance of your data, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the cell you are pointing to and the data window shows what the cell contains.
The panel at the bottom of the spreadsheet shows which spreadsheet is currently selected, how many worksheets are in the file, and a function's result in the cell to which you are of the cell you are pointing. You can add or change a worksheet by:
  • a right mouse click on one of the tabs, then choosing from the menu.
    clicking on Edit > Sheet in the top menu.
A tutorial on using Gnumeric is available from

  Published under the terms of the Open Publication License Design by Interspire