Filter
Top Products
YOUR MICROSOFT OFFICE AND OTHER DOCUMENT TOOLS
EXCEL MOBILE
®
253
11
CHAPTER
number of columns—two in this
example—to the right.
Shift cells down: Inserts the same
number of new cells as the number of
cells you highlighted vertically in step 2.
For example, if you selected an area
containing two cells vertically (A1 and
A2), selecting Shift cells down inserts
two vertical cells; so the original A1 and
A2 (and their contents) are now A3 and
A4. The highlighted area and all cells
below it move the same number of
rows—two in this example—down.
Entire row: Inserts the same number of
new rows as the number of cells you
highlighted vertically in step 2. For
example, if you selected an area
containing two cells vertically (A1 and
A2), selecting Entire row inserts two
rows; so the original rows 1 and 2 (and
their contents) are now rows 3 and 4.
The rows containing the highlighted
area and all rows beneath it move the
same number of rows—two in this
example—down.
Entire column: Inserts the same
number of new columns as the number
of cells you highlighted horizontally in
step 2. For example, if you selected an
area containing two cells horizontally
(A1 and B1), selecting Entire column
inserts two columns; so the original
columns A and B (and their contents)
are now columns C and D. The columns
containing the highlighted area and all
columns on the right move the same
number of columns—two in this
example—to the right.
5 Select OK.
Formatting cells
1 Open the workbook you want to format.
2 Highlight the cells you want to format.
3 Press Menu (right softkey) and select
Format > Cells.
TIP
To add a new worksheet, press Menu and
select Format > Modify Sheets. Select
Insert, enter a name for the worksheet, and
press OK. To change the order of the
worksheets, highlight a worksheet you want
to move, select Move Up or Move Down,
and press OK.