OutlineCell Operation of ExcelMerge and Unmerge CellFill contents in CellExcel Grouping
◼ Cell Operation of Excel ◼ Merge and Unmerge Cell ◼ Fill contents in Cell ◼ Excel Grouping Outline
CellFunctionofExcelCell Function Can be used to retrieve informationabouta cell Can include contents,formatting,size,etcSyntax for the Cell function Cell(type, range)type is the type of information that you retrieve for type can be one of the followingvalues
◼ Cell Function ❑ Can be used to retrieve information about a cell ❑ Can include contents, formatting, size, etc ◼ Syntax for the Cell function ❑ Cell( type, range ) type is the type of information that you retrieve for ❑ type can be one of the following values Cell Function of Excel
Cell Functionof Excel (ll)ValueExplanation"address"Addressofthe cell. If the cell referstoarange,it isthefirst cell in therange."col"Columnnumberofthecell."color"Returns1ifthecolorisanegativevalue;Otherwiseitreturns0"contents"Contentsoftheupper-leftcell."filename"Filenameofthefilethatcontainsreference."format"Numberformat ofthecell"parentheses"Returns1if thecell isformattedwithparentheses; Otherwise,itreturns0"prefix"Label prefix forthe cell.*Returnsasinglequote(')ifthecell isleft-aligned.*Returnsadoublequote (")ifthecell isright-aligned.*Returnsacaret (^)ifthecelliscenter-aligned.*Returnsabackslash(V)ifthecell isfill-aligned.* Returns an emptytext value forall others."protect"Returns1ifthecell islocked.ReturnsOifthecell isnotlocked."row"Rownumberofthecell."type"Returns"b"if the cell is empty.Returns""ifthecell containsatextconstantReturns"v"forallothers"width"Columnwidth ofthecell,roundedtothenearest integer
Value Explanation “address” Address of the cell. If the cell refers to a range, it is the first cell in the range. "col" Column number of the cell. "color" Returns 1 if the color is a negative value; Otherwise it returns 0. "contents" Contents of the upper-left cell. "filename" Filename of the file that contains reference. "format" Number format of the cell. "parentheses" Returns 1 if the cell is formatted with parentheses; Otherwise, it returns 0. "prefix" Label prefix for the cell. * Returns a single quote (') if the cell is left-aligned. * Returns a double quote (") if the cell is right-aligned. * Returns a caret (^) if the cell is center-aligned. * Returns a back slash (\) if the cell is fill-aligned. * Returns an empty text value for all others. "protect" Returns 1 if the cell is locked. Returns 0 if the cell is not locked. "row" Row number of the cell. "type" Returns "b" if the cell is empty. Returns "l" if the cell contains a text constant. Returns "v" for all others. "width" Column width of the cell, rounded to the nearest integer. Cell Function of Excel (II)
SomeExamplesofCell FunctionB4ATechontheNet5.50%34Functions return based on spreadsheet above =Cell("col",A1) would return 1=Cell("address", A2) would return $A$2口=Cell("contents",A2) would return 0.0557
◼ Functions return based on spreadsheet above ❑ =Cell("col", A1) would return 1 ❑ =Cell("address", A2) would return $A$2 ❑ =Cell(“contents", A2) would return 0.055 Some Examples of Cell Function
OutlineCell Operation of ExcelMerge and Unmerge CellFill contents in CellExcel Grouping
◼ Cell Operation of Excel ◼ Merge and Unmerge Cell ◼ Fill contents in Cell ◼ Excel Grouping Outline