excelhelp13, Author at 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.

Mar42023 by excelhelp13No Comments

Translate Text into a different Language in excel

Menu Bar, Review, tips & Tricks

Excel Translate is a function that converts text in one language to another language. Mostly English language is used to present the data. However, you can change the default English language content to your own language. Steps- Select cell and Go to Review Tab Click on Translate 3. On the right-hand side, you will see the dialog box. 4. In the Search for, You will see the text of the selected cell. Or type the word you want to convert. 5. Select From - To language in the dialog box. 6. Click on Start Searching button. 7. It will translate the in Hindi as it is the selected translate language for this example..You can choose your language as per requirement. 8. If you click on Insert, it will insert the converted text to the acti...

Mar32023 by excelhelp13No Comments

Create Dynamic Dropdown list with Indirect formula

Data, tips & Tricks

A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select F3 to F6 In the Data tab, Click on Data Validation. In the dialog box that opens, select “L...

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

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.