Excel Office 365 Cells Options – A Complete Guide for You!!
Tags: cellsoptionsinexcelo, excelpreface, exceltutorials
Published: 2020-12-15 09:19:49

---
title: Excel Office 365 Cells Options – A Complete Guide for You!!
published: true
date: 2020-12-14 12:18:50 UTC
tags: CellsOptionsinExcelO,ExcelPreface,ExcelTutorials
canonical_url: https://geekexcel.com/excel-cells-options/
---

Here, we come up with the various options available for **formatting cells in Excel**. With the help of these options, you can make data good and attractive in the Worksheet. After formatting data, it will be outstanding while comparing with other data in your worksheet.

In this tutorial, we will give you an outline of what are the **Cells Options available in Excel Office 365**.
## Format Excel Cells Options:

- There are plenty of **[formatting options](https://geekexcel.com/quick-shortcuts-for-formatting-options-in-ms-excel-365/)** available in Excel.
- Use the following options to make your cell data looking awesome.
- We are going to see options like **[changing number format](https://geekexcel.com/keyboard-shortcut-to-apply-number-format-in-excel-365/), [alignment format](https://geekexcel.com/how-to-top-align-a-text-in-microsoft-excel-365/), font format, [border format](https://geekexcel.com/easy-shortcuts-for-border-options-in-microsoft-excel-365/), fill format,** and **[protection](https://geekexcel.com/excel-office-365-protection-options-a-complete-guide/).**

## Changing Number Format:

Microsoft Excel applies the **General number format** for every workbook you use currently. It is the default setting in Excel. The General format cells have no specific number format. If you want to **change** this format to the **Number format**. Kindly, follow the below steps.

- First, you need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) and **enter a value in** any **cell** in the worksheet.
- For example, we give the number **4344 in cell B3**.
- Refer to the below image.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-a-cell-2.png)<figcaption id="caption-attachment-19605">Select a cell</figcaption>

- Then, you need to **select** the **input cell,** then **right-click** on the **B3 Cell.**
- You need to **select** the [**Format Cells**](https://geekexcel.com/shortcut-to-format-almost-anything-in-microsoft-excel-365/) option from the menu.

![Select the Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-the-Format-Cells-option.png)<figcaption id="caption-attachment-19606">Select the Format Cells option</figcaption>

- It will display the **Format Cells window.**
- On the **Number Tab, select any one** of the **options** given in the **Category** section. Here, we **select** the **[Currency format](https://geekexcel.com/simple-shortcut-to-apply-currency-format-in-ms-excel-365/).**
- After selecting the **Currency** option, it will show the result in the **Sample** section.

![Format Cells Window](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Format-Cells-Window.png)<figcaption id="caption-attachment-19607">Format Cells Window</figcaption>

- At last, you need to **click** the **OK** button to get the result.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Output-18.png)<figcaption id="caption-attachment-19608">Output</figcaption>

## Alignment Format:

You can easily **align the content** in the cells to the top, bottom, or center with the help of the **Format Cells** Dialog box or Alignment group in the **Home Tab.**

### Way -#1

- You need to **enter a value** in any cell in the worksheet.
- Here, we **enter** the **text** string **“GEEK EXCEL”** in **cell B3.**

![Enter a value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-25.png)<figcaption id="caption-attachment-19610">Enter a value</figcaption>

- Then, you need to **right-click** on **cell B3** and then **select** the **Format Cells** option from the menu list.

![Select the Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/a-3.png)<figcaption id="caption-attachment-19613">Select the Format Cells option</figcaption>

- It will display the [**Format Cells Dialog box**](https://geekexcel.com/shortcut-to-format-almost-anything-in-microsoft-excel-365/).
- On the **Alignment Tab,** You need to **select** the **“[top](https://geekexcel.com/how-to-top-align-a-text-in-microsoft-excel-365/)“, “[left](https://geekexcel.com/easy-keyboard-shortcut-to-align-left-in-ms-excel-365/)“,** or **“[right](https://geekexcel.com/simple-keyboard-shortcut-to-align-right-in-ms-excel-365/)“** option under the **Text alignment** section.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Click-the-OK-button-1.png)<figcaption id="caption-attachment-19616">Click the OK button</figcaption>

- Finally, **hit** the **OK** button.
- Now, you will see that the **text alignment of cell B3 will be aligned** to the center position as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-16.png)<figcaption id="caption-attachment-19617">Output</figcaption>

### Way -#2

- You can also change the alignment of content through an **alignment group** in the **Home Tab.**
- Just **click on the alignment option** that you want to apply under the Alignment group.

![Home Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-15.png)<figcaption id="caption-attachment-19618">Home Tab</figcaption>

## Font Format:

To change the font format (**[change font style](https://geekexcel.com/how-to-change-font-style-in-microsoft-excel-365/), [font color](https://geekexcel.com/how-to-change-font-color-in-microsoft-excel-365/), [font size](https://geekexcel.com/how-to-change-font-size-in-microsoft-excel-365/)**) in Excel, follow the below steps.

### Way -#1

- You need to enter one text value in any cell on the worksheet.
- For example, we enter “ **Microsoft Excel** ” in **cell B2.**

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-15.png)<figcaption id="caption-attachment-19619">Example</figcaption>

- Then, you need to **right-click** on **cell B2**  and then **select** the **Format Cells** option from the menu list.

![Select the Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/a-3.png)<figcaption id="caption-attachment-19613">Select the Format Cells option</figcaption>

- It will display the **Format Cells Dialog box**.
- **Click** the **Font Tab,** You can select the **font, style, size,** and **color** to change the format of the selected text.

![Font Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-13.png)<figcaption id="caption-attachment-19620">Font Tab</figcaption>

- Then, **click** the **OK** button to apply the formatting. You will get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-13.png)<figcaption id="caption-attachment-19621">Result</figcaption>

### Way -#2

- To change the **font type,** you just need to **click** the **Font drop-down** list under the **Font group.**

![Font Type Drop-down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/7-9.png)<figcaption id="caption-attachment-19622">Font Type Drop-down list</figcaption>

- If you want to **change** the **font size,** you need to **click** the **font size drop-down list** in the **Font group** under the **Home** Tab.

![Font Size](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/8-8.png)<figcaption id="caption-attachment-19623">Font Size</figcaption>

- **[Font styles](https://geekexcel.com/how-to-change-font-style-in-microsoft-excel-365/):** There are **four font styles** that you can use in Excel. They are **Regular, Italic, Bold, Bold Italic.**
- You can just click the “ **B** “, “ **_I_** “, “ **U** ” command to change the font style.

![Font styles](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/9-7.png)<figcaption id="caption-attachment-19624">Font styles</figcaption>

## Border Format:

If you want to draw a [**border around a cell**](https://geekexcel.com/easy-shortcut-to-add-or-remove-border-left-in-excel-365/) or a **range of cells** , do as follows.

- You need to **select one cell ** and then **right-click** on the cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-13.png)<figcaption id="caption-attachment-19621">Result</figcaption>

- Then, you need to **select** the **Format Cells** option from the drop-down list.

![Select the Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/a-3.png)<figcaption id="caption-attachment-19613">Select the Format Cells option</figcaption>

- It will open the [**Format Cells window**](https://geekexcel.com/shortcut-to-format-almost-anything-in-microsoft-excel-365/).
- On the **Border Tab,** you need to **select** the **line style** and **borders** as you wish and **click** the **OK** button to see the result.

![Border Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/10-6.png)<figcaption id="caption-attachment-19625">Border Tab</figcaption>

- In the below image, you will see the result.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/11-6.png)<figcaption id="caption-attachment-19626">Output</figcaption>

- You can also **click** the **Borders drop-down list** in the **Font** group under the **Home Tab.**

![Borders drop-down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/12-4.png)<figcaption id="caption-attachment-19627">Borders drop-down list</figcaption>

## Fill Format:

- To [**change the background color**](https://geekexcel.com/how-to-change-background-color-in-microsoft-excel-365/) of a cell, you need to **click** the **[Fill color](https://geekexcel.com/excel-shortcut-to-choose-a-fill-color-in-office-365-quick-way/) drop-down** list in the **Font** group under the **Home Tab.**

![Fill drop-down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/13-1.png)<figcaption id="caption-attachment-19628">Fill drop-down list</figcaption>

- In another way, you can **change** the **Fill tab** from the **Format Cells dialog box.**

![Format Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/14-1.png)<figcaption id="caption-attachment-19629">Format Cells dialog box</figcaption>

## Cell Protection:

If you want to [protect cells](https://geekexcel.com/how-to-protect-the-cell-in-microsoft-excel-365/), follow the below instructions.

- First, you need to **select the cells**  **or a range** that you want to protect.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/15-1.png)<figcaption id="caption-attachment-19630">Select the range</figcaption>

- Then, **right-click** on it and **select** the **Format Cells** option from the menu.
- It will display the **Format Cells Dialog Box**.

![Select the Format Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/a-3.png)<figcaption id="caption-attachment-19613">Select the Format Cells option</figcaption>

- On the **[Protection](https://geekexcel.com/excel-office-365-protection-options-a-complete-guide/) tab,** you need to **check** the **[Locked](https://geekexcel.com/configure-cells-to-be-locked-or-unlocked-when-protecting-worksheet/) checkbox.**
- Now, **click** the **OK** button.

![Protection tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/16-1.png)<figcaption id="caption-attachment-19631">Protection tab</figcaption>

- Go to the **Review Tab,** and **select** the [**Protect Sheet**](https://geekexcel.com/how-to-password-protect-a-sheet-in-excel-office-365/) button.

![Review Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/17-1.png)<figcaption id="caption-attachment-19632">Review Tab</figcaption>

- It will open the **Protect Sheet dialog box.**
- Then, you need to **enter**  **a password** in the given text box.

![Enter a password](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/18-1.png)<figcaption id="caption-attachment-19633">Enter a password</figcaption>

- You need to **re-enter the password** and **hit** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/20-1.png)<figcaption id="caption-attachment-19634">Click the OK button</figcaption>

- If you want to make changes, you need to **click** the **Unprotect Sheet** button in the **REVIEW Tab.**

![Unprotect Sheet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/21-1.png)<figcaption id="caption-attachment-19635">Unprotect Sheet</figcaption>

- Then, you need to **enter the password** in the **[Unprotect Sheet](https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/) Dialog box.**

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/22-1.png)<figcaption id="caption-attachment-19636">Click OK button</figcaption>

## A Quick Summary:

In the above tutorial, we guided you to know the **Cells Options available in Excel Office 365**. Stay connected to get instant updates and leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Excel Office 365 Data Validation Options – Simple Instructions!!](https://geekexcel.com/excel-office-365-data-validation-options/)
- [Excel Office 365 Worksheet Options ~ With Clear-Cut Examples!!](https://geekexcel.com/wp-admin/post.php?post=19290&action=edit)