vert line

BOLD

Toggles the data in the specified range between bold and regular weight.

BOLD(cell) or BOLD(range)

cell any cell reference

range any worksheet range

This function changes the format of the selected cells to bold if they are regular weight, and to regular weight if they are bold.

Returns: cell or range

CLRHBREAK or CLEARHBREAK

Clears horizontal page breaks from the specified cell or range.

CLRHBREAK(cell) or CLRHBREAK(range)

cell any cell reference

range any worksheet range

This function clears any horizontal page breaks within the cell or range, including breaks following the last cell in the range, but not breaks preceding the first cell.

Returns: cell or range

clrhbreak(a1)

clrhbreak(a1:b7)

clrhbreak(myrange)

CLRVBREAK or CLEARVBREAK

Clears horizontal page breaks from the specified cell or range.

CLRVBREAK(cell) or CLRVBREAK(range)

cell any cell reference

range any worksheet range

This function clears any vertical page breaks within the cell or range, including breaks following the last cell in the range, but not breaks preceding the first cell.

Returns: cell or range

clrvbreak(a1)

clrvbreak(a1:b7)

clrvbreak(myrange)

DEFAULTS

Sets the formatting of the specified cell or range to its defaults.

DEFAULTS(cell) or DEFAULTS(range)

cell any cell reference

range any worksheet range

Returns: cell or range

defaults(a1)

defaults(a1:b7)

defaults(myrange)

HBREAK

Sets a horizontal page break.

HBREAK(cell) or HBREAK(range)

cell any cell reference

range any worksheet range

Sets a horizontal page break immediately after cell or range.

Returns: cell or range

hbreak(a1)

hbreak(a1:b7)

hbreak(myrange)

HIDDENCOL

Tests for hidden columns.

HIDDENCOL(cell)

cell any cell reference

This functions tests if cell is in a hidden column.

Returns: 1 if cell is hidden, 0 if not

hiddencol(h19)

HIDDENROW

Tests for hidden rows.

HIDDENROW(cell)

cell any cell reference

This function tests if cell is in a hidden row.

Returns: 1 if cell is hidden, 0 if not

hiddenrow(h19)

HIDECOL

Hides the specified columns.

HIDECOL(cell) or HIDECOL(range)

cell any cell reference

range any worksheet range

This function hides the columns that contain cell or range. Column A cannot be hidden.

Returns: cell or range

hidecol(b5)

hidecol(b5:c7)

hidecol(myrange)

HIDEROW

Hides the specified rows.

HIDEROW(cell) or HIDEROW(range)

cell any cell reference

range any worksheet range

This function hides the rows that contain cell or range. Row 1 cannot be hidden.

Returns: cell or range

hiderow(b5)

hiderow(b5:c7)

hiderow(myrange)

ITALIC

Toggles the data in the specified range between italic and standard text.

cell any cell reference

range any worksheet range

This function changes the format of the cells specified by cell or range to italic if they are standard, and to standard if they are italic.

Returns: cell or range

italic(a1)

italic(a1:b7)

italic(myrange)

OUTLINE

Outlines the specified cells with the specified border.

OUTLINE(cell, border) or OUTLINE(range, border)

cell any cell reference

range any worksheet range

border the specified border type: 0, 1 or 2

This function outlines each of the specified cells with a border of type border. Possible borders are 0 (no border), 1 (single border) or 2 (double border).

Returns: cell or range

outline(a1,1)

outline(a1:b7,0)

outline(myrange,2)

PLAIN

Changes the format of the specified cell or range to plain text.

PLAIN(cell) or PLAIN(range)

cell any cell reference

range any worksheet range

This function changes the text formatting of cell or range to plain (i.e. non-bold, non-italic).

Returns: cell or range

plain(a1)

plain(a1:b7)

plain(myrange)

RESETROWSIZE

Resets the size of the specified rows.

RESETROWSIZE(cell) or RESETROWSIZE(range)

cell any cell reference

range any worksheet range

This function sets the row(s) that contain cell or range to the default for the worksheet.

Returns: cell or range

resetrowsize(a1)

resetrowsize(a1:b7)

resetrowsize(myrange)

RESETCOLSIZE

Resets the size of the specified columns.

RESETCOLSIZE(cell) or RESETCOLSIZE(range)

cell any cell reference

range any worksheet range

This function sets the column(s) that contain cell or range to the default for the worksheet.

Returns: cell or range

resetcolsize(a1)

resetcolsize(a1:b7)

resetcolsize(myrange)

SETALIGN

Sets the text alignment of the specified cell or range.

SETALIGN(cell, h-align[, v-align])

SETALIGN(range, h-align[, v-align])

cell any cell reference

range any worksheet range

h-align a horizontal alignment constant

v-align an [optional] vertical alignment constant

This function aligns the text in cell or range according to h-align and an optional v-align. For a list of alignment constants, see "Alignment Constants" .

Returns: cell or range

setalign(a1,LEFTALIGN)

setalign(a1:b7,RIGHTALIGN,TOPALIGN)

setalign(myrange,RIGHTALIGN,BOTTOMALIGN)

SETALTCOLOR

Sets the alternate text color of the specified cell or range.

SETALTCOLOR(cell, color[, pattern]), SETALTCOLOR(range, color[, pattern]), SETALTCOLOR(cell, r, g, b [, pattern]), or SETALTCOLOR(range, r, g, b[, pattern])

cell any cell reference

range any worksheet range

color a color constant

r the amount of red

g the amount of green

b the amount of blue

pattern a pattern number

This function sets the alternate text color of cell or range to the specified color and optional pattern. The color can be specified by a color constant color or with red, green, and blue values (r, g, b) between 0 and 1. For a list of color constants, see "Color constants" . The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setaltcolor(a1,BLACKCOLOR)

setaltcolor(a1:b7,0,0.5,0.5)

setaltcolor(myrange,MAGENTACOLOR,53)

SETALTPATTERN

Sets the alternate text pattern of the specified cell or range.

SETALTPATTERN(cell, pattern) or SETALTPATTERN(range, pattern)

cell any cell reference

range any worksheet range

pattern a pattern number

This function sets the alternate text pattern of cell or range to pattern, using the current alternate color. The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setaltpattern(a1,23)

setaltpattern(a1:b7,17)

setaltpattern(myrange,59)

SETBKGCOLOR

Sets the background color of the specified cell or range.

SETBKGCOLOR(cell, color [, pattern]), SETBKGCOLOR(range, color[, pattern]), SETBKGCOLOR(cell, r, g, b [, pattern]), or SETBKGCOLOR(range, r, g, b [, pattern])

cell any cell reference

range any worksheet range

color a color constant

r the amount of red

g the amount of green

b the amount of blue

pattern a pattern number

This function sets the background color of cell or range to the specified color and optional pattern. The color can be specified by a color constant color or with red, green, and blue values (r, g, b) between 0 and 1. For a list of color constants, see "Color constants". The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setbkgcolor(a1,BLACKCOLOR)

setbkgcolor(a1:b7,0,0.5,0.5)

setbkgcolor(myrange,MAGENTACOLOR,53)

SETBKGPATTERN

Sets the background pattern of the specified cell or range.

SETBKGPATTERN(cell, pattern) or SETBKGPATTERN(range, pattern)

cell any cell reference

range any worksheet range

pattern a pattern number

This function sets the background pattern of cell or range to pattern, using the current background color. The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setbkgpattern(a1,23)

setbkgpattern(a1:b7,17)

setbkgpattern(myrange,59)

SETBORDER

Sets the border for a specified cell or range.

SETBORDER(range, borders, bool)

range any worksheet range

borders a border constant

bool whether the border should be visible

This function places a border in range around the sides of the cells specified by borders, which can be one of: LEFTBORDER, RIGHTBORDER, TOPBORDER, BOTTOMBORDER. These constants can be OR'd together. The bool argument should be TRUE or FALSE, depending on whether the border should be visible.

Returns: range

setborder(a1,TOPBORDER,TRUE)

setborder(a1:b7,LEFTBORDER | RIGHTBORDER,TRUE)

setborder(myrange,TOPBORDER | BOTTOMBORDER,FALSE)

SETBORDERCOLOR

Sets the border color for a specified cell or range.

SETBORDERCOLOR(cell, color [, pattern]), SETBORDERCOLOR(range, color[, pattern]), SETBORDERCOLOR(cell, r, g, b [, pattern]), or SETBORDERCOLOR(range, r, g, b [, pattern])

cell any cell reference

range any worksheet range

color a color constant

r the amount of red

g the amount of green

b the amount of blue

pattern a pattern number

This function sets the border color of cell or range to the specified color and optional pattern. The color can be specified by a color constant color or with red, green, and blue values (r, g, b) between 0 and 1. For a list of color constants, see "Color constants". The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setbordercolor(a1,BLACKCOLOR)

setbordercolor(a1:b7,0,0.5,0.5)

setbordercolor(myrange,MAGENTACOLOR,53)

SETBORDERPATTERN

Sets the border pattern for the specified cell or range.

SETBORDERPATTERN(cell, pattern) or SETBORDERPATTERN(range, pattern)

cell any cell reference

range any worksheet range

pattern a pattern number

This function sets the border pattern of cell or range to pattern, using the current border color. The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setborderpattern(a1,23)

setborderpattern(a1:b7,17)

setborderpattern(myrange,59)

SETBORDERTYPE

Sets the border type for a specified cell or range.

SETBORDERTYPE(cell, border) or SETBORDERTYPE(range, border)

cell any cell reference

range any worksheet range

border a border type: 0, 1, or 2

This function changes the border for cell or range to border type border. Possible borders are 0 (no border), 1 (single border) or 2 (double border). This does not place a border around the cell.

Returns: cell or range

setbordertype(a1,1)

setbordertype(a1:b7,0)

setbordertype(myrange,2)

SETCOLOR

Sets the text color for a specified cell or range.

SETCOLOR(cell, color [, pattern]),

SETCOLOR(range, color[, pattern]),

SETCOLOR(cell, r, g, b [, pattern]), or

SETCOLOR(cell, r, g, b [, pattern])

cell any cell reference

range any worksheet range

color a color constant

r the amount of red

g the amount of green

b the amount of blue

pattern a pattern number

This function sets the text color of cell or range to the specified color and optional pattern. The color can be specified by a color constant color or with red, green, and blue values (r, g, b) between 0 and 1. For a list of color constants, see "Color constants". The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setcolor(a1,BLACKCOLOR)

setcolor(a1:b7,0,0.5,0.5)

setcolor(myrange,MAGENTACOLOR,53)

SETCOLSIZE

Sets the size of the specified columns.

SETCOLSIZE(cell, num) or SETCOLSIZE(range, num)

cell any cell reference

range any worksheet range

num the size of the column(s) in points

This function sets the column(s) that contain cell or range to a size of num points.

Returns: cell or range

setcolsize(a1,72)

setcolsize(a1:b7,100)

setcolsize(myrange,53)

SETFMT or SETDISPLAYFMT

Sets the display format of the specified cell or range.

SETFMT(cell, format[, precision]) or

SETFMT(range, format[, precision])

cell any cell reference

range any worksheet range

format the size of the column(s) in points

precision the [optional] number of decimal places.

This function sets the display format of cell or range to the format specified by format and, optionally, to precision decimal places. For a list of formatting constants, see "Formatting Constants" .

Returns: cell or range

setfmt(a1:b10,CURRENCYFMT,2)

SETFONT

Sets the font of the specified cell or range.

SETFONT(cell, fontname, size) or

SETFONT(range, fontname, size)

cell any cell reference

range any worksheet range

fontname the name of a font

size the point size

This function changes the font in cell or range to the font fontname and point size size.

Returns: cell or range, or -1 on error

setfont(a1:b7,"ZapfChancery-MediumItalic",12)

SETPATTERN

Sets the text pattern for the specified cell or range.

SETPATTERN(cell, pattern) or

SETPATTERN(range, pattern)

cell any cell reference

range any worksheet range

pattern a pattern number

This function sets the text pattern of cell or range to pattern, using the current text color. The pattern can be specified with a number between 0 and 87.

Returns: cell or range

setpattern(a1,23)

setpattern(a1:b7,17)

setpattern(myrange,59)

SETPRECISION

Sets the precision of the specified cell or range.

SETPRECISION(cell, precision) or

SETPRECISION(range, precision)

cell any cell reference

range any worksheet range

precision the number of decimal places.

Sets the number of decimal places for cell or range to precision.

Returns: cell or range

setprecision(a1,2)

setprecision(a1:b7,3)

setprecision(myrange,0)

SETROWSIZE

Sets the size of the specified rows.

SETROWSIZE(cell, num) or SETROWSIZE(range, num)

cell any cell reference

range any worksheet range

num the size of the row(s) in points

This function sets the row(s) that contain cell or range to a size of num points.

Returns: cell or range

setrowsize(a1,72)

setrowsize(a1:b7,100)

setrowsize(myrange,53)

SETTEMPLATE

Sets the style template of the specified cell or range.

SETTEMPLATE(cell, template) or

SETTEMPLATE(range, template)

cell any cell reference

range any worksheet range

template a style template number

Sets the style template for cell or range to template. template can be an integer between 1 and 8, inclusive. For more information about style templates, see "Style Template sub-menu" .

Returns: cell or range

setrowsize(a1,1)

setrowsize(a1:b7,6)

setrowsize(myrange,3)

SETVERTALIGN

Sets the vertical text alignment of the specified cell or range.

SETVERTALIGN(cell, alignment) or SETVERTALIGN(range, alignment)

cell any cell reference

range any worksheet range

alignment a vertical alignment constant

This function vertically aligns the text in cell or range according to alignment. For a list of alignment constants, see "Alignment Constants".

Returns: cell or range

setalign(a1,TOPALIGN)

setalign(a1:b7,TOPALIGN)

setalign(myrange,BOTTOMALIGN)

SMARTCOLSIZE

Smartsizes the columns of the specified cell or range.

SMARTCOLSIZE(cell) or SMARTCOLSIZE(range)

cell any cell reference

range any worksheet range

This function sets the column(s) that contain cell or range to the best column size for the data they contain.

Returns: cell or range

smartcolsize(a1)

smartcolsize(a1:b7)

smartcolsize(myrange)

SMARTROWSIZE

Smartsizes the rows of the specified cell or range.

SMARTROWSIZE(cell) or SMARTROWSIZE(range)

cell any cell reference

range any worksheet range

This function sets the row(s) that contain cell or range to the best row size for the data they contain.

Returns: cell or range

smartrowsize(a1)

smartrowsize(a1:b7)

smartrowsize(myrange)

UNHIDECOL

Unhides the specified columns.

UNHIDECOL(cell) or UNHIDECOL(range)

cell any cell reference

range any worksheet range

This function unhides any hidden columns in cell or range.

Returns: cell or range

unhidecol(a1)

unhidecol(a1:b7)

unhidecol(myrange)

UNHIDEROW

Unhides the specified rows.

UNHIDEROW(cell) or UNHIDEROW(range)

This function unhides any hidden rows in cell or range.

Returns: cell or range

unhiderow(a1)

unhiderow(a1:b7)

unhiderow(myrange)

VBREAK

Sets a vertical page break.

VBREAK(cell) or VBREAK(range)

cell any cell reference

range any worksheet range

Sets a vertical page break immediately after cell or range.

Returns: cell or range

vbreak(a1)

vbreak(a1:b7)

vbreak(myrange)

 

Also go to:

Index help

Contents help