Editing and Formatting in Microsoft Excel

Change font colors & background colors in the Excel file:

Let us learn through this video:

 

---

Uses of Percentage Function in Microsoft excel:

 

 

---

Uses of SUM Function in Microsoft Excel:

 

 

---

 

How to use chart in Microsoft Excel:

 

 

---

Pinning documents in Microsoft Excel:

1. Users can pin the recently used files.
2. This feature helps users quickly access recently used files.
3. The pin lists the files in chronological order.

 

Templates: A template is a pre-set format for a file.

• It is easier to make new files.
• Quick formatting saves time.
• Increases flexibility.
• Provides new ideas.
• Reduces human error.

Rows & Columns, Spreadsheet:

Rows: Rows run horizontally across the worksheet. The rows can be identified by their label, which is a number.

Columns: Columns run vertically across the worksheet. It can be identified by the label, which is a letter.

Cells: Cells can be identified by the small rectangular boxes where the user inserts the data. It is identified by the row number and column header. In this image, the address of the cell is A2, where “A” is the column and “2” is the row.

 

Ranges: A group of cells, when selected together, is known as a cell range. Cell range can be identified by referring to the first and last cells, which are separated by a colon, as you can see in the image below:

Sheet View, Zoom, and Input Data

Sheet View:

• Sheet views are an innovative way of letting you create customised views in an Excel worksheet without being disrupted by others.
• For instance, you can set up a filter to display only the records that are important to you.
• You can even set up multiple sheet views on the same worksheet.

 

Zoom:

• The Zoom command in View ribbon menu is used to get close-up view of the document.
• Users can zoom in or zoom out depending on their preference.
• Users can save those particular zoom settings.

 

Input Data: Users can use various methods to input data into a worksheet.

• Direct Input: The user can directly type data in the cell.
• Formula Bar: In the case of entering long equations or sentences, users can use the formula bar to enter the data in the cell. The formula bar can be located below the ribbon menu.
• Autofill: Auto-fill helps the user insert both text and numbers in the cells automatically. This function saves time for the user.

Page Layout

Page Layout:

• The Page Layout tab provides commands for their use, which helps them prepare the workbook.
• The commands help the user control the display of content on a printed page. This includes:

1. Page Orientation: 2. Margin Size

• The other page layout options available to the user are:

1. Print titles: 2. Page Breaks

 

Page Orientation: There are two page orientation options:

1. Landscape: It helps in making the orientation of the page horizontal. It works best with worksheets that have a lot of data in the columns.
2. Portrait: This mode helps in making the orientation of the page vertical. This mode works best with worksheets, which have most of the data in the rows.

                   1.              2.

 

Page Layout Command:

1. Margin Size:

• The margin in the workbook is the space between the content and the edge of the page.
• By default, the margin of the workbook is set to normal.
• Microsoft Excel includes a set of predefined margin sizes.
• If required, the user can adjust the margin to fit the data properly.

2. Page Breaks:

• The page break enables the user to print different sections of the workbook on separate pages.
• It can be both horizontal and vertical.

Formatting, Wrapping, and inserting Rows & Columns

Formatting Data: Users can format the data in the cells to draw attention to a specific part of the data. Basic formatting will be able to change the visualisation of the data. The user can perform the following functions:

• Change the font, font colour, and text alignment.
• Add or change cell borders and fill colours.
• Use cell styles.
• Adding specific formatting to text and numbers.

 

 

Wrapping text: If the user wants to enter a log sentence, a large set of numbers, or an equation in a cell, it cannot be viewed as the cell width is small. Using the function Wrap Text, the text will appear in multiple lines in a cell. The user can format the cells so that the text is wrapped automatically or manually enable Wrap Text.

 

Note: The user should adjust the column width and the row height to make the inserted wrapped text visible.

Inserting Rows and Columns: The user can add extra rows or columns if required in their worksheets. To insert a row or a column, the user must locate the cell group in the Home ribbon menu where the function is present.

Merge, Centerand Currency Formatting

Merge Cells: Merge can merge two or more cells as required. When the user merges one individual cell with another, the contents of the first cell will only be present, and the rest of the content available in the other cells merged with it will get deleted.

Note: Before entering data, merge the number of cells required.

 

Center Cells: The user can align the text inserted in multiple cells without merging cells. The text must be entered in the left-most cell of the selected range. The user must click the cell range and go to format cells from the pop-up menu, where the command Center Across Selection is under the Alignment tab.

Currency Formatting: Users use Currency Format to correctly display monetary values. In this format:

• Decimal points will be aligned with the column.
• A currency sign will appear next to the first digit in the cell.
• It will not be aligned with the other currency symbols in the column.

 

PRINT VIEW:-

Print View: Users can preview worksheet pages before printing. This helps the user avoid unexpected results or wasting pages.