Customize keyboard shortcuts to XLTools operations you use frequently

For your convenience, some frequently used XLTools operations can be performed using keyboard shortcuts:

Open XLTools tab Settings button Shortcuts tab.

Custom Shortcuts is one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Download XLTools for Excel

You can change the hot key combinations for XLTools features at any time.

1. XLTools tab Settings button Shortcuts tab Place your mouse in the text box for a specific operation.
2. Hit the new combination of keys on your keyboard The default combination will change to the one you've set.
3. Click OK Done.

Note:some combinations may not be available if they are reserved for other operations in Excel.

Below is the list of XLTools operations you can quickly perform with the shortcuts. To learn more about the features, please follow the links.

• Disable F1, Disable F9

  Disable F1 and F9 keyboard keys in Excel

• Sheet Switcher

  Switch back and forth between worksheets

• Text Case

  Change letter capitalizations in cells and ranges

• Trim spaces

  Remove excess spaces in cells and ranges

• Numbers to Text

  Convert numeric values to text values

• Text to Numbers

  Convert numbers recognized as text to numeric values

• Insert Date

  Display date picker to insert dates in cells

• Insert Time

  Display time picker to insert time in cells

• Export to CSV

  Export Excel ranges to CSV format

• Combine Cells

  Combine and merge cells without losing data

• Repeat Selection

  Select every Nth row, Nth column, checkerboard pattern

• Recalculate Range

  Recalculate formulas only in a selected range

• Loop Macro

  Record and run a macro on multiple workbooks in a folder