Skip to content

Latest commit

 

History

History
47 lines (41 loc) · 2.92 KB

README.md

File metadata and controls

47 lines (41 loc) · 2.92 KB
Raw

quick-excel-toolbar

Useful Excel Addin. Custom Toolbar will be added to the Excel ribbon. Screanshot1 Screanshot2

Install

  1. Download QXT.xlam to any location
  2. Excel Options -> [Add-Ins] Tab -> [Go] button -> [Browse] button
  3. Select the saved Addin File
  4. Close the dialog with the click of a [OK] button

If the toolbar does not appear, try deprotecting the xlam file.

  • Right click QXT.xlam -> Properties
  • Security -> Check "Unlock"

Uninstall

  1. Remove "ExcelKeyboardShortcutAddin.xlam" file on your PC
  2. Restart Excel
  3. When "Sorry, we couldn't find ..." message is displayed then click OK
  4. Excel Options -> [Add-Ins] Tab -> [Go] button -> [Browse] button
  5. Select the Qxt Addin.
  6. When "Cannot find add-in ..." message is displayed then click Yes.

Custom Button

  • A1Select : Select A1 cell in all sheets
  • ShrinkToFit : Togle ajust font size to fit the cell
  • StylePrimary : Change color of font and background
  • ColumnWidth : Set the column width the same as the active cell
  • RowHeight : Set the row height the same as the active cell
  • BaloonWithText : Create a baloon object which have active cell text
  • SizeUpImage : Enlarge selected image +20%.
  • SizeDownImage : Shrink selected image -20%
  • Increment : Plus 1 value of the active cell
  • Decrement : Subtract 1 value of the active cell

KeyBoard Shortcuts

  • F1 : Disable (Do not open help dialog)
  • F11 : Togle fullscreen
  • Insert : Insert row
  • Ctrl+Shift+a : Select A1 cell in all sheets
  • Ctrl+Shift+v : Paste only value
  • Ctrl+^ : Create a baloon object which have active cell text
  • Ctrl+@ : Shrink selected image -20%
  • Ctrl+k : Draw selected cell borders