Data Formatting in Excel - Part 1 (Video at Below)
You will get to know about ~
Basic arrangement of data set in Excel
When organizing a basic data set in Excel, you should consider the following:
Use headings: Use the first row of your data set to add headings for each column. This will help you and others understand the data in the spreadsheet.
Enter data: Enter data in the appropriate cells under each heading. Make sure each row contains data for the same category or item.
Use formatting: Use formatting tools such as bold, italics, or shading to highlight important data or make headings stand out.
How to adjust row and column in Excel
You can adjust rows and columns in Excel to make your spreadsheet more readable and easier to work with. Here's how to adjust rows and columns:
Adjusting Row Height: To adjust the height of a row, select the row or rows you want to adjust, then hover your cursor over the boundary line between the row number and the row below it. When the cursor turns into a double-sided arrow, click and drag the boundary line up or down to adjust the row height. Alternatively, you can right-click on the selected row or rows and choose "Row Height" from the menu. Enter a new height value in the dialog box and click "OK."
Adjusting Column Width: To adjust the width of a column, select the column or columns you want to adjust, then hover your cursor over the boundary line between the column letter and the column to the right of it. When the cursor turns into a double-sided arrow, click and drag the boundary line left or right to adjust the column width. Alternatively, you can right-click on the selected column or columns and choose "Column Width" from the menu. Enter a new width value in the dialog box and click "OK."
AutoFit: If you want to adjust the row height or column width to fit the content automatically, select the row or column you want to adjust, then double-click on the boundary line between the row number or column letter and the row or column to the right or below it. Excel will automatically adjust the row height or column width to fit the content.
By adjusting rows and columns, you can make sure that your spreadsheet is easy to read and work with.
To add a row or column in Excel, follow these steps:
Adding a Row:
Select the row below where you want to add a new row.
Right-click and choose "Insert" from the menu, or go to the "Home" tab and click "Insert" in the Cells group.
Select "Entire Row" and click "OK."
A new row will be added above the selected row.
Alternatively, you can use the keyboard shortcut "Ctrl" + "+" to insert a new row.
Adding a Column:
Select the column to the right of where you want to add a new column.
Right-click and choose "Insert" from the menu, or go to the "Home" tab and click "Insert" in the Cells group.
Select "Entire Column" and click "OK."
A new column will be added to the left of the selected column.
Alternatively, you can use the keyboard shortcut "Ctrl" + "Shift" + "+" to insert a new column.
Once you've added a new row or column, you can enter data, apply formatting, or use formulas as needed
How to format boarder cells in Excel
Select the cells that you want to format.
Go to the "Home" tab and click on the "Borders" dropdown menu in the "Font" group.
Choose the type of border you want to apply to the cells. You can choose from different line styles, thicknesses, and colors.
To apply a border to all sides of the selected cells, choose "All Borders" from the menu.
To apply a border to specific sides of the selected cells, choose "More Borders" from the menu. In the Format Cells dialog box, go to the "Border" tab, and choose the style, color, and thickness of the border you want to apply. Under "Presets," you can choose to apply a border to specific sides of the cells, such as top, bottom, left, or right.
To remove a border from cells, select the cells and choose "No Border" from the Borders dropdown menu.
You can also use the formatting shortcuts on the Home tab. For example, to add a thick border around a cell, select the cell, and press "Ctrl" + "Shift" + "7" on the keyboard.
How to remove grid on sheet in Excel
To remove the gridlines in Excel, follow these steps:
Go to the "View" tab on the ribbon at the top of the screen.
In the "Show" group, uncheck the "Gridlines" checkbox.
The gridlines will disappear from the worksheet.
Alternatively, you can use the keyboard shortcut "Ctrl" + "Shift" + "8" to toggle the gridlines on and off.
Note that removing the gridlines only affects the appearance of the worksheet on your screen. The gridlines will still be printed if you choose to print the worksheet. To prevent gridlines from printing, you can go to the "Page Layout" tab on the ribbon, click on "Page Setup", go to the "Sheet" tab, and uncheck the "Gridlines" checkbox under the "Print" section.
How to colour Cells and Text in Excel
To color cells and text in Excel, follow these steps:
Select the cells or text you want to format.
To color the cells, go to the "Home" tab on the ribbon and click on the "Fill Color" button in the "Font" group. Choose the color you want to apply to the cells. Alternatively, you can right-click on the selected cells, choose "Format Cells," go to the "Fill" tab, and choose the color you want to apply.
To color the text, select the cells with the text you want to color, and then go to the "Home" tab on the ribbon and click on the "Font Color" button in the "Font" group. Choose the color you want to apply to the text. Alternatively, you can right-click on the selected cells, choose "Format Cells," go to the "Font" tab, and choose the color you want to apply to the text.
To apply a pattern to the cells, go to the "Home" tab on the ribbon and click on the "Fill Color" button in the "Font" group. Choose the "More Colors" option, and then select the "Patterns" tab. Choose the pattern you want to apply to the cells.
You can also use conditional formatting to automatically color cells based on certain conditions, such as if they contain a certain value or meet a certain criteria. To do this, select the cells you want to apply the conditional formatting to, go to the "Home" tab on the ribbon, and click on the "Conditional Formatting" button in the "Styles" group. Choose the type of formatting you want to apply, and then set the conditions for when the formatting should be applied.
0 Comments