excelhelp13, Author at Excel-Help

Jan32021 by excelhelp13No Comments

Set Print Page Size In Excel

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

Dec312020 by excelhelp13No Comments

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

Dec302020 by excelhelp13No Comments

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

Dec302020 by excelhelp13No Comments

Header And Footer Bottom Set In Excel

Insert Menu, Menu Bar, Page Layout

Header And Footer Introduction: You have choice to add headers or footers at the top or bottom of a printed worksheet in Excel. You can create your own header and footer, or you can use many built-in headers and footers available in excel. As example, you can create a footer that has page numbers, no of pages ,date, sheet name, Time, Picture path of your file etc.. Note:- Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. 1. How To Insert Header And Footer In Excel: Click The Worksheet Where You Want To Add Or Change Headers Or Footers.Click On The Insert Tab > In The Text Group > Click Header & Footer.Type Your Custom Text In The Header Or Footer Text Box If You Want To Add Or Edit An Existing Header Or Footer, Click On ...

Dec272020 by excelhelp13No Comments

TIMEVALUE Function To Convert Text Into Time

Date And Time, FORMULAS

DEFINITION: TIMEVALUE Function Converts A Valid Time Stored As Text In A Cell Into A Excel Valid Time In A Serial Number Format. From 0 (12:00:00 Am) To 0.99988426 (11:59:59). Set The Format As Time To Convert Serial Number Into A Time Value. SYNTAX : =TIMEVALUE (VALID TIME_TEXT)

Dec272020 by excelhelp13No Comments

WORKDAY.INTL Function To Extract Working Days

Date And Time, FORMULAS

DEFINITION: WORKDAY.INTL Function Required A Valid Date - Days. Other Two Parameter Are Optional. This Function Returns The Working Day For The The Future Or The Past Dates. SYNTAX: =WORKDAY.INTL (START_DATE, DAYS, [WEEKEND], [HOLIDAYS]) Weekend Parameters Is Optional But By Default It Is Set As (Sat-Sun). There Are Many Weekend Days Option Available To Set According To Your Country Based Or Requirement And Those Days Will Be Excluded While Calculating The Working Days. Holidays Parameter Is Optional But If You Set Any Date It Will Be Considered As Holiday. It Will Be Excluded While Calculating The Working Days. Use (+) Number As Days For Future Dates And (-) Number For Past Dates. Set Weekend NumberWeekends Days1Saturday - Sunday2Sunday - Monday3Monday - Tuesday4Tuesd...

Dec272020 by excelhelp13No Comments

WORKDAY Function To Find Working Days

Date And Time, FORMULAS

DEFINITION: Workday Function Need A Valid Date As Parameter And In Returns. It Return Working Day In Date Serial Format For Future Or Past. To Change The Date Serial Number To A Date You Must Set Format As Date. Workday Function Has Sat-Sun As Default Weekends And It Exclude Weekends And Any Dates Set As Holidays. Use A (+) Number As Days For Future Dates And A (-) Number For Past Dates. Note: This Function Does Not Include The Start Date Day. IMPLEMENT: (1) Parameter Start Date - The Date From Where To Start.(2) Parameter Days - Number Of Working Days After Or Before Start Date.(3) Holidays - [Optional] A List Or A Single Date That Considered As Non-Working Days. You Can Have Some Date Listed In Cells Which You Can Set As Holidays But You must Fix It With Dollar Sign. Ex:- $A$1...

Dec262020 by excelhelp13No Comments

WEEKDAY Function To Extract Day From Date

Date And Time, FORMULAS

DEFINITION: Weekday Function Returns The Day Of The Week In Numeric Number From A Give Valid Date Or A Date Serial Number. By Default Weekday Returns 1 For Sunday And 7 For Saturday. To Find The Serial Number Of A Date Change The Cell Format To General Of A Cell Which Contain The Valid Date And Try Adding Serial Number In Place Of Date And You Will Get The Same Result. SYNTAX:- =WEEKDAY (SERIAL_NUMBER, [RETURN_TYPE]) Return Type Is optional As It Is In Square Brackets. Any Parameter In Excel Having Square Bracket Is Consider As Optional. Return TypeDescription1Returns A Number From 1 (Sunday) To 7 (Saturday). Default2Returns A Number From 1 (Monday) To 7 (Sunday).3Returns A Number From 0 (Monday) To 6 (Sunday).11Returns A Number From 1 (Monday) To 7 (Sunday).12Re...

Dec262020 by excelhelp13No Comments

WEEKNUM Function To Extract Week Number

Date And Time, FORMULAS

DEFINITION : WEEKNUM Function Need A Valid Date Or A Serial Number Of A Date And In Returns It Gives A Week Number From 1 To 54 Which Corresponds Week Of A Year. The WEEKNUM Function Begin Counting With The Week Contains 1St January. As A Default Week It Begin From Sunday For Which Return_Type Is 1. The Return_Type Parameter In WEEKNUM Function Is The Day Begin Number. By Default Value Is 1 And The Day Is Sunday. For More Details Please Check Image And Table Chart Below. SYNTAX : =WEEKNUM (SERIAL_NUM, [RETURN_TYPE]) Return Type Week Begin Name 1Sunday2Monday11Monday12Tuesday13Wednesday14Thursday15Friday16Saturday17Sunday21Monday

Dec262020 by excelhelp13No Comments

YEAR Function To Extract Year From A Date In Excel

Date And Time, FORMULAS

DEFINITION: Year Function Returns The Year From A Valid Date In A Numeric Value. You Can Use The Year Function To Extract A Year From A Valid Date Into A Particular Cell Either By A Reference Cell Where A Valid Date Is Stored Or By Inputting The Date In Itself. Example Year("26-12-2020") Return 2020. Or Year("12-26-2020") Return 2020. Enter The Date According To Your Pc Settings.