Tuesday, December 3

Tag: Format data in excel

Subscript Effect in Excel

Subscript Effect in Excel

tips & Tricks, View
Subscripts are placed below the baseline. They’re usually used in chemistry to illustrate the molecular structure of chemical compounds such as water (H2O). How to apply Subscript effect in excel ? For Example:- H2O STEPS : 1. Type H2O in Cell B2. 2. Select 2 From H2O. 3. Right click on it, and then click Format Cells (or press Ctrl + 1). 4. The 'Format Cells' dialog box appears. 5. Font tab >> Effects >> Check Subscript button. 6. Click OK. How to Remove Subscript effect in excel? STEPS : 1. Select the data from which you want to remove the Subscript effect. 2. Right Click on it >> format cell… 3.The format cell dialog box will open. 4. Click on font tab in format cell dialog box >> font effect 5. Remove ...
Strikethrough Effect in Excel

Strikethrough Effect in Excel

Home Menu, Menu Bar
Strikethrough  Effect is Useful for drawing a line in the center above the data / text in the cell to mark it as a completed or to display as depricated or non use as per the needs vary. How to Insert Strikethrough Effect in Excel ? For Example:- excelhelp.in Steps:- Select DataClick Home tab > format > Format cell… or right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectCheck on Strikethrough box.Click OK How to Remove Strikethrough Effect in Excel ? Select the data.Click Home tab > format > Format cell… OR right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectUnCheck on Strikethrough box.Click OK ...