Thursday, November 21

Menu Bar

Print all columns in one page in excel

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 ...
How to Print Gridlines in Excel

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.
Create drop down List in Excel.

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.
Subscript Effect in Excel

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 ...
Superscript Effect in Excel

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...
Create diagonal line in cell

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 "...
Insert multiple Columns in one Click in Excel.

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.
Subtotal All Function in Excel

Subtotal All Function in Excel

Data, Menu Bar, Statistical
SUBTOTAL function is use to get a subtotal in a list or from database. SUBTOTAL function can either include or exclude values in manually hidden rows. By default, SUBTOTAL excludes values in rows hidden by a filter. The SUBTOTAL function automatically ignores other SUBTOTAL formulas that exist in references to prevent double-counting. Syntax:-=SUBTOTAL (function_num, ref1, [ref2], ...) Arguments function_num - A number that specifies which function to use in calculating subtotals within a list. See table below for full list.ref1 - A named range or reference to subtotal.ref2 - [optional] A named range or reference to subtotal. There are 11 functions available, each with two options, as seen in the table below. When function_num is between 1-11, SUBTOTAL includes cells that have...
Move or Copy Sheet in Excel

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...
Protect Worksheet in Excel

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