Excel shortcuts

Create a custom keyboard shortcut to quickly insert a border in Excel

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:

  1. Open the Excel workbook in which you want to create the shortcut.
  2. Click the File tab, then click Options.
  3. In the Excel Options dialog box, click Customize Ribbon.
  4. In the Customize the Ribbon list, select the Main Tabs check box.
  5. Click the Customize button next to Keyboard shortcuts.
  6. In the Customize Keyboard dialog box, select the Home tab.
  7. Click in the Press new shortcut key box, then press the keys you want to use for the shortcut. For example, you could press Ctrl+Shift+B.
  8. Click Assign.
  9. Click Close.

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.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.