What is formatting in ms Excel 2010?
Table of Contents
What is formatting in ms Excel 2010?
In Excel, the format cells is used to modify the formatting of cell numbers without modifying the actual number. With the help of the format cells, we can change the number, alignment, font style, Border style, Fill options, and Protection.
Where is format in Excel 2010?
To apply formatting using this dialog box, first select the cell or cell range to which you want to apply formatting. Then click the “Format” button in the “Cells” group on the “Home” tab in the Ribbon. Select the “Format Cells…” command from the button’s drop-down menu to display the “Format Cells” dialog box.
How do I format columns in Excel 2010?
Answer: Select the cells that you wish to format. Right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Number tab. In the Category listbox, select your format.
How do you format a worksheet in Excel 2010?
Apply Formatting in Excel 2010
- Number − You can set the Format of the cell depending on the cell content.
- Alignment − You can set the alignment of text on this tab.
- Font − You can set the Font of text on this tab.
- Border − You can set border of cell with this tab.
- Fill − You can set fill of cell with this tab.
How many styles Does Excel 2010 have?
42 built-
In Excel 2010, Microsoft promotes styles in Excel, adding a drop-down right on the Home tab offering 42 built-in styles as shown in Figure 1 (below).
How do I manage columns in Excel?
Select any cell in your table and click the Column Manager button. A list of all columns will appear on a pane. You can move columns in the worksheet by dragging them on the pane or by clicking the buttons. Besides, you can autofit the selected columns, delete and insert columns in a click.
What are the formatting tools in Excel?
Options available in the formatting toolbar
- Change the font.
- Change the size of the font.
- Change the font color.
- Make the text bold, italics, or underline.
- Change the alignment.
- Change the style to currency, percent, or comma.
- Increase or decrease the decimal and indent.
- Change the borders.
