product-icon

Sheets

No articles.

Quick start

OfficeSuite supports a wide range of spreadsheet formats. 

  • Current and legacy Microsoft formats: .XLS, .XLSX, .XLSM. OfficeSuite users can open, edit, create, save spreadsheets in Microsoft Office formats. 

  • CSV. OfficeSuite users can  open, edit, create, save spreadsheets in the .CSV format. 

  • Open Office. OfficeSuite users can open and edit .ods files. The edited document be saved in a Microsoft format. 

  • Numbers. OfficeSuite users can convert unlimited .numbers files to editable spreadsheets in a Microsoft Office format. The edited document be saved in a Microsoft format. 

Create a spreadsheet

  1. On the File tab, click New
  2. To start from scratch, Blank, or select a template. 
Note that there are no templates other than those on the New document window. 

Save your spreadsheet to MobiDrive

When you save your files to MobiDrive, you can share with others, and get to your files from anywhere - on your computer, tablet, or phone. 

  1. On the File tab, select Save as. 
  2. Name your spreadsheet. You can change the file format.  
  3. Select Save

Save elsewhere 
Saving documents to MobiDrive is a convenient, but not the only option. You can save your spreadsheet to your device or to a third cloud service.  
  1. On the File tab, select Save as
  2. Select Browse to open Windows File Explorer/Finder. In the file browser, navigate to select where you want it saved. 
Note that your cloud storage service may come with a standalone, desktop application, e.g. Dropbox for PC. Download the application to directly save in the application's folder.

You can convert your PDF files to documents, speadsheets, ePubs. Note that PDF conversion is a Premium feature and requires internet

  1. Open your PDF. On the toolbar on top,
  2. Select Export to [...]. In the resulting File Explorer,
  3. Navigate to where you want the output saved. 
  4. Click Save

Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern. Note that AutoFill works with numeric data, but not text. 

  1. Select one or more cells you want to use as a basis for filling additional cells.
  2. Drag a corner handle vertically or horizontally. 

Search a spreadsheet for text, phrase, number, or characters

1. Open a spreadsheet. Press CTRL+F, or 
In the Edit tab, select Find & Replace.
2. In the popup dialog, in the Find tab, type what you want to find.




Optionally, check the search filter criteria box:

  • Match case. Finds only occurrences of the text that match the capitalization you type. 
  • Match entire cell. Search for that contain just the characters that you typed in the Find what: box. 
  • Search within: To search for data in a worksheet or in an entire workbook, select Current Sheet or Entire Workbook.
  • Look in: To search for data with specific details, in the box, click Formulas, Values.

4. Press Enter or navigate the highlighted search results with the Find Next and Find Previous buttons.

Find and Replace
1. Press CTRL+F, or 
In the Edit tab, select Find & Replace.
2. In the popup dialog, in the Replace tab, type the word or number you want to locate in the Find box.
3. Type your new text in the Replace box.
4. Optionally, check the search filter criteria box. 
6. Click Replace to replace the highlighted occurance, or click Replace All to replace all occurances. 

Previous versions are copies of your MobiDrive-stored files we automatically save. To restore an older version or an existing file:

1. Open the file. On the File tab,
2. Select Info 
3. Select Version history

You can move or duplicate a worksheet in the same workbook to organize your workbook exactly how you want. In OfficeSuite for Android:

Move
Select the worksheet tab, and drag it to where you want it.

Duplicate
1. Right-click the worksheet tab.
2. Click Duplicate.

You can hide any worksheet in a workbook to remove it from view. The data in hidden worksheets and workbook windows is hidden, but it can still be referenced from other worksheets within the same workbook.

1. Right-click the Sheet tab.
2. Click Hide or Unhide.

Rows, columns, cells

Insert or delete a cell:

  1. Select any cell. On the Home tab, select Insert. 
  2. Tap Shift Cells down and Shift Cells right, or tap Delete Shift cells up and Shift cells left
Insert or delete a row:
  1. Select any cell within the row. On the Home tab,
  2. Select InsertInsert Rows or Delete Rows.
Insert or delete a column:
  1. Select any cell within the column. On the Home tab,
  2. Select Insert > Insert Columns or Delete Columns.

Hide or show a row or a column

  1. Right-click on the row or column you want to hide.
  2. Click Hide or Unhide.

Filter for unique values:

  1. Select any cells, then select  Data > Filter

Merge and unmerge cells:

  1. Select the cells to merge or unmerge. 
  2. On the toolbar, select Merge and Center. 

Protect, Export, and Share

OfficeSuite lets you protect your spreadsheet  

  • on a file level, allowing no one to view the file, unless they have the password, and/or
  • on an action level, restricting certain actions, or restricting certain action to certain cells, unless they have the password. 
Password-protect a spreadsheet
  1. Open the spreadsheet. On the File tab, 
  2. Click Info
  3. Click Protect Document
  4. Type and retype the password. 
  5. Tap OK.
  6. Save or Save as the spreadsheet. 

Export your spreadsheet to PDF for easy sharing and printing. 

  1. In the File tab, click Export to PDF.
  2. Select what to export.  
  • Active sheet: exports the page you see in Preview on the right. 
  • Export entire workbook: exports all sheets in the workbook. 
  • Export multiple sheets: select the sheets you want exported. 
    3. Click Export. Navigate with the resulting Windows File Explorer/Finder, click Save.

When you share a spreadsheet, you can

  • Provide a link for people to download. 
  • Send a copy of your file as an email attachment.



Send a link to your spreadsheet
Note that this file sharing option is only available for files you keep in MobiDrive. Be sure to save your file to the cloud. 
  1. Open your spreadsheet. In the top left, above the ribbon, click the Share icon. 
  2. Click Send link
  3. In OfficeSuite Mail, enter the email addresses of the people you want to share with. 
  4. Edit the message if you want, and click Send

The people you are sharing with will get an email with a link to your document.

Send your spreadsheet as an email attachment:
  1. Open your document. In the top left, above the ribbon, click the Share icon.
  2. Click Email document, or click Zip & Email. 
  3. In OfficeSuite Mail, enter the recipient's email address.
  4. Click Send.

UI & Feature Summary

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.

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.

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.

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.

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.

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.

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!

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.

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.

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.

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.

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.

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.

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).

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:

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:
 
  • Sum – Provides the sum accrued by adding all the numbers in the data set.
  • Average – Provides an average of all the numbers in the data set.
  • Count – Provides a count of all the cells that contain data.
  • Max – Provides the maximum value of the data set.
  • Min – Provides the minimum value of the data set.
  • Median – Provides the median, or "middle value," of the data set.
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.

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.

Have a question?

We will help you find a solution.

Contact Support