Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Draw Boarders in Excel

Tuesday, September 8th, 2009 by | Filed Under: MS Excel
 
Loading...


Use a lot of borders in MS Excel?

Tired of the old routine of selecting cells, choosing border from the borders button… or, worse yet, going into the Format Cells dialog box to set borders in there… then repeating the same process for each and every place we need them?

I personally, use MS Word 2007 a lot and I really like that I can just draw my borders. (To view the tip on drawing borders in Word 2007 click here.)

So, my logical progression of thought is that why can’t I accomplish that same thing in Excel?

Well, the answer is that we can… and not just in Excel 2007! I found this one in my version of Excel XP so there’s good news here for everyone.

Ok, so the plan is that we simply draw borders around a cell, a section of cells or draw a border grid throughout a section of cells. With that in mind let’s get started.

Let’s start with older versions of Excel:

You’re looking for the Borders button.

image

Click the down-arrow on the button and choose Draw Borders.

A small toolbar that looks like this will open. (If you find that you really use the Borders toolbar a lot you can choose to always display it using the View menu, Toolbars submenu.)

image

The button on the left lets you choose to draw a border or a border grid.

The next button is obviously the eraser which can be used for intricate custom borders to remove portions or for those “oops” moments that we all have.

The next button is a drop-down list of the available line styles and the last button will open a color palette that is applied to the lines themselves.

Now let’s talk Excel 2007:

You will find what you need by clicking the down-arrow on the draw borders button. (If you really like this particular border method you can always choose to add the Draw Border LIne and Draw Border Grid buttons to your Quick Access Toolbar. To see the tip for customizing this toolbar click here.)

image

Towards the bottom you’ll find a whole section devoted to drawing borders.

Choose between a border box (around the outside edges of the cells) and a border grid.

Below the choices for border type you can choose a line color and style and the ever handy eraser is located there as well.

Now that everyone has found the necessary elements you’re all ready to draw, draw and draw some more since once activated the drawing tool stays on until you either hit the Esc key or click the Draw Border button again to turn it off.

That’s it, you now have what you need to draw everything from simple to complex borders without a bunch of dialog box hassles!

~ April

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: