excelhelp13, Author at Excel-Help

Jun122022 by excelhelp13No Comments

How to Change Gridline Color in Excel

tips & Tricks

Gridlines are displayed in a workbook with a default gray color that is applied automatically. If you want to change the Gridlines color, follow the steps given below: Click on File tab >> Options >> Advanced >> Grid Color.Select the color you want to use and click ok. To see the changes go back to the worksheet.

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

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

Jun122022 by excelhelp13No Comments

Align text in center without cell merge

tips & Tricks

Merge and center command is often used to bring headings to the center. But doing so sometimes causes problems in the use of certain features, formulas, functions of Excel. We have the solution. Headings can be brought to the center without the use of merge and center command. Follow the Steps below. STEPS : 1 Select cell range. 2 Right click on selected range 3 Click on format cell... 4. In the format cell dialogue box, click on alignment tab 5. Open horizontal selection drop-down 6. Select center across selection. 7. Click ok 8. See the result in below image.

Jun122022 by excelhelp13No Comments

Get Month name from Date as Text in Excel.

Text, tips & Tricks

To get the Month name from Date as text, you can use text function with a custom number format within excel.. Syntax:- (1) =text(date,"mmm") or (2) =text(date,"mmmm") NOTE: "mmm" – to get the first 3 letters of the name of the month."mmmm" – to get the full name of the month An Examples are shown in the image below.

Jun122022 by excelhelp13No Comments

Create diagonal line in cell

Home Menu, tips & Tricks

When you want to show to separate headings within a same cell (one for the row and one for the column), in that case you need to split a cell diagonally. Always remember that cell is a combination of row and column. For Example : Suppose you have data as per image shown below. Now suppose want to insert headings for both column and row in cell A3 for list of name and list of month. STEPS : Select cell A3.Right click on it and Click on format cells...In the format cell dialogue box, go on border tab.Click on diagonal line icon at the bottom right.Click ok. 6. See the result in below image. How to remove diagonal line in excel ? STEPS : Select the cell or cells from which you want to remove the diagonal line.Right click on selection and choose "F...

Jun92022 by excelhelp13No Comments

Hide the data of a specific cell in excel

tips & Tricks

Suppose you have a confidential data in your worksheet. you do not want to get it visible on the worksheet when other user using that sheet. If that the case then you can hide those confidential data by using custom number format. STEPS : Select data which you want to hide.Right click on it.Click on format cells... 4. In the format cell dialogue box, go on "Number" tab 5. Click "Custom" 6. Type ;;; (3 semicolon) in the type box. 7. Click ok. 8. See the Result in below Image. The Data of the Selected Cells are hidden. Unhide the data of a specific cell in excel STEPS : Select the cells whose data you want to Unhide.Right click on it.Click on format cells...In the format cell dialogue box, go on "Number" tab Click "Custom"Choose "General" fr...

Jun92022 by excelhelp13No Comments

Get the Day name from Date in Excel.

tips & Tricks

To get the Day name from Date, you can use text function with a custom number format. SYNTAX: (1) =text(date,"ddd") or (2) =text(date,"dddd") or (3) =text(date,"dd") Note : "ddd" – to get the first 3 letters of the name of the Day."dddd" – to get the full name of the Day"dd" - to get a Day number of the related month. An Examples are in the image below.

Jun92022 by excelhelp13No Comments

Insert multiple Columns in one Click in Excel.

Insert Menu, tips & Tricks

Usually Insert Column command insert only one column at one time. But you can insert multiple columns in one click in Excel. Follow the below mentioned steps. STEPS : Select the same number of columns as you want to insert. For example, if you want to insert 2 blank columns, select 2 columns.Right click on it.Click on insert. 4. Blank columns will be inserted above the selected columns. Note- if there is data in the selected columns, it’s ok. Because that data will not be deleted.

Jun92022 by excelhelp13No Comments

Insert multiple rows in one click

tips & Tricks

Usually Insert Row command Insert only one Row at One time. But you can Insert multiple Rows in one click in Excel. Follow the steps below. Usually insert row command is insert only one row at one time. But you can insert multiple rows in one click in Excel. Follow the steps below. STEPS: Select the same number of rows as you want to insert. For example, if you want to insert 4 blank rows, select 4 rows.Right click on it.Click on insert. 4. Blank rows will be inserted above the selected rows. Note- if there is data in the selected rows, it’s ok. Because that data will not get deleted.