How to draw borders in Excel 365?

%3CLINGO-SUB%20id%3D%22lingo-sub-1790174%22%20slang%3D%22en-US%22%3EHow%20to%20draw%20borders%20in%20Excel%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790174%22%20slang%3D%22en-US%22%3E%3CP%3Eello%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20previous%20versions%20of%20Excel%2C%20there's%20a%20%22Draw%20Border%22%20tool%20when%20you%20move%20your%20cursor%20over%20the%20Border%20icon%20on%20the%20Ribbon.%20Your%20cursor%20would%20become%20a%20pencil%20so%20could%20freely%20draw%20a%20border.%20See%20link%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Flessons%2Fhow-to-draw-borders-and-border-grids-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Flessons%2Fhow-to-draw-borders-and-border-grids-in-excel%3C%2FA%3E%26nbsp%3Bfor%20demo%20of%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20I'm%20using%20the%20Excel%20365%20and%20unable%20to%20find%20this%20functionality%3F%26nbsp%3B%20If%20was%20removed%20or%20relocated%20elsewhere%2C%20also%20I%20checked%20in%20the%20Help%20menu%20and%20didn't%20see%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20could%20you%20help%20or%20suggest%20a%20way%20-%20I%20use%20the%20%22Draw%20Border%22%20tool%20to%20draw%20cash%20flow%20diagrams.%20As%20an%20example%20see%20this%20link%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D775ljhriB8U%26amp%3Bfeature%3Dyoutu.be%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D775ljhriB8U%26amp%3Bfeature%3Dyoutu.be%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELook%20forward%20to%20hearing%20from%20the%20community%20soon.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3EHillman%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1790174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1790610%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20draw%20borders%20in%20Excel%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790610%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835388%22%20target%3D%22_blank%22%3E%40HillmanLam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20this%20information%20will%20help%20you%20in%20your%20project.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20not%2C%20please%20ignore.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-560574455%22%20id%3D%22toc-hId-560574455%22%20id%3D%22toc-hId-560574455%22%20id%3D%22toc-hId-560574455%22%3E%3CFONT%20size%3D%223%22%3EApply%20or%20remove%20cell%20borders%20on%20a%20worksheet%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fapply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fapply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20for%20your%20time%20and%20patience%20and%20wish%20you%20much%20success%20in%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1790723%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20draw%20borders%20in%20Excel%20365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835388%22%20target%3D%22_blank%22%3E%40HillmanLam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20desktop%20version%20of%20Excel%20365%20it's%20at%20the%20same%20place%20(see%20screenshot%2C%20that's%20365)%2C%20or%20you%20mean%20Excel%20Online%20%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20448px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227230iE2CCC1463C31836C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

ello All,

In previous versions of Excel, there's a "Draw Border" tool when you move your cursor over the Border icon on the Ribbon. Your cursor would become a pencil so could freely draw a border. See link https://exceljet.net/lessons/how-to-draw-borders-and-border-grids-in-excel for demo of it.

But I'm using the Excel 365 and unable to find this functionality?  If was removed or relocated elsewhere, also I checked in the Help menu and didn't see it.

Please could you help or suggest a way - I use the "Draw Border" tool to draw cash flow diagrams. As an example see this link https://www.youtube.com/watch?v=775ljhriB8U&feature=youtu.be

 

Look forward to hearing from the community soon.

Thanks
Hillman

 

 

5 Replies
Highlighted

@HillmanLam 

 

Maybe this information will help you in your project. If not, please ignore.

Apply or remove cell borders on a worksheet

https://support.microsoft.com/en-us/office/apply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3...


Thank you for your time and patience and wish you much success in your project.

Highlighted

@HillmanLam 

For the desktop version of Excel 365 it's at the same place (see screenshot, that's 365), or you mean Excel Online ?

image.png

Highlighted

@Sergei Baklan Thanks Sergei for responding.

Yes, you're right I'm using Excel online (not the desktop version). Don't see the "Draw Borders" tool in the drop down. See screenshot below.

 

HillmanLam_0-1602880611387.png

 

Highlighted

@Nikolino Thanks Nikolino for responding.  I'm using Excel online but seems that functionality is not available.

Highlighted

@HillmanLam 

Excel Online has limited functionality compare to desktop version, unfortunately it has no such option.