Excel Insert Options Button - Accessibility

Question

Is there an accessibility option for activating the Insert Options button in Excel?

Reference: https://www.ablebits.com/office-addins-blog/excel-insert-column/

Right-click on any cell in the column.

From the context menu that appears, select the Insert command.

In the Insert menu that opens, choose the Entire column option and click OK.

Inserting a column in Excel

Whichever method you use, you will notice the Insert Options button that appears next to the newly added column. This button provides three useful formatting options:

 

Format Same As Left - the newly inserted column will inherit the formatting of the column to its immediate left (default). This is helpful when you want consistent formatting across adjacent columns.

Format Same As Right - the newly inserted column will adopt the formatting of the column to its immediate right. This is also useful when you want the formatting of adjacent columns to match.

Clear Formatting - will remove all formatting attributes, such as font styles, borders, and background colors, from the inserted column.

Format options for the newly inserted column

By utilizing these formatting options, you can easily manage the appearance of your spreadsheet as you insert new columns.

Answer 1

Thank you for sharing.

Answer 2

Does Excel currently support the ability to activate the Insert Options button in Excel similar to pressing "Ctrl" when pasting (Ctrl+V) data? Is this an accessibility feature that currently exists or is planned to be added?

Screenshots for examples when pasting:

Answer 3

After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box.

Answer 4

Yes, the copy and paste functions offer a lot of shortcuts and accessibility options. This does not seem to be the case for activating the Insert Options button when trying to insert a new column or row without an data being pasted.

Is there a way to enable the (Ctrl) shortcut for the Insert Options button when inserting blank rows or columns?

Answer 5

Select any cell. Then Ctrl+shift+"+"