Versions Compared

Old Version 2

changes.mady.by.user Daniel LaGrow

Saved on

compared with

New Version 3

changes.mady.by.user Daniel LaGrow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Instructions to adding a keyboard shortcut.

  1. Go to the Developer Tab.

    Developer Tab in Microsoft Excel.Image RemovedDeveloper Tab in Microsoft Excel.Image Added

  2. In the Code section, click Record Macro.

    Record Macro button in Microsoft Excel.Image RemovedRecord Macro button in Microsoft Excel.Image Added

  3. In the Record Macro box, create a name for your macro that is meaningful to what your macro does. In the Shortcut Key, type in the key you want to activate the macro. In Store Macro in: Choose this workbook or your designated workbook. In description, explain what your macro does.

    Record Macro box in Microsoft Excel. Short Cut key is CTRL r. Description is to replace blank cells with no data.

  4. Click OK.

...