(C) 2012 - 2024 by Mourad Louha · All rights reserved.
 Privacy  ·  Imprint

CELLE

The function CELL() returns information about the formatting, location, or contents of a cell.

Syntax

FunctionArguments
CELLInfotypeA text value that specifies what type of cell information you want to return. The following list shows the possible values of the Infotype argument and the corresponding results.
ReferenceAn optional reference to the cell that you want information about.

Translation of the possible values for the argument 'Infotype'

The translations for this argument are available in 24 languages. However, the english names for the argument values can be used in each language in Excel. This is especially useful, if you plan to use your workbook in an international environment.

LanguageEnglishTranslation
Catalanaddressdirección
colcolumna
colorcolor
contentscontenido
filenamenombrearchivo
formatformato
parenthesesparentesis
prefixprefijo
protectproteger
rowfila
typetipo
widthancho
Croatianaddressadresa
colstupac
colorboja
contentssadržaj
filenamenaziv.datoteke
formatoblik
parentheseszagrade
prefixprefiks
protectzaštiti
rowredak
typevrsta
widthširina
Czechaddressodkaz
colsloupec
colorbarva
contentsobsah
filenamenázevsouboru
formatformát
parentheseszávorky
prefixprefix
protectzámek
rowřádek
typetyp
widthšířka
Danishaddressadresse
colkolonne
colorfarve
contentsindhold
filenamefilnavn
formatformat
parenthesesparenteser
prefixforanstillet
protectbeskyt
rowrække
typeværditype
widthbredde
Dutchaddressadres
colkolom
colorkleur
contentsinhoud
filenamebestandsnaam
formatnotatie
parentheseshaakjes
prefixvoorvoegsel
protectbescherming
rowrij
typetype
widthbreedte
Finnishaddressosoite
colsarake
colorväri
contentssisältö
filenametiedostonnimi
formatmuoto
parenthesessulkeet
prefixetuliite
protectsuojaus
rowrivi
typetyyppi
widthleveys
Frenchaddressadresse
colcolonne
colorcouleur
contentscontenu
filenamenomfichier
formatformat
parenthesesparentheses
prefixprefixe
protectprotege
rowligne
typetype
widthlargeur
Galicianaddressenderezo
colcol
colorcor
contentscontidos
filenamenomeficheiro
formatformato
parenthesesparénteses
prefixprefixo
protectprotexer
rowfila
typetipo
widthlargura
Germanaddressadresse
colspalte
colorfarbe
contentsinhalt
filenamedateiname
formatformat
parenthesesklammern
prefixpräfix
protectschutz
rowzeile
typetyp
widthbreite
Hungarianaddresscím
coloszlop
colorszín
contentstartalom
filenamefilenév
formatforma
parentheseszárójelek
prefixelőtag
protectvédett
rowsor
typetípus
widthszéles
Italianaddressindirizzo
colcol
colorcolore
contentscontenuto
filenamenomefile
formatformato
parenthesesparentesi
prefixprefisso
protectproteggi
rowriga
typetipo
widthlarghezza
Kazakhaddressмекенжай
colбаған
colorтүс
contentsмазмұны
filenameфайлатауы
formatпішім
parenthesesжақшалар
prefixпрефикс
protectқорғаныс
rowжол
typeтүр
widthені
Koreanaddressaddress
colcol
colorcolor
contentscontents
filenamefilename
formatformat
parenthesesparentheses
prefixprefix
protectprotect
rowrow
type종류
widthwidth
Norwegianaddressadresse
colkol
colorfarge
contentsinnhold
filenamefilnavn
formatformat
parenthesesparenteser
prefixprefiks
protectbeskytt
rowrad
typeverditype
widthbredde
Polishaddressadres
colkolumna
colorkolor
contentszawartość
filenamenazwa_pliku
formatformat
parenthesesnawiasy
prefixprefiks
protectochrona
rowwiersz
typetyp
widthszerokość
Portuguese, Braziladdressendereço
colcol
colorcor
contentsconteúdo
filenamenome.arquivo
formatformato
parenthesesparênteses
prefixprefixo
protectproteger
rowlin
typetipo
widthlargura
Portuguese, Portugaladdressendereço
colcol
colorcor
contentsconteúdo
filenamenome.ficheiro
formatformato
parenthesesparênteses
prefixprefixo
protectproteger
rowlin
typetipo
widthlargura
Russianaddressадрес
colстолбец
colorцвет
contentsсодержимое
filenameимяфайла
formatформат
parenthesesскобки
prefixпрефикс
protectзащита
rowстрока
typeтип
widthширина
Slovakaddressadresa
colstĺpec
colorfarba
contentsobsah
filenamenázovsúboru
formatformát
parentheseszátvorky
prefixvloženýznak
protectchrániť
rowriadok
typetyp
widthšírka
Slovenianaddressaddress
colsto
colorcolor
contentscontents
filenamefilename
formatformat
parenthesesparentheses
prefixprefix
protectprotect
rowvrstica
typetype
widthširina
Spanishaddressdireccion
colcolumna
colorcolor
contentscontenido
filenamenombrearchivo
formatformato
parenthesesparentesis
prefixprefijo
protectproteger
rowfila
typetipo
widthancho
Swedishaddressadress
colkol
colorfärg
contentsinnehåll
filenamefilnamn
formatformat
parenthesesparenteser
prefixprefix
protectskydd
rowrad
typetyp
widthbredd
Turkishaddressadres
colsüt
colorrenk
contentsiçerik
filenamedosyaadi
formatbiçim
parenthesesayraç
prefixönek
protectkoruma
rowsat
typetür
widthgenişlik
Ukrainianaddressадреса
colстовпець
colorколір
contentsвміст
filenameім`я_файлу
formatформат
parenthesesдужки
prefixпрефікс
protectзахист
rowрядок
typeтип
widthдовжина