tips & Tricks Archives - Page 2 of 3

Jun162022 by excelhelp13No Comments

Freeze Column and Row heading in excel.

tips & Tricks

When you work with large data in Excel, it is difficult to remember the headings of that data when scrolling around the sheet. The heading row or heading column or both can be frozen using the freeze pane. So that headings can be easily seen rather than scrolling over and over again. STEPS : To Freeze the Top Row Go to View tab >> Windows group >> click on freeze pane drop-down arrow.Click on Freeze Top Row. 3. Excel insert a thin line to show you where the frozen pane begins. To Freeze the first Column STEPS : Go to View tab >> Windows group >> click on freeze pane drop-down arrow.Click on Freeze first Column.Excel insert a thin line to show you where the frozen pane begins. 4. See the result in the image below. "Colu...

Jun162022 by excelhelp13No Comments

WordArt in Excel

Insert Menu, tips & Tricks

WordArt is a quick way to give text or heading a special effects. WordArt is useful for making headings stylish and attractive and for highlighting certain words. How to insert WordArt in excel ? STEPS : 1. Open Worksheet /Database, where you want to insert decorative text. 2. Insert tab >> in the Text group >> click WordArt. 3. Click any WordArt style. 4. A Textbox will appear in your sheet. You can rotate or move the textbox wherever you want. 5. Type the Text as per your requirement in the Text box. 6. Click anywhere in the sheet or press “esc” key to exit. If you have excel version above 2013 then plese check the below image to find WordArt Location. Insert >> Text >> WordArt How to make changes or e...

Jun162022 by excelhelp13No Comments

How to show Gridlines in excel

Page Layout, tips & Tricks

What is Gridlines ? The horizontal and vertical gray lines that appear between the cells on the worksheet are called Gridlines. How to Show Gridlines : Method-1 Click on Page Layout tab Go to the Gridlines section in sheet options group. Check the view box. Method-2 Click on view tab Go to the show group. Check the Gridlines. Method-3 Click on File tab Click excel Options >> Advanced >> display options for this worksheet Check the show Gridlines

Jun162022 by excelhelp13No Comments

Print all columns in one page in excel

Page Layout, tips & Tricks

Scale to Fit Command shrinks the worksheet to better fit the printed page. Look at the Image below. Column I to L are overflow. that means it can't be printed on one page. To Print All Columns In One Page : Method-1 Click the Page Layout tab.Go to Scale to Fit group.In the Width box, select 1 page, and in the Height box, select Automatic.Columns will now appear on one page, but the rows may extend to more than one page. Note:- if you do this however, the printed result may be hard to read, because Excel shrinks the data to fit. You may need to make other adjustments before you print. For example. You may need to change the page orientation from portrait to landscape or target a larger paper size.Use the page size option to use larger paper sizes to accommodate ...

Jun162022 by excelhelp13No Comments

How to Print Gridlines in Excel

Page Layout, tips & Tricks

By default, Gridlines don't appear on a printed worksheet. But if you want to print it in your work, follow the steps given below: Click on Page Layout tabGo to the Gridlines section in sheet options group.Check the print box. Now If You go to print you will see the gridlines in your print section and the same will appear on your print document.

Jun162022 by excelhelp13No Comments

Create drop down List in Excel.

Data, tips & Tricks

STEPS : Prepare the list for drop-down in Excel sheet.Select the cell or range where you want to create a drop-down.Go to View tab.Click on Data Validation.In the Data Validation dialogue box, . Choose “List” from Allow drop-down.Type or Select the range of source data in source box.Click OK Note- you can create a drop-down in same sheet or in other sheet and can pass the referecne according to the requirement. See the Result in Below Image. Remove/Delete Drop-Down in excel. Select Cell or Range, who has drop-down that you want to Delete.Go to view tab.Click on Data Validation.In the Data Validation dialogue box, Click on Clear All.Click OK. See the Result in Image below.

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

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.