Ticker

6/recent/ticker-posts

Header Ads Widget

Contact Us For Advertisement: 9858091920

Microsoft Excel E-Learning Day 4

 Tutor Chetan - Notes

Microsoft Office Package

MS Excel - Day 4

Day 4 - PDF File


# Format as table:

Format as table option is used to format the selected rows and columns as per need.

Steps:

1.   Select the rows and columns.

2.   Click on Home menu.

3.   Click on Format As table drop-down button

4.   Click on required formatting style.

 # Cell Style:

Cell Style option is used to change the style of the selected cells on the worksheet screen.

Steps:

1.   Select the required cell

2.   Click on Home menu.

3.   Click on Cell Style drop-down button.

4.   Click on required cell style.

 # Conditional Formatting:

Conditional Formatting option is used to format the selected worksheet data for given conditions

Steps:

1.   Highlight the worksheet data.

2.   Click on Home menu.

3.   Click on Conditional Formatting drop-down arrow button

4.   Click on New Rule.

5.   Select the Rule type

6.   Select the required logical operator and type the value and click on Format button.

7.   Choose the required formatting style.

8.   Click on ok.


Post a comment

0 Comments