Formatting & Ranging in MS Excel

Formatting & Ranging in MS Excel

What is Formating in MS Excel

Formatting allows you to change a cell’s design in professional lay based on the information within the cell.
To get started, highlight the group of cells you want to use formatting on. Then choose “Formatting” from the Home menu and select your logi.A window will pop up that prompts you to provide more information about your formatting rule. Select “OK” when you’re done, and you should see your results automatically appear.

Copy and Paste a Range

The following explains how to copy and paste a range of data.

  1. Highlight the cell range that you wish to copy.

    2. On the Home tab of the ribbon, click the Copy button.

    3. Left-click in the beginning cell where you want the range to be copied.

    4. On the Home tab of the ribbon, click the Paste button.

    5. The data will be copied into the destination cells.

Leave a Reply

Your email address will not be published. Required fields are marked *