Pattern
tab:-
Locked
Hidden
Locking cell or hiding formulas has no effect unless the
worksheet is protected to protect the sheet toolbar – protection – protect
sheet (a password is optional)
After protecting a sheet the locked & hidden cells data
or formula is not visible formula bar where data or formula of a cell is shown.
Row:-
Ti format the selected rows
Heights: - to increase the heights of the selected row, more than
font size.
Auto fit: - to fit the extra height of the row to the size of the
font or content in it .
Hide = hide the selected row and rows
Unhide = unhide the hided row/rows; this will unhide at the same
place where you hide the row/ rows.
Column = to
format the selected columns
Width: - to
increase the column width of the selected cells. Open dialog box
Auto fit to selection
= fit to the length of the text in the cell
Hide : - to hide
the selected columns
Unhide : - to
unhide the hided columns
Standard width: -
it will display the actual or default width of the columns in a small dialog
box.
Sheet
Rename = To rename sheet tab
Hide = hide the
current sheet but can’t hide the last sheet
Unhide = unhide
the hided sheet.,
Background = to
set background picture to sheet, picture inserted on full sheet in form of tiles.
It is not printable.
Tab color = to
set tab color of sheet tab.
Auto format
To set auto format
style of the per define format from the dialog box. Choose format style from
the list and set on the selected cell not on the full sheet.
It sets font style, cell back color and size of the font.
Style
You can set the font, number format background color,
borders patterns style give it name and can be reused wherever in the book not
work outside the book.
This style is applied on the selected cells to apply on
other cells, select the cells format menu – style – open dialog box choose name
– ok
Conditional
formatting: -
To
format numerical data on set conditions. we can set maximum three conditions on
a single selected table .
No comments:
Post a Comment