I tried navigating to the insert split button as follows:
alt + H, control + right arrow until I hear insert split button,
then right arrow, nothing happens, for laughs and giggles left
arrow, nothing happens, enter, space bar, attempted routing of
cursors and simulated mouse click with left or right click and
nothing. This is with Office 2016/Excel.
On 2/18/2017 6:14 AM, Quentin
Thinking on it a bit further, and looking back at the
ribbon in Word and Excel, the key word is "split button". A
split button, visually, is a button where you activate the
main part of it to do the most common action. An arrow coming
off the right side opens a menu of other related options. The
most common example of a split button is the start menu item
for a program such as Word in Windows 7. When you arrow to
Word in the start menu in Windows 7, you can either press
ENTER to go into a blank document (or the backstage) in Word.
Alternatively, you can press the right arrow to open a "jump
list" of recent documents you have used in Word.
Insert, Delete and Format cells in Excel are setup the same
way. When you press ENTER on the insert button, for me it
inserts a cell and pushes the rest down. If I have multiple
cells selected, it inserts multiple cells, pushing either
right or down, depending on what was selected.
Merge and Centre, Font Colour, Accounting number format,
and sum all do the same thing on the home ribbon in Excel,
They all have an action they perform if you activate them,
and a list of related actions you can get to if you alt+down
arrow on them. It might not be obvious, but there you go.
Training Material Developer
They Ask Me If I'm Happy; I say Yes.
They ask: "How Happy are You?"
I Say: "I'm as happy as a stow away chimpanzee on a banana boat!"