How to Use Macros and Other Developer Functions in Spreadsheets 2013
To set macros in Kingsoft Spreadsheets, follow the steps below:
Step 1 Click the Macros icon in the Developer tab, or in the View tab. The Macros dialogue box will open.
Step 2 Enter the macro name in the Macro name enter box.
Step 3 Select the...
How to Manage Workbook Windows in Spreadsheets 2013
Kingsoft Spreadsheets provides six window functions in the View tab.
The window functions are as follows:
New Window: To open a new window containing the contents of the current worksheet.
Arrange All: When there are more than two opened worksheets, you can view them horizontall...
How to Print Gridlines and Headings of Workbook in Spreadsheets 2013
In Spreadsheets 2013, you can choose to print the gridlines and headings of your worksheets. To enable the gridlines and headings and print them, follow steps in this guide.
View and print gridlines and headings
There are six check boxes listed in the View...
How to Use Print Layout Mode in Spreadsheets 2013
Kingsoft Spreadsheets provides five different workbook view modes: Normal, Print Layout, Page Break Preview, Full Screen, and Reading Layout. You can select different view mode to suit your needs.
Normal view is the default view of Kingsoft Spreadsheets. You can edit the content, for...
How to Use Page Break Preview Mode in Spreadsheets 2013
If you are working in a long document and want to break it into many pages, you can insert a page break in the worksheet. After the insertion, you can preview the worksheet in the page break preview mode.
There are two ways to insert a page break in Spreadsheets 2013: automatic...
How to Use What-if Analysis Function in Spreadsheets 2013
Kingsoft Spreadsheets provides the what-if analysis function, which includes Goal Seek and Solver Parameters. Learn how to use these two functions in Spreadsheets 2013.
The Goal Seek function in Spreadsheets allows users to obtain the value in the changing ...
How to Track Changes in Workbook using Spreadsheets 2013
You can use the Track Changes function if you want to track the changes made in your worksheet. Each reviewer who inserts or deletes data will be recorded when the Track Changes function is turned on. Kingsoft Spreadsheets provides the Highlight Changes function in order to dis...
How to Allow Users to Edit Cell Ranges in Spreadsheets 2013
Sometimes you may want others to make changes only to part of the data in the worksheet, but keep the rest of it locked. To achieve this, follow the steps below:
Step 1 Click the Allow Users to Edit Ranges icon in the Review tab. The Allow Users to Edit Ranges dialogue box ...
How to Convert Text to Columns in Spreadsheets 2013
Kingsoft Spreadsheets provides a Text to Columns function. It plays an important role in importing text data and performing data storage format conversion. For example, import long digital data and fast data format conversion. To use this function, follow the steps below:
Step 1 Cr...