OnlyValues |
Replaces
all formulas
on a worksheet
with their values. |
Hide
or
SheetHide |
Hides a worksheet
in a generated
report workbook. |
RowsFit |
Makes the
range rows fit
the contents.
It can be done
manually –
select the rows
needed and double-click
on the boundary
between any
of the selected
rows. |
ColsFit |
Makes the
range columns
fit the contents.
It can be done
manually –
select the columns
needed and double-click
on the boundary
between any
of the selected
columns. |
AutoScale |
Sets up the
page option
Fit to 1 page
wide by (empty)
tall (this can
be found in
File/Page Setup
on the Page
tab). |
AutoSafe |
Protects a
sheet with a
random password.
This corresponds
to Tools/Protection/Protect
Sheet
menu command
call and Contents
box checking. |
