View Archives - Excel-Help

Mar42023 by excelhelp13No Comments

CEILING Function in Excel.

Menu Bar, View

The CEILING Function Rounds a Number Up to its Nearest Multiple of Significance. CEILING Function helps to round up the numbers as per the requirement. Syntax: =CEILING(Number,Significance) Arguments: Number: The value that you want to Round Up. Significance: The Multiple that you want to Round Up. See the Examples in blow Image.

Jun162022 by excelhelp13No Comments

Hide Several Numbers in a Cell.

tips & Tricks, View

EXAMPLE : Suppose you have a list of some mobile numbers in your worksheet. You don’t want that list to be easily accessible to anyone. So you can hide some digits of all those mobile numbers in excel. STEPS : Select Cell or Range.Right Click on it.Click on Format Cells… 4. Click on Number tab, 5. Click on Custom. 6. In the Type box, Type one of the following options as per your requirement. 7. Click OK 8. See the Result in below Image Unhide Several Numbers in a Cell. STEPS : Select Cell or Range.Right Click on it.Click on Format Cells…Click on Number tab.Click on Custom.Select General from the Drop-Down.Click OK 8. See the Result in below Image

Jun122022 by excelhelp13No Comments

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 ...

Jun122022 by excelhelp13No Comments

Superscript Effect in Excel

tips & Tricks, View

Superscripts appear above the normal line of type. They’re commonly used to symbolize exponents, footnotes, ordinal indicators, and trademarks. How to Insert Superscript Effect in Excel ? For Example:- X2 STEPS : 1. Type X2 in cell B3. 2. Select 2 From X2. 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 in Superscript box. 6. Click OK. How to Remove superscript Effect in Excel ? Select the data from which you want to remove the superscript effect.Right Click on it >> format cell… or Click Home tab >> format >> Format cell… or right click on any cell >> Format Cell… 4. Click on font tab >> font effect...