Tuesday, December 29, 2020

Page Border in Excel - Steps use to apply a border to an Excel sheet | How to Apply Border In excel

 Step 1: Open Excel on your computer. you can use window + r for open run command and then write excel here for open MS-Excel and press ok


Step 2: Take a blank document 

Step 3: Now When You get a blank document click on page layout mode at the bottom right corner 


After that, you will get a layout like this 


Step 5: Now take the Rectangle tool to draw a simple rectangle 

Now simply Draw an icon of rectengle


Step 6: Set Page Layout to narrow


After that you can see simple arrow icon upon ruler just drag it to up




Step 7: Now you can drag rectangle to top left corner properly




Step 8: Now fit the all corners of rectangle to the page





Step 9: Now go to the format and set fill to no fill


Step 10: Now set shape outline go to More lines 

Step 11: Now in the format shpae set dash border



Step 12: Now go to files


Now go to print option and you can see border on page


Step 13: Now save the file At the location which you want



Last Output





Tags


how to put a border around excel spreadsheet,

how to apply a solid line border to a chart in excel,

how to add borders in excel 2016,

how to add borders in excel 2019,

excel remove border around print area,

excel show page borders,


Monday, December 28, 2020

Different Between to dates in excel | MS-EXCEL Tutorials

 First Write your data if you don't have data then you can use any dummy data or copy from below


You can copy dummy text from here

Start   Date End Date Completed Years Completed Months Completed Days
01-01-2020 02-01-2022
02-01-2020 03-01-2023
03-01-2020 04-01-2028
06-08-1999 28-12-2020

Now in the cell of completed years write the formula =DATEDIF(B3,C3,"Y"). B3 Indicated the starting date and C3 indicated to end date. When you want to know diffrence about years then use "Y" If Months Then use "M" and if you want to check days then use "D"




Now you can drag it for all rows


Now moving to months =DATEDIF(B3,C3,"M")


Now Moving to days =DATEDIF(B3,C3,"D")





You can use this formula for checking bulk age at onece 

Tags.

how to calculate difference between two dates and times in excel.
number of days between two dates excel.

excel date difference in months,

excel formula to count days from date to today,

datedif excel,

excel formula to calculate number of days between today and another date,

excel between two dates,

days between dates excel,

Saturday, December 26, 2020

Marriage Invitation | Free Weeding Invitation Template

Tutorial How to Edit This



Preview



In This Tutorial, I'm Going to Tell You How Download & Use I'll Tell Complete Step By Step Tutorial Here.

Step 1: Click to Download Wedding Invitation Template

Step 2: Extract with WinRAR If You Don't Have! Download it By Clicking Here


Step 3: Open Font Folder & Install All Fonts
Step 4: Open Wedding Invitation Folder 

Step 5: Open Wedding Invitation In Premiere pro. If  Do don't Have! Download it  from Adobe Site 

Step 6: Wait till Project open it may take time 



Then look below in tabs


Step 7: Now edit the text if you want to change the mantra then you can I'm skipping this part now. moving to the invitation text. 




Now you can replace Mother Name And Father name Here.

If You don't know how to type in Hindi text! Then open this image this will help you 

As of This, you can edit all the tabs.


When All edits will finish back to the main export sequence.






Step 8: Now you can Export Video File. go to  File-> Export -> Media



Now you will get this screen Make sure here you can see "Main Export" and Then click here to set the output location