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



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 … [Continue reading]

How to link to values in another Excel 2010 worksheet or workbook

In Excel 2010 or 2007, if you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps: 1. In the sheet you want to link to (source) select the cell where the value is stored. 2. Right click and select … [Continue reading]

How to convert numbers between decimal and hexadecimal

To convert numbers between decimal and hexadecimal you use the equivalent Excel built-in function. To convert from decimal to hexadecimal use the function DEC2HEX. Syntax DEC2HEX(number;places) Number: The decimal number you want to convert … [Continue reading]

Use INDEX and MATCH functions for table lookup

  The table above lists some internet Top Level Domains (TLD) and their equivalent country codes. How can we look up the country name from the table if we know its TLD? E.g. we have the code “cn” and we want to know the corresponding country … [Continue reading]

How to get the day of the week as text in Excel 2010

Excel WEEKDAY function will return the day of the week as a number. See details here: How-to-get-the-day-of-the-week-in-excel-2010 To return the day of the week as text (name of the day), we combine the WEEKDAY function with the TEXT function … [Continue reading]

How to get the day of the week in Excel 2010

To get the day of the week as a number you use Excel WEEKDAY function. Syntax WEEKDAY(serial_number,[return_type]) Serial number: a serial number that represent the date. Return type (optional): a number that determines how the weekday is … [Continue reading]

How to change the range of a defined name in Excel 2010

In a previous post I explained how to define named ranges in Excel 2010. OK, you have defined a name for a specified range. Later on you decided to change the size of that range either by expanding it or reducing it. Here is how you do it: 1. … [Continue reading]

How to define named ranges in Excel 2010

If you have a range of cells that hold a specific type of data e.g. Sales, No. of students etc. then you can give that range a meaningful name. Later if you want to refer to the range you can do that by specifying its name instead of using its cell … [Continue reading]

How to calculate age in Excel 2010

To calculate a person (or anything else) age you basically subtract his date of birth from today’s date. However which date functions to use depends on the amount of precision and the output format you want. Suppose that we want to calculate the … [Continue reading]