Format-Cell

Insert Check Mark in Excel You can insert a check mark (aka. tick mark) in Excel by using the font “Wingdings 2” or inserting a symbol. These static symbols are useful to make an eye-catching to-do list. 1. Select cell D3 and press SHFT + P on your keyboard. 2. Select Font “Wingdings 2” on […]

Superscript and Subscript in Excel Superscript and subscript in Excel are formatting styles wherein a character is slightly above and below the baseline, respectively. Here is an example: (a) superscript- B2 (b) subscript- B2. 1. Double-click cell B2 to get the cursor inside the cell. 2. Select the value 2, right-click, and then click “Format

Strikethrough Text in Excel Keyboard Shortcut | Partial Strikethrough | Add a Button Strikethrough text in Excel is a formatting option that draws a horizontal line through a value in a cell. This style is used to indicate the deletion of an error or the removal of text in a draft. This is an extra

Merge Cells in Excel If you like to put a label representing more than one cell, you need to merge multiple cells into one. By default, Excel will keep the information of the first cell and the rest of the cells’ information gets deleted. To merge cells, follow the steps below. In the table below,

Wrap Text in Excel Using Line Break Wrap text in Excel is a useful command to display long text in a single cell. In this lesson, we will show two ways to wrap text – automatic wrapping and using a line break. Wrap Text Automatically 1. Select cell B4. 2. Click “Wrap Text” on the

Create Cell Style in Excel By default, Excel offers several cell styles to choose from. But, you can also create your own cell style. In this lesson, we will learn how to use Excel’s built-in cell style and then create on our own. 1. Select cell B3. 2. Choose a cell style on the Home

Format Painter in Excel One of the most useful time-saving tools, yet most overlooked, is the format painter in Excel. It copies all the format of a cell and pastes it into the cell you want. Follow the steps below to know how it works. In cell B3, we have two different formats- (a) the

Custom Number Format in Excel Example-1 | Example-2 | Example-3 Although Excel offers many built-in number formats for users, you can still create your own custom number format. Example-1 To maintain a fixed length of 6 to all values that you enter in cells, you need to add leading zeros to the numbers that are

Convert Numbers to Text in Excel Example-1 | Example-2 | Example-3 Excel generally displays all text values aligned on the left and numeric values aligned in right. Below are a few examples to convert numbers to text format. Example-1 Select range C3:C7 and change the cell format style to Text. Example-2 Type in an apostrophe

Convert Text to Number Example-1 | Example-2 | Example-3 | Example-4 Generally speaking, Excel displays all text values aligned on the left and numeric values aligned on right. Below are a few examples to convert text to numbers. Example-1 Select range C3:C7 and change the cell format style to General. Example-2 You can also click