|
![]() |
![]() |
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) |
||
|
||