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

How to use colors in Excel 2010 VBA code

If you want to use colors in your VBA macros e.g. to modify cell background color or to change the font color, then you have two options on how to specify the colors:

1. By choosing from one of the preset EXCEL colors (56 colors). You do this by specifying a color index.

2. You can set your own colors by using RGB (Red, Green and Blue) values.

Examples of using the preset colorindex property.
1. Set background color:

Worksheets(“Calendar”).Range(“A1:M1”).Interior.ColorIndex = 34

2. Set font color:

Worksheets(“Calendar”).Range(“A1:M1”).Font.ColorIndex = 34

3. The following VBA code demonstrate how to use colorindex property. It is output is the complete list of the color index palette. The image below is the output from that code.

If you want to try it, name a sheet in your workbook : “ColorIndex” and then paste the code in a new module and run it.

Sub ShowColorIndex()

Dim i As Integer, j As Integer

For i = 1 To 4

For j = 1 To 14

Worksheets(“ColorIndex”).Cells(j, (i – 1) * 2 + 1).Value = (i – 1) * 14 + j

Worksheets(“ColorIndex”).Cells(j, i * 2).Interior.ColorIndex = (i – 1) * 14 + j

Next j

Next i

End Sub

Examples of using the color property:

Set  background:

Worksheets(“Calendar”).Range(“A1:M1”).Interior.Color = RGB(218,225,130)

Set font  color:

Worksheets(“Calendar”).Range(“A1:M1”).Font.Color = RGB(218,225,130)

How do you figure out the right RGB color combination? Well you can experiment with the color palette. The following post will show you how.
How to create a custom font color or fill color in Excel 2010

How to create a custom font color or fill color in Excel 2010

To specify a custom font color or fill color in Excel 2010 follow these steps:

1. In the Home tab, Font group, click on the arrow next to the Fill Color icon. This will show the window with the theme colors.

2. At the bottom of the window, click on More Colors. The colors window will be displayed.

3. Click on the Custom tab.

4. Click anywhere in the colors palette to choose the color you want, then click on the vertical bar on the right side

5. The corresponding RGB color values will show under the color palette.

6. Click OK.

 

You can do the same thing for Font Color. In step 1 above, instead of using the Fill Color icon use the Font Color icon.

 

How to show the developer tab in excel 2010

Excel 2010 user interface does not show the developer tab in the ribbon by default. To activate or show the developer tab follow these steps:

1. Click on the File tab.

2. Click Options. Excel Options window will open.

3. On the left pane click Customize Ribbon.

4. On the right pane, under Main Tabs, check the Developer check box.

5. Click OK. The Developer tab should now show in the ribbon (right most tab).

 

 

 

Selected Excel 2010 shortcut keys

Below is a list of selected Excel 2010 shortcut keys. They all use the control (CTRL) key with a combination of other keys:

Key Description
CTRL+; Enters the current date.
CTRL+SHIFT+# Applies the Date format with the day, month, and year.
CTRL+SHIFT+: Enters the current time.
CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+1 Displays the Format Cells dialog box.
CTRL+2 Applies or removes bold formatting.
CTRL+3 Applies or removes italic formatting.
CTRL+4 Applies or removes underlining.
CTRL+5 Applies or removes strikethrough.
CTRL+6 Alternates between hiding and displaying objects.
CTRL+8 Displays or hides the outline symbols.
CTRL+9 Hides the selected rows.
CTRL+0 Hides the selected columns.
CTRL+A Selects the entire worksheet
CTRL+B Applies or removes bold formatting.
CTRL+C Copies the selected cells.
CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F Displays the Find and Replace dialog box, with the Find tab selected.
CTRL+G Displays the Go To dialog box. F5 also displays this dialog box.
CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I Applies or removes italic formatting.
CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L Displays the Create Table dialog box.
CTRL+N Creates a new, blank workbook.
CTRL+O Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O Selects all cells that contain comments.
CTRL+P Displays the Print tab in Microsoft Office Backstage view.
CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S Saves the active file with its current file name, location, and file format.
CTRL+T Displays the Create Table dialog box.
CTRL+U Applies or removes underlining.
CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection.
CTRL+ALT+V Displays the Paste Special dialog box
CTRL+W Closes the selected workbook window.
CTRL+X Cuts the selected cells.
CTRL+Y Repeats the last command or action, if possible.
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.

 

 

How to change worksheet direction in Excel 2010 to Right-to-Left

The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:

  1. In Excel Ribbon click on the Page Layout tab.
  2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.

How to change default font in Excel 2007 or 2010

To change default font in Excel 2007 or Excel 2010 follow these steps:
1. Click Office button in Excel 2007 or File in Excel 2010.
2. Click Options. Excel Options window will open.


3.Click on the Popular tab in Excel 2007 or General tab in Excel 2010.
4. On the line that says Use this font, select the font you want from the drop down box.
5. Click OK.

How to view multiple worksheets in Excel 2007 / 2010

If you have a workbook with more than one worksheet, then you can view two or more worksheets at the same time. Follow these steps:

1. Select the first worksheet.

2. In the View tab, Window group click New Window.

3. Select the second worksheet. Now you have two windows, one on display and the other one in the background.

4. In the View tab, Window group click Arrange All. The Arrange Windows window will open.

5. Select one of the options then click OK. The Tiled option, for example, will show the sheets next to each other, one on the left and the other on the right. The Horizontal option will show them one under the other.

 

Automatically insert decimal points in Excel 2007 or 2010

To automatically insert decimal points when entering a number in a cell, follow these steps:

  1. Click the  Microsoft Office Button (File tab in case of Excel 2010).
  2. Click Excel Options (at the bottom right of the menu).
  3. Excel Options window will open.
  4. In Excel Options window (left side) click Advanced.
  5. On the right side  check the box labeled: Automatically insert a decimal point , then specify the number of decimal points you want in the combo box labeled: Places (next line).
  6. Click OK.

How to change Excel 2007 default color scheme

To change Excel 2007 default color scheme, follow these steps:

  1. Click the  Microsoft Office Button.
  2. Click Excel Options (at the bottom right of the menu).
  3. Excel Options window will open.
  4. In Excel Options window (left side) click Popular.
  5. On the right side, next to Color scheme click the arrow of the drop down list and select the required scheme.
  6. Click OK.