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

Mouse Free Borders

Friday, April 21st, 2006 by | Filed Under: MS Excel, MS Office Help
 
Loading...


Mouse Free Borders

Do you use the Format Cells window to create custom cell borders in MS Excel?

Do you prefer the keyboard to the mouse?

Maybe, in an effort to combine these two things, you’d be interested in a list of keyboard shortcuts to apply and remove individual cell borders?

If it sounds like a good idea to you, then read on.

Obviously, our tip starts after you’ve highlighted the cells and have opened the Format Cells window (Format menu, Cells choice or Ctrl +1) and have clicked into the Borders tab.

Once you’re at this location, you’re ready to apply borders.

You can use the Tab key to move between sections / buttons on the tab. Once you tab over to the line style section, you can use arrow keys to make a new selection.

Now for the good part! To apply or remove borders, use the following key combinations. (Excel will use whatever line style is currently selected when applying a border).

  • Alt + T for the top of a cell group border
  • Alt + B for the bottom of a cell group border
  • Alt + L for the left of a cell group border
  • Alt + R for the right of a cell group border
  • Alt + D for the diagonal border from the upper left to the bottom right corners of each highlighted cell
  • Alt + U for the diagonal border from the lower left to the upper right corners of each highlighted cell
  • Alt + H for the horizontal cell border between individual cells in a highlighted cell group
  • Alt + V for the vertical cell border between individual cells in a highlighted cell group.

Use the key combination once to activate the border and again to remove it.

And there you have it. Even with cell borders, we can keep to the keys.

~ 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: