If you work with data in Microsoft Excel, you probably find yourself constantly inserting borders around cells or ranges of cells. This can be a time-consuming process, especially if you have to do it often. Fortunately, there's a way to create a custom keyboard shortcut that will let you quickly insert a border around any cell or range of cells in Excel.
To create a custom keyboard shortcut for inserting a border in Excel:
Now, whenever you want to quickly insert a border around a cell or range of cells, just select the cells, then press the shortcut keys you assigned. The border will be inserted instantly!
Note that you can also use this technique to create custom keyboard shortcuts for other Excel commands. For example, you could create a shortcut for inserting a new worksheet, or for hiding or unhiding columns or rows. To do this, just follow the steps above, but select the command you want to create a shortcut for in the Customize Keyboard dialog box instead of the Border command.