please help with me
excel border tool shortcut key please
2007-12-03 17:57:14 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
Uh, not quite.
Using Ctrl + 1 only opens the Format dialog box. You still have to select the Border tab, then you can use the following keyboard shortcuts:
Apply or remove the top border. ALT+T
Apply or remove the bottom border. ALT+B
Apply or remove the left border. ALT+L
Apply or remove the right border. ALT+R
If cells in multiple rows are selected, apply or remove the horizontal divider. ALT+H
If cells in multiple columns are selected, apply or remove the vertical divider. ALT+V
Apply or remove the downward diagonal border. ALT+D
Apply or remove the upward diagonal border. ALT+U
INSTEAD, why not create a toolbar button to add the border you want, then it is only a single mouse click away.
If you do not know how to do that, just email me through yahoo answers.
2007-12-03 19:53:15 · answer #1 · answered by vbmica 7 · 0⤊ 0⤋
Ctrl+1
2007-12-03 18:16:39 · answer #2 · answered by MYs 5 · 0⤊ 0⤋
I usually plug macros under alphabetically appropriate keys and put proper icons in the tool bars - so don't bother with shortcut keys, but the most practical is the Ctrl+' to duplicate into the active cell whatever is in the cell above.
2016-03-16 23:57:46 · answer #3 · answered by ? 4 · 0⤊ 0⤋
This Site Might Help You.
RE:
Excel border tool - shortcut key please!!!?
please help with me
excel border tool shortcut key please
2015-08-15 18:26:33 · answer #4 · answered by Anonymous · 0⤊ 0⤋