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,


No comments:

Post a Comment