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. For example, you could create a shortcut for inserting a new worksheet, or for hiding or unhiding columns or rows. Note that you can also use this technique to create custom keyboard shortcuts for other Excel commands. 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. For example, you could press Ctrl+Shift+B.
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. This can be a time-consuming process, especially if you have to do it often.
If you work with data in Microsoft Excel, you probably find yourself constantly inserting borders around cells or ranges of cells.
0 kommentar(er)
