Software

Ask something
Question Locked

Help, rounded borders in excel

0 helpful
4 replies

by poddingtonpeas2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi. someone please help,

I have been creating a generic application form for my company and have finally completed it but it looks very harsh to the eye, i want to round off the borders and text boxes before i lock them up but have searched on the program long and hard and have found no way to do it.

Can you pleeease suggest a way in which i can do it, or a program that i can open the excel files in to do it, or even a codec that could help.

Thank you.

Philip Witherby
TheMortgageWizard.co.uk

4 replies

by drowningnotwaving

... is to use the drawing tools in Excel instead of the cell formatting tools.

The better way is to spend a buck and get a professional technical writer to lay out the forms. Designing a form for users -one that truly is usable and workable - is not as simple as it seems.

by poddingtonpeas2003

I managed to do it in the end. i did what you suggested and used the drawing tools and it looks very professional thank you!

I did also find a way by editing excels program script but that as you can imagine ended in chaos as it was a trial and error process, well, it was an error process anyway.

i managed to protect the sheet and make all the rounded bordered boxes for text and protected them using the escel sheet as a template!

Many thanks again

Phil

by mark_linn

You can use the shapes on the insert menu. It has rounded rectangles. If you make the fill transparent it should work as a border of a cell. They also work as textboxes. You can change colors, shadow, and the border weight from the drawing tools - format ribbon with the shape selected.

This discussion is closed to new replies.