Tips for moving from Microsoft Excel to IBM Lotus Symphony
Spreadsheets
You can use these tips to help you move from Microsoft®
Excel to IBM® Lotus® Symphony™ Spreadsheets.
Adding a slash in a cell
In a table, the first cell is always shared by the row
header and the column header. You can divide the cell into two separate
parts by adding a slash. By using the default border styles, you can
add a slash to a cell. If you want to add more than one slash in a
cell, use the drawing toolbar.
Deleting cell properties
When you select a cell and press Delete, only the content
of the cell is deleted. You can also delete the format, comments,
and other properties of cells.
Entering special symbols
When you enter a special symbol for many times in your
sheets, it is time-consuming to enter the symbols even through copying
and pasting. This section describes how to enter special symbols by
finding and replacing.
Opening multiple files
You can use this convenient way to open multiple files
in Microsoft® Excel 2003
and IBM® Lotus Symphony Spreadsheets.
Operating multiple sheets
You might copy and paste a lot when you do the same operation
to several sheets. To avoid the unnecessary work, you can use these
features that can be applied to multiple sheets through one operation
both in Microsoft Excel
2003 and IBM Lotus Symphony Spreadsheets.
Pasting the value of a formula
Sometimes you use a formula to calculate a certain data
range, and you want to paste only the result of the formula to somewhere
else.
Predefining a list for frequently used data
You might have data that is reused many times, for example,
the name list of people in your company. You can predefine a list
for frequently used data. Lists without simple text are ignored. After
you predefine the list, you can enter your data by entering the first
value and dragging the cursor.
Renaming a sheet
You can rename a sheet in Microsoft Excel 2003 and IBM Lotus Symphony Spreadsheets.
Selecting discontinuous cells
You might already know that pressing Ctrl while selecting
is a common way to select discontinuous cells, but this method occupies
both of your hands. This section provides you with a comfortable way
to select discontinuous cells.
Selecting multiple cell ranges
You can select several cell ranges simultaneously by pressing
Ctrl+Shift. The selecting method is the same in both Microsoft Excel 2003 and IBM Lotus Symphony Spreadsheets. The following example
selects two cell ranges, Area A and Area B, and the cell that starts
a cell range is called the first cell, while the cell that ends a
cell range is called the last cell.
Selecting sheets
You can use the following ways to select sheets in both Microsoft Excel 2003 and IBM Lotus Symphony Spreadsheets.