Kingsoft office for Android – Menu part 1

This is a high level view of the spreadsheet menu.

You access the spreadsheet menu by clicking on the Tools icon at the bottom of the screen. The menu consists of the following tabs:

  1. File
  2. View
  3. Format
  4. Cell
  5. Insert
  6. Data
  7. Review

Shift the screen to the left, if necessary to show the rest of the tabs.

File Tab

In the file tab you can perform the following tasks

Save As – Save your file with a different name.

Share –  Share your file with another  person.

Encrypt – Protect your  file using a password.

Print – Print the file.

File Info – Display file information like file size, type .. etc.

Help & Feedback – contact support for problems or issues.

View Tab

In the view tab you can perform the following tasks

Copy– Copy data from a cell or a range of cells.

Paste– Paste data previously copied to a new location.

Find-  Search the spreadsheet for a specific text or number.

GO To– Go to a specific cell within the spreadsheet.

Freeze Panes – Freeze a row or a column so that it shows all the time when you are scrolling.

Filter – Filter data so that you only show a subset of your data based on a specified data category.

Highlight – Highlight a column or a row with a distinct color.

Hide – Hide sheet grid-lines or hide column and row headers.

Rotate screen – Rotate screen to portrait view (vertical) or landscape (horizontal).

Format Tab

Format cells using different options like font type, font size or color, alignment, background color, border … etc.

Cell Tab

Merge – Merge two or more cells into one cell.

Format Painter – Copy format of a cell to another cell or a range of cells.

Clear – Clear cell contents, format, comments or hyperlink.

Wrap text – Wrap a long text into two or more lines to fit within the cell.

Fit height – Make the cell higher / shorter so that the cell size is not more or less than the contents of the cell.

Fit Width – Make the cell wider / smaller so that the cell size is not more or less than the contents of the cell.

Resize – Specify row height and column width in numbers.

Delete Cells – Delete individual cells or complete rows/columns.

Format Cells – Options are the same as in the format menu mentioned before.

Table Style – Format a table using a preset table styles and options.

So far we have covered the File, View, Format and Cell tabs. In the next post we will cover the Insert, Data and Review tabs

 

Kingsoft-menu

Introduction to Kingsoft office for Android

You can use Kingsoft office for Android (aka WPS office) to create Spreadsheets which are compatible with Microsoft Excel spreadsheets. Most of Excel functionality is available however you have to use a different user interface. This post is based on the phone version. The tablet version may be slightly different.

  1. Launch WPS Office by clicking the program icon.
  2. In the first screen click the Open icon.
  3. From the listed file types select XLS.
  4. A list of available files will be shown. Select your file.
  5. Click on the Tools icon at the bottom of the screen to reveal the spreadsheet menu. The menu consists of the following tabs:
    • File
    • View
    • Format
    • Cell
    • Insert
    • Data
    • Review

In the coming posts we will first give a quick description of each one of these tabs and it is individual functions. Later on we can go into a detailed how-to posts on WPS office for android.

Kingsoft-open

Kingsoft-filetype

Kingsoft-xlslist