Sheets Editor

OfficeSuite supports all of the major spreadsheet types including .XLS, .XLSX, .XLSM, .ODS, and .CSV. To access the Sheets Editor, either open or create a new spreadsheet.

The Sheets Editor is easily identified by its characteristic green-colored menu bar. Across the top you'll find the following controls:

	Save any changes made to the spreadsheet.
	Undo the most recent change made.
	Redo the most recent undone change.
	Create new file will create a new blank spreadsheet.
	Print the spreadsheet using a networked printer.
	Share the currently opened spreadsheet.
	Toggle Full Screen mode.
	Minimize the Sheets Editor to the taskbar.
	Maximize the Sheets Editor to take up the entire screen.
	Close the currently open Sheets Editor window. Unsaved spreadsheets will be prompted with a Save dialog.

Underneath the topmost menu, OfficeSuite's Sheets Editor contains a series of dropdown menus separated into the Edit, Insert, Page Layout, Formulas, Data, Review, and View categories, alongside the Hamburger icon which accesses the Main OfficeSuite Menu.

In the dialogs found throughout the Sheets Editor, certain fields will contain a Selector icon, which can be populated by selecting the desired cells and cell ranges directly using the mouse.

Edit

The Edit dropdown houses a range of options designed to make manipulating, selecting, and finding data in your spreadsheet easier.

	Undo – Reverts the most recent change made.
	Redo – Reapplies the most recent undone change.
	Cut – Removes the selected element(s) and copies them to the clipboard.
	Copy – Copies the selected element(s) onto the clipboard.
	Paste – Inserts cut/copied element(s) from the clipboard.
	Paste Options – Provides options for pasting specific elements or groups of elements such as values, formulas and formatting.
	Select All – Selects all of the elements in the document.
	Find & Replace – Locates any instances of text entered, and can replace them with text from the Replace with: field. The Match case and Whole words only options will match any capitalization you have entered and only search for exact word matches, respectively.

Insert

The Insert dropdown is used for placing a wide range of visual additions to your spreadsheets, such as graphics and charts.

	Table... – Insert a table with a pre-set formatting style, just select its proportions and click OK.
	Picture... – Inserts an image into your spreadsheet from your computer's filesystem. Placed images can be modified using the resize and scale anchors, and rotated using the protruding rotate anchor.
	Right-clicking on an image provides additional options: Save as Picture – Save the currently selected image to your computer.
	Chart... – Opens the Chart Editor, which allows you to insert a chart with a range of visual styles. The Type tab lists charts and chart subtypes, including 3D effect variants. The Format tab allows you to add and name series, ranges, and titles.
	Right-clicking on an chart provides additional options: Change Chart Type... – Change the selected chart type through the Chart Editor. Format Chart... – Change the selected chart data and formatting through the Chart Editor. Save as Picture – Save the currently selected chart as an image on your computer.
	Chart in New Sheet – Same as the Chart operation above, except the chart will be added as its own separate sheet.
	Comment – Adds a comment to a cell or cell range. Commented cells are marked by a small indicator in the upper right, and comments will appear by hovering your mouse over them. Comments can be edited and deleted from the Review tab.
	Right-clicking on an cell with a comment provides additional options: Edit Comment – Edits a comment in the selected cell or cell range. Delete Comment – Removes a comment from the selected cell or cell range.
	Hyperlink... – Adds a hyperlink to any selected text. You can choose between a web address, email address, or bookmark within the spreadsheet by using the corresponding tabs at the top of the dialog.

Page Layout

	Margins – Set the spreadsheet's margins from three presets (Normal, Wide, Narrow) or Custom Margins to use a specific one.
	Orientation – Set the spreadsheet's orientation between Portrait and Landscape.
	Size – Set the paper's dimensions from a number of presets (Letter, A4, Envelope etc.) , or use the Custom Paper Size... option.
	Scaling Options – Determine how the spreadsheet will be scaled and visualized. This option is especially valuable if the document is going to be printed out. The options there include:

	No Scaling – Use the actual size of the page.
	Fit Sheet on One Page – Shrink the printout to fit on one page.
	Fit All Columns on One Page – Shrink the printout to one page width.
	Fit All Rows on One Page – Shrink the printout to one page height.

Page Setup – Adjust the page size, scaling, margins, order and more.

Formulas

The Formulas dropdown includes all of the controls needed to effectively manage your spreadsheet formulas.

	Insert Function – Contains a list of all the formulas available in OfficeSuite alongside detailed descriptions of their functionality:
	Common – Contains more commonly used formulas, like AVERAGE and SUM. All – Displays the full list of formulas currently available in OfficeSuite. Database – Contains database-related formulas such as maximum and minimum database values or extracting records from a database. Information – Informational formulas allow you to make adjustments based on cell conditions, such as whether cells contain even numbers, return errors, and others. Logical – Logical arguments are those that can manipulate values like true/false. Math & Trig – Contains mathematical formulas including trigonometric functions and logarithms. Date & Time – Lets you write formulas that operate based on date and time parameters. Statistical – Provides formulas found in statistics like standard deviation and frequency. Financial – Finance formulas include calculating interest payments and depreciation. Reference – Allows you to lookup references and values of a cell range. Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more. Compatibility – Provides a wide selection of variance and distribution formulas.
	Define Name... – Lets you name a particular cell or cell range, its range, and which sheets make up its scope.
	Name Manager... – Displays all of the named cells and cell ranges in the spreadsheet.
	Recalculate – Forces the selected formula to be recalculated. Useful for applying changes made to updated formulas and cells.
	Sum – Performs quick calculations of the numbers in a selected cell range and displays the result. Using this with only one cell selected will provide the sum of the above cell only.

Data

The Data dropdown allows you to easily manage data sets.

Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order.

	Sort A to Z – Sorts cells alphabetically. Numerical data will be sorted in ascending order.
	Sort Z to A – Sorts cells reverse alphabetically. Numerical data will be sorted in descending order.
	Custom Sort... – Opens the sort dialog, allowing you to sort data using custom criteria.

	Filter – A great way for managing large amounts of data, Filter manipulates entire cell ranges to display specific entries. Once you apply a filter to a cell range, press the Down arrow that appears in the cell range to display the Filter dialog.
	Data Validation... – Opens the Data Validation dialog, used to manage and highlight cells that return invalid cell data.
	Circle Invalid Data – Circles invalid data as specified using Data Validation above.
	Group – Group a range of rows or columns.
	Ungroup – Ungroup a range of rows or columns.
	Clear Outlines – Hide the outlines of a grouped range of rows or columns. This does not ungroup them.
	Subtotal – Shows options for calculating a subtotal of a group of cells.
	Show Detail – Expand a group of previously hidden cells.
	Hide Detail – Collapse a group of cells.

Review

The Review dropdown lets you manage your spreadsheet comments.

	Add Comment – Adds a comment to the selected cell or cell range.
	Edit Comment – Edits a comment in the selected cell or cell range.
	Delete Comment – Removes a comment from the selected cell or cell range.
	Previous Comment – Jumps to the previous comment in the spreadsheet.
	Next Comment – Jumps to the next comment in the spreadsheet.
	Protect/Unprotect Sheet... – Opens the protect sheet dialog, which allows you to apply editing restrictions. Note that restrictions are applied to the current sheet only and protect passwords are not recoverable!

View

The View dropdown houses spreadsheet navigation controls alongside display options.

	Go to Cell.. – Go to a specific cell by entering its coordinates, rather than to it.
	Zoom... – Lets you change your view to a predefined or custom zoom level.
	Freeze – Locks the display of cells and columns so that they will always display on-screen. The lock area starts at the row-column intersection of the currently selected cell.
	Gridlines – Toggles the display of gridlines (or cell borders) for individual sheets.
	Headings – Toggles the display of row letters and column numbers across the top and left side of the Sheets Editor.
	Right-to-Left Sheet – Create a Right-to-Left sheet.

Upgrade

Allows you to upgrade to OfficeSuite Premium for more advanced editing features.

The Clipboard, Font, Align, Number, Formatting, Cells, and Editing sections, located below the dropdown menus, dynamically expand or contract depending on the horizontal size of the Sheets Editor window.

Clipboard

The Clipboard section contains options to cut/copy and paste both text and formatting throughout your spreadsheet.

	Paste – Place cut or copied elements in your spreadsheet.
	Cut – Cut elements from one location, and move them to another via paste.
	Copy – Copy elements from one location to another via paste.
	Format Painter – Copies the formatting and style of the selected text.

Font

The Font section is where you'll find the standard range of tools for adjusting font sizes, colors, and styles; formatting options for individual cells and cell ranges; as well as border settings.

Calibri	Font Families – Opens the font menu, which lists your available OfficeSuite fonts in their respective typeface.
11	Font Size – Adjusts font size from a list of predefined values.
	Decrease Font – Decreases the currently selected text by one font point.
	Increase Font – Increases the currently selected text by one font point.
	Bold – Embolden text.
	Italics – Italicize text.
	Underline – Underline text.
	Cell Border – Provides options for specifying cell borders on cells or cell ranges. The More borders... option provides additional border creation options.
	Fill Color – Specify the fill color of a cell or cell range.
	Font Color – Specify the text color of a cell or cell range.

Align

The Align section contains a wide range of adjustments to how text is displayed within cells.

	Align Left – Aligns text against the left border.
	Align Center – Centers text between both borders.
	Align Right – Aligns text against the right border.
	Align Top – Aligns cell text against the top border.
	Align Middle – Aligns cell text between the top and bottom borders.
	Align Bottom – Aligns cell text against the bottom border.
	Wrap Text – Allows text to be wrapped within a cell so that it does not get obscured by the cell boundaries.
	Merge and Center – Groups the contents of multiple cells together, creating a single cell in their place. Note that only the upper-leftmost cell data will be retained.

Number

The Number section specifies the numerical data formatting for the selected cell(s).

General	Number Format – Assigns the currently selected cell(s) a specific number format from the dropdown menu.
	Currency – Marks the entered numerical value as currency, in dollars. You can select additional currencies using the dropdown menu.
	Percentage – Marks the entered numerical value as a percentage.
	Comma Style – Lets you modify the comma style of the selected cell(s), if applicable.
	Increase Decimal – Adds more digits after the decimal point of a number.
	Decrease Decimal – Removes digits after the decimal point of a number.

Formatting

The Formatting section lets you specify cell styles and provides options for conditional formatting,

	Conditional Formatting – Opens the conditional formatting dialog, which provides options to highlight cells and cell ranges, add data bars and color scales, and create custom formatting rules based on certain criteria.
Normal	Cell Styles – Applies a predefined style to the selected cell(s), useful for creating a more uniform look for your spreadsheets.

Cells

The Cells section contains options to manipulate cells, row, columns, and sheets.

Insert – Adds new cells, rows, columns, or sheets:

	Shift Cells Down – Inserts a new cell at the selected location, shifting any current cell data down.
	Shift Cells Right – Inserts a new cell at the selected location, shifting any current cell data to the right.
	Insert Rows – Inserts a new row above the current selection.
	Insert Columns – Inserts a new column to the left of the current selection.
	Insert Sheet – Adds a new sheet to the spreadsheet.

Delete – Deletes the currently selected cell(s), row(s), column(s), or sheet(s).

	Shift Cells Up – Deletes the currently selected cell(s) and shifts any cells with data upwards.
	Shift Cells Left – Deletes the currently selected cell(s) and shifts any cells with data to the left.
	Delete Rows – Deletes the currently selected row(s) and shifts any rows with data upwards.
	Delete Columns – Deletes the currently selected column(s) and shifts any columns with data to the left.
	Delete Sheet – Deletes the current sheet.

Format – Provides advanced customizations for how your spreadsheet is displayed.

	Row Height... – Specifies the row height for the selected cell(s).
	AutoFit Row Height – Automatically scales the row height to fit the contained data.
	Column Width... – Specifies the column width for the selected cell(s).
	AutoFit Column Width – Automatically scales the column width to fit the contained data.
	Hide & Unhide – Provides options for hiding and unhiding rows, columns, and sheets:

	Hide Rows – Hides the currently selected row(s).
	Hide Columns – Hides the currently selected columns(s).
	Hide Sheet – Hides the currently selected sheet.
	Unhide Rows – Unhides and neighboring hidden row(s).
	Unhide Columns – Unhides any neighboring hidden column(s).
	Unhide Sheets... – Displays the Unhide Sheets dialog, which allows you to specify which sheets are displayed.

	Rename Sheet – Renames the currently active sheet.
	Tab Color – Insert a color into the spreadsheet tabs at the bottom of the page.
	Protect Sheet... – Opens the protect sheet dialog, which allows you to apply editing restrictions. Note that restrictions are applied to the current sheet only and protect passwords are not recoverable!
	Lock Cell – Marks the selected cell(s) as locked to prevent them from editing.
	Format Cells... – Displays the Format Cells dialog, which allows you to apply custom to the selected cell(s).

Chart

Insert a chart into the spreadsheet.

Chart – Performs quick calculations of the numbers in a selected cell range and displays the result in the cell directly below them. Using this with only one cell selected will perform the operation only on the cell directly above:

Editing

The Editing section contains search and navigation options, as well as the ability to filter and sort your data.

Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result in the cell directly below them. Using this with only one cell selected will perform the operation only on the cell directly above:

Clear – Quickly clears formatting, contents, and/or hyperlinks from your spreadsheet:

	Clear All – Clears the selected cell(s) completely.
	Clear Formats – Clears any formatting applied to the selected cell(s).
	Clear Contents – Clears the contents of the selected cell(s), retaining formatting.
	Clear Hyperlinks – Clears any hyperlinks in the selected cell(s).

Sort & Filter – Provides options to sort cell data based on predefined criteria, alongside filter options to display specific entries:

	Sort A to Z – Sorts cells alphabetically. Numerical data will be sorted in ascending order.
	Sort Z to A – Sorts cells reverse alphabetically. Numerical data will be sorted in descending order.
	Custom Sort... – Opens the sort dialog, allowing you to sort data using custom criteria.
	Filter – A great way for managing large amounts of data, Filter manipulates entire cell ranges to display specific entries. Once you apply a filter to a cell range, press the Down arrow that appears in the cell range to display the Filter dialog.

	Find & Replace – Searches for instances of text entered in the Search field, and will replace them with text entered in the Replace field:
	Match case – Will search for exact cases such as capitalized or all lowercase letters. Match whole words only – Will filter out results that have the searched text as a part of a larger cell entry. Look in: – Will search either through cell values, formulas, or comments.

The Formula bar is always displayed under the function tabs, and allows you to add entries and formulas easily by using the Insert function button. More information on how formulas work can be found in the Formulas dropdown above.

Right-clicking on the column letters (if Headings are enabled in the View dropdown) provides additional customizations:

	Insert – Insert the same number of selected columns to the left of the current selection.
	Delete – Delete the currently selected column(s).
	Column Width... – Allows for the precise editing of the width of the selected columns.
	Hide – Hide the currently selected column(s).
	Unhide – Unhide any neighboring hidden column(s).

Right-clicking on the row numbers (if Headings are enabled in the View dropdown) provides additional customizations:

	Insert – Insert the same number of selected rows above the current selection.
	Delete – Delete the currently selected row(s).
	Row Height... – Allows for the precise editing of the width of the selected columns.
	Hide – Hide the currently selected row(s).
	Unhide – Unhide any neighboring hidden row(s).

Along the bottom of the Sheets Editor is the sheet display, where you can move between sheets using the Navigation arrows, or by clicking on the individual sheets. You can rename a sheet by double-clicking on it, and rearrange sheets by dragging them.

Right-clicking on a sheet provides additional sheet management options:

	Insert Sheet – Insert a sheet after the last sheet in the spreadsheet.
	Delete Sheet – Delete the currently selected sheet.
	Duplicate Sheet – Create a copy of the selected sheet.
	Rename Sheet – Rename the selected sheet.
	Protect Sheet... – Opens the protect sheet dialog, which allows you to apply editing restrictions. Note that restrictions are applied to the current sheet only and protect passwords are not recoverable!
	Hide Sheet – Hides the currently selected sheet.
	Unhide Sheet... – Displays the Unhide Sheets dialog, which allows you to specify which sheets are displayed.

You can also add a new sheet by pressing the Add button.

At the very bottom of the Sheets Editor, the green status bar displays an average, count, and sum of the values of any currently selected cells. You can also change the zoom levels by using the Plus and Minus buttons, or by using the zoom slider that appears when clicking on the zoom percentage.