Thursday, November 21

Menu Bar

Strikethrough Effect in Excel

Strikethrough Effect in Excel

Home Menu, Menu Bar
Strikethrough  Effect is Useful for drawing a line in the center above the data / text in the cell to mark it as a completed or to display as depricated or non use as per the needs vary. How to Insert Strikethrough Effect in Excel ? For Example:- excelhelp.in Steps:- Select DataClick Home tab > format > Format cell… or right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectCheck on Strikethrough box.Click OK How to Remove Strikethrough Effect in Excel ? Select the data.Click Home tab > format > Format cell… OR right click on any cell > Format cell… The format cell dialog box will open.Click on font tab > font effectUnCheck on Strikethrough box.Click OK ...
SPLIT CONTENTS IN DIFFERENT CELL IN EXCEL

SPLIT CONTENTS IN DIFFERENT CELL IN EXCEL

Data, Menu Bar
STEPS : Select the cell or column that contains the text you want to split.Click on Data TabClick  Text to Columns.In the Convert Text to Columns Wizard, select Delimitedclick Next. Select the Delimiters for your data. For example Comma, Space etc. You can see a preview of your data in the Data preview window. here we choose spaceClick  Next. Choose the Column data format or use what Excel choose for you. Here we choose General.Select the Destination, which is where you want the split data to appear on your worksheet.Click finish
Hide or Remove Gridlines in Excel

Hide or Remove Gridlines in Excel

Menu Bar, Page Layout
What is Gridlines ? The horizontal and vertical gray lines that appear between the cells on the worksheet are called Gridlines. If you don’t need gridlines in your work, you can Hide them by following the steps below. Method-1 Click on Page Layout tab Go to the Gridlines section in sheet options group. Uncheck the view box.   Method-2 Click on view tabGo to the show group.Uncheck the Gridlines.   Method-3 Click on File tabClick excel Options  > Advanced  >  display options for this worksheetUncheck the show Gridlines

Remove Duplicates in excel

Data
Steps: 1. Select data or Click any single cell inside the data set. 2. Click on the Data tab 3. Click Remove Duplicates in the Data Tools group. 4. Remove duplicates dialog box appears. 5. Click check boxes as per your requirement and click OK. (in this example, remove rows with the Name. So, Check Name and click OK.) 6. Result- Excel removes all rows with the same Name except for the first instances found.
Set Page Break In Excel

Set Page Break In Excel

Menu Bar, Page Layout
DEFINITION: Page Break Is Use To Print A Worksheet With The Exact Number Of Pages That You Want To Get Print From The Entire Worksheet. You Can Adjust The Page Breaks In The Worksheet Before You Print It. Page Breaks Is A Division That Break A Worksheet Into Separate Pages For Printing Them Individually. STEPS TO FOLLOW: There Are Two Types Of Page Breaks: Solid Line (Manual Page Break) To Adjust Where The New Page Begins. Another Is Dashed Lines Page Breaks That Inserted Automatically By Excel. You Can Set And Adjust The Columns And Rows According To Your Requirement In View Tab > Page Break View > Adjust Blue Line By Dragging It. INSERT PAGE BREAK : To Insert A Page Break, Follow The Steps Below. Select The Row From Where You Want To Start The New Pa...
Set Background Image From Local Or External Source

Set Background Image From Local Or External Source

Menu Bar, Page Layout
DEFINITION: To Make Your Sheet Look Better Visually We Can Set A Colorful Background By Inserting A Background Images On A Worksheet. You Can Add it Through Local Files Stored on your PC or From External Source Like Bing image Search Or From One Drive If your Version Of Excel Support It. NOTE: In Excel You Can Use A Background Picture For Display Purposes Only. A Sheet Background Image Is Not Printable. STEPS TO FOLLOW: Go To Page Layout > BackgroundInsert Pictures Dialog Box Will Get Appear.Click On The The Browse Button To Add Background Image From Local File And Other Option For External File. Delete Background Image: STEPS: To Delete Background, Go To Page Layout > Click Delete Background.
Print Selected Area Only By Set Print Area In Excel

Print Selected Area Only By Set Print Area In Excel

Menu Bar, Page Layout
DEFINITION : In A Situation When You Only Want To Print A Specific Selection Data Range From Entire Worksheet, You Can Use A Print Area To Set Or Print The Selection Data Range Only, You Can Select Single Or Multiple Data Range Using The Print Area. You Can Set Multiple Print Areas In A Worksheet. Each Print Area Field Will Be Print On A Separate Page. When You Print A Worksheet By Applying The Selection Print Area Then Only The Print Area Will Get Printed And Rest Of The Page Will Remain Blank. You Can Add More Cells Or Range To Expand The Print Area Selection As Needed, You Can Also Clear The Print Area To Print The Entire Worksheet. SET PRINT AREA: STEPS: Select The Worksheet From Which You Want To Print. Select The Range Of Data That You Want To Print ...
Set Print Page Size In Excel

Set Print Page Size In Excel

Menu Bar, Page Layout
DEFFINITION : The Page Size Option In Excel Is Used To Set And Match The Page Size For The Print Page According To The Size Of Your Printer Paper. STEPS : Select The Worksheet.Go To Page Layout Tab .Click On Size Button .One Drop Down List Of Page Will Appear.Choose Page Size According According To Requirement And Matching Paper Size To Your Printer.You Can Also Set The Margin Of Print Page.You Can Set Header And Footer For The Print Page.You Can Set Page To Landscape. Portrait (By Default).Please Check The Image Below. NOTE : For Some Reason If You Don't Find Required Page Size In The Size Dropdown List, Select More Paper Size Option And Choose The Paper Size From Their. You Can Also Set Or Change The Page Size In The Print Preview Page And Can Check With Live Previ...
Set Up Landscape Or Portrait Print Page In Excel

Set Up Landscape Or Portrait Print Page In Excel

Menu Bar, Page Layout
DEFINITION: By Setting Orientation Option, You Can Print A Worksheet Or Worksheet Data In Landscape Or Portrait Orientation Mode. Page Orientation Determine How The Output Is Going To Be Printed On The Page. There Are Two Types Of Page Orientation:(1) Portrait − (Default) Portrait To Print Horizontal Or Pages That Are Tall. Portrait Pages Are Tall Then Its Width. (2) Landscape − Landscape To Print Wide Or Vertical Pages. Landscape Pages Are Wider Then Its Height. Please Follow The Steps : Select The Worksheet To Set The Orientation For To Print. Go On The Page Layout Tab > Select The Orientation. Click Either On Portrait Or Landscape According To Your Requirement. You Can Also Change The Settings On Print or Print Preview Page And See The Live Preview. Please Check ...
Set Print Margin For Top Bottom Left Right Edges

Set Print Margin For Top Bottom Left Right Edges

Menu Bar, Page Layout
DEFINITION : Margins Are The Blank Space Between The Worksheet Data And The Top, Bottom, Left, Right Edges Of The Printing Page. It Can Be Customize To Add More Or Less Space Around Your Worksheet Data According To Your Requirement. DEFAULT SET: By Default Value Of The Margins Are 0.75 Inches (1.91 centimeter) For The Top And Bottom, And 0.70 Inches (1.78 centimeter) For The Left And Right. By Default Header & Footer Margin Is 0.30 Inches (0.76 centimeter). Go To Page Layout.Click On Margin.Select The Available Excel Margin. Set Custom Margin : Click On Page Layout Tab.Click On Margins Button.Click On Custom Margin.One Dialog Box Will Get Open.Set Top, Bottom And Left-Right Margin As Per Your Requirement.If You Have Header Footer In Your Sheet You Can Customize Tha...