Thursday, November 21

Page Layout

How to show Gridlines in excel

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