Thursday, December 3, 2009

Seventh Lesson Of Ms-Excel (Insert)

Row allows adjustment of the row height including an auto fit feature. It also allows hiding of rows

Column allows you to change column width manually or withy auto fit it also slows gliding of column

Sheet allows the renaming hiding (and un hiding) of the worksheet

Auto format apply Excel’s own specialized formatting to your selected cells

Conditional formatting applies formatting to cells based on conditions you specify

Style allows you to modifying create formatting styles for your worksheet

Number allows you to choose how to display numerical values for example as currency dates or percentages

Border allows the selected cell to be given a variety or borders

Protections allows the worksheet to be locked and /or hidden

Alignment text can be rotated wrapped and aligned vertically or

Font allows changes to font style size and other formatting option

Pattern allows the selected cells to be given a variety of colors and / or patterns

Seventh Lesson Of Ms-Excel (Insert)

Row allows adjustment of the row height including an auto fit feature. It also allows hiding of rows

Column allows you to change column width manually or withy auto fit it also slows gliding of column

Sheet allows the renaming hiding (and un hiding) of the worksheet

Auto format apply Excel’s own specialized formatting to your selected cells

Conditional formatting applies formatting to cells based on conditions you specify

Style allows you to modifying create formatting styles for your worksheet

Number allows you to choose how to display numerical values for example as currency dates or percentages


Using The Help Topic Pane

F1

Display the Help window if the Assistant is turned off (if the Assistant is turned on, F1 displays the Assistant balloon).

F6

Switch between the Help topic and the Contents, Answer Wizard, Index pane

TAB

Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic

SHIFT+TAB

Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article

ENTER

Perform the action for the selected Show All, Hide All, hidden text, or hyperlink

ALT+O

Display the Options menu to access any Help toolbar command

ALT+O, and then press T

Hide or show the pane with the Contents, Answer Wizard, and Index tabs

ALT+O, and then press B

Display the previously viewed topic

ALT+O, and then press F

Display the next topic in a previously displayed sequence of topics

ALT+O, and then press H

Return to the specified home page

ALT+O, and then press S

Stop the Help window from opening a Help topic (useful if you want to stop a Web page from downloading)

ALT+O, and then press I

Open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings

ALT+O, and then press R

Refresh the topic (useful if you have linked to a Web page)

ALT+O, and then press P

Print all topics in a book or a selected topic only

ALT+F4

Close the Help window