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

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.