What are the basic Excel formulas?

What are the basic Excel formulas?

Select the cell or cells that contain the numbers you want to format. Click the Home tab. Click in the Number Format list box and choose a format that displays decimal places, such as Number or Percentage. Excel formats the numbers in your chosen cells.

How do I format data in Excel?

The FORMAT function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

How do I enable cell formatting in Excel?

Number formats are used to control the display of cell values that contain numeric data. This numeric data can include things like dates, times, costs, percentages, and anything else expressed as a number. … To apply a number format, just select one or more cells and choose a format.

How do I make lines bold in Excel?

Click on the Fill Handle , which is located in the bottom right cell of the selected cells. Drag the Fill Handle for as many rows or columns as desired.

How do I center the contents of a cell in Excel?

Right-click and then select "Format Cells" from the popup menu. When the Format Cells window appears, select the Alignment tab. Click on "Center Across Selection" in the drop-down box called Horizontal. Now when you return to your spreadsheet, you should see the text centered across the cells that you selected.