Specify header/footer
page layout
page setup (Box)
header/footer
change the cell references
F4
formatting text
clean / trim
numbers as text
formatting numbers
numeric formatting
print
setups
fit sheet in one page
Set all margins
settings
customs margins
conditional formatting
home
Saving a template and Opening a template
save as: excel template
opening: personal
create personal list
file
options/ excel optins
advanced
edit custom lists
mark the cells
change integrated themes
layout
integrated themes
change colors
names in formulas
mark cell or range
define a name
directly on name box or name manager
takeover names from adjacent text
mark various cells and adjacent text
formulas: create form selection
dialog box: choosen text
trend calculation
= TREND( known_y's, [known_x's], [new_x's], [const])
trend line
diagram options
trendline
seperations of words - first word
=LEFT(Zelle;FIND(" ";Zelle)-1)
seperations of words - two following words
=MID(Zelle;FIND(" ";Zelle)+1;LEN(Zelle)-FIND(" ";Zelle))
Last changed2 years ago