wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
This article has been viewed 71,092 times.
Learn more...
Knowing how to format your spreadsheet in Excel, the cells in particular, can really help you improve not just the aesthetic perspective of your document, but also its effectiveness in providing relevant information to the viewers of the files. Each cell in Microsoft Excel can be modified and formatted to follow your specific preferences.
Steps
-
1Open your Microsoft Excel. Click the “Start” button on the lower-left corner of your screen and select “All Programs” from the menu. Inside, you’ll find the “Microsoft Office” folder where Excel is listed. Click on Excel.
-
2Select the specific cell or group of cells that you want to format. Highlight it using your mouse cursor.Advertisement
-
3Open the Format Cells window. Right-click on the cells you’ve selected and select “Format Cells” from the pop up menu to access the “Format Cells” window.
-
4Set the desired formatting options you want for the cell. There are six formatting options that you can use to customize a cell or group of cells:
- Number – Defines the format of numerical data entered on the cells such as dates, currency, time, percentage, fraction and more.
- Alignment – Sets how the data will be visually aligned inside each cells (left, right or centered).
- Font – Sets all the options related to text fonts such as styles, sizes and colors.
- Border – Improves the visual appearance of each cell by adding definite lines (borders) around a cell or group of cells.
- Fill – Sets the background color and pattern formats of each cell on the spreadsheet.
- Protection – Adds security to cells and data contained inside it by hiding or locking the selected cells or group of cells.
-
5Save. Click on the “OK” button at the lower right corner of the “Format Cells” window to save any changes you’ve made and apply the formats you’ve set to the selected cells.
About This Article
To format a cell in Microsoft Excel, start by highlighting the specific cell you want to format. Then, right-click on the cell and click on "Format Cells." Choose whatever formatting you want for the cell from the different options, then click "Okay." That's all there is to it! For a step-by-step walkthrough with pictures, check out the full article below!
