excel Archives - Excel-Help

Jun162022 by excelhelp13No Comments

How to Print Gridlines in Excel

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

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

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.

Jun92022 by excelhelp13No Comments

Increase font size of Formula bar in excel.

tips & Tricks

Follow the steps below to increase font size of Formula bar. STEPS: Go to File tab.Click on the "Options". That is located at bottom left-side of panel . 3. The one Excel Options dialog box will get appear. 4. Click on General, the go to "when creating a new workbook", in that select "Font Size" and change the value according to your need. For example 30. 5. Click OK 6. Excel gives you a notification "please close and restart Microsoft Excel so that the font changes can take effect." 7. Click OK in it. 8. Close the worksheet and Reopen it. 9. See the result in the image below. The size of the formula bar should be increased. Note- Does not affect worksheet area and cell font size.

Jun92022 by excelhelp13No Comments

Data transpose Dynamically in Excel

tips & Tricks

Transpose function is use to exchange the data from Row to Column and Column to Row. To make your data get update automatically by using transpose function please follow the below mentioned steps. STEPS : Select destination range. (Where you want to transpose data)Type formula =transpose(source data range)Press Ctrl + shift + enter 4. See the result in below image. Data transposed within the selected range. 5. When we edit the source data, the transposed data will changed automatically. See the image below.

Jun22022 by excelhelp13No Comments

Move or Copy Sheet in Excel

Home Menu, Menu Bar

When you need to create a new spreadsheet based on an existing one or move a sheet from one excel file to another, you can move or copy a worksheet in the same workbook or another workbook. 1. Move or Copy a worksheet in the same workbook Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this option using right click on sheet Tab) The Move or Copy dialog box will then open.Choose where you want to place the copy.Click on Create a copy box. (If you don't Click the create a copy box, Excel will only move the sheet.)Click OK. 2. Move or Copy a worksheet to another workbook Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this opt...

Jun22022 by excelhelp13No Comments

Protect Worksheet in Excel

Home Menu, Menu Bar

When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed. Using this option, you can lock your Excel sheet with a password and you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet. Preview in new tab How to Protect Sheet in Excel ? Steps:- Right click on sheet tab > Click Protect Sheet. Or Home> Format > Protect Sheet Check on protect worksheet and content of locked cells box.Enter a password.Check the actions you allow the users of your worksheet to perform.Note:- if you don't check any action, users can only view the Excel file.Click OK. Confirm the password and click OK.Your worksheet is protec...

Dec112020 by excelhelp13No Comments

Count Networks Days Between Dates

Date And Time, FORMULAS

Definition :- There Is A Function Called Networkdays In Excel That Help To Find Out The Number Of Working Days Between Two Given Date Range. It Required Parameter Is Start Date And End Date. For More Info Please Check In Image And Video Below. Validation :- Make Sure That You Must Have Input Valid Start Date & End Date In The Function. Other Wise It Will Give You #Num Error.Make Sure You Have Added Date In Proper Format According To Your PC Settings. Make Sure That You Have Proper Format Date When You Give A Direct Cell Reference As Shown In Image.In Image And Video # Example Are Provided Please Have A Look.

Dec112020 by excelhelp13No Comments

Go To Method In Excel

Home Menu, Menu Bar

Definition:- Go To Feature Is Use To Move The Cell Cursor To A New Cell In The Worksheet. You Can Also Use This Feature To Select A Range Of Cells. There Are Three Ways To Access “Go To” Press The F5Press Ctrl+GHome Tab – Find & Select – Choose “Go To…” To Move The Cell Cursor To A Particular Cell, Enter The Cell Address In The “Reference” Text Box And Click Ok. You Can Also Select A Range Of Cells By Taking These Steps: Select The First Cell Of The Range.Type The Cell Address Of The Last Cell In The Range In The “Reference” Text Box.Hold Down The Shift Key As You Click Ok Or Press Enter To Close The Go To Dialog Box.