23 thoughts on “Cell Border Shortcuts”

1. Dick, I tried to tell you about those shortcuts at the last MVP Summit, but you were too busy drinking beer. Maybe next time you’ll listen to me.

2. Neat trick. These are actually easy to remember and will be far better than trying to click those darn tiny lines when there’s a deadline.

   What kind of beer was it?

3. Ctrl+Shift+7 will outline selection without going through the Format Cells dialogue.

4. I only now realized that you can do diagonal borders in Excel. I think I’m going to use them all the time! :)

5. I must be doing something wrong – I can’t get the ALT+ shortcuts to work (using 2003).

   Ctrl+Shift+7 works like a dream. Now what’s the shortcut for a dotted, red border on three sides and a thick, blue border along the bottom?

   If we’re talking shortcuts, one I learned recently is Ctrl+’ (the key to the left of the 1 along the top of the keyboard). It toggles between showing formulae and values.

6. Does not work on Excel 2000 (pity)

7. Haffy,

   You do have to have the Format Cells dialogue (shortcut Ctrl + 1), borders Tab active for the Alt keys to work. For the custom formats: I record a macro while formatting and assign the shortcut there.

   Brett

8. A couple they don’t mention in the article:

   ALT+O outlines the cells
   ALT+I give interior (vertical and horizontal)
   ALT+N removes all borders
   ALT+C brings up the color pallette

9. Thanks, Brett

10. Crtl+Shift+_ (That’s the dash/underscore key – right of zero) will remove all borders from the selected range.

11. Ctrl+Shift+& gives the border (top,bottom,left and right)

12. John W – forget the new Excel Bible – just right a book containing ALL the Excel keyboard shortcuts. Everyone would buy it!

13. Haffy
    Not the mousers like me….

14. how to give all border in ms Excel from keyboard.

15. how to text left, Right and center from keyboard. and how to changecase text from keyboard. Plz send me answer uraggently i will be waitng for your answer ok take care and bye bye,

16. http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx
    Charlie’s List, or “214 Keyboard Shortcuts”
    http://www.isamrad.com/dgainer/1_02-23-2006.pdf

    Other versions are available at:
    http://www.NavigatorPF.com
    http://www.mvps.org/dmcritchie/excel/shortx2k.htm Excel 2000

17. HOW TO APPLAY ALL BORDER IN EXCEL FROM KEYBOARD SHORTKEYS

18. which shortcut keys for apllying border in excel sheet

19. ctrl+shit+& is shourtcut of outline border ok

    what can i do for then i selected more-than shall in worksheet and create a border of every shell?

20. we want all borders in excel using keyboard shortcut… Please help…

21. I believe that some of you are interested in creating a boarder around every cell within and surrounding a (large) box? For example: Range A1:D5 with a border around every cell. If that’s the case: ALT + H + B + A.

22. It is just simple…all shortcuts in front of you. follow the steps
    1. Press ALT key.
    2. Now you are seeing all the shortcut letters on screen. ‘H” for home screen for instance.
    3. Here ‘B’ for boaders, ‘H’ for back color etc. Go with B
    4. Here again ‘A’ for all boarders.
    Done.

23. Resposes here doesnt help. Sohail’s comment agrees with me on this.

    I’m looking for a similar keystrokes like ctrl+shit+&(outline border) or ctrl+shit+_(remove border). I need ALL BORDER: Crtl+shift+(God knows what).

    If there really is none, might as well use alt,h,b,a or record a macro.

---

Posting code? Use <pre> tags for VBA and <code> tags for inline.