How to configure hotkeys in excel 2010 if there is no such item?

I

Igor2016-09-25 12:03:29

excel

Igor, 2016-09-25 12:03:29

www.excel-office.ru/microsoft-word/nastroitgorklword Searched
the manual...
image.prntscr.com/image/333802bda2ce40d29c48e15b09...

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

J

John Smith, 2016-09-25
@ClearAirTurbulence

The only way is to create macros with the necessary operations, and assign hotkeys to them.
However, running the macro, EMNIP, resets the Undo history, which can be extremely inconvenient.
In the new excels with a ribbon interface, after pressing the Alt key on the ribbon, tooltips are displayed with keys that can be used to activate a function from the ribbon. But it will take a lot of time, because. remembering this for a more or less significant set of commands is unrealistic, and looking at the tips is inconvenient, they are updated slowly, and are entered non-standard - for example, to format selected cells into the "accounting" format, press Alt, release it and press H, A, N in sequence , then also select the format from the drop-down list...