Download ArticleDownload Article
How.com.vn 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 91,133 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.
Quick Steps
- Highlight the cells you want to format with your mouse.
- Right click the cells and select Format Cells.
- Select your desired formatting options and click OK to save.
Steps
Download Article
Open 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.
Select the specific cell or group of cells that you want to format. Highlight it using your mouse cursor.Advertisement
Open 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.
Set 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.
Save. 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.
Expert Q&A
Tips
- Avoid using formats that are visually irritating such as fill colors that don’t compliment the colors of the fonts, or artistic font styles that are not appropriate for formal documents like the spreadsheet.Thanks
- You can use this method to format cells of new files or existing spreadsheet documents you currently have.Thanks
- When formatting cells in Excel, do it in groups (either by rows or columns) so that your spreadsheet will have a clean and uniform appearance.Thanks
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!
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
