Forum Discussion
Getting error with right click after selecting multiple cells with Ctrl
Hello, Same problem here since 28/09/21. The actual problem is when you select two or more cells with CTRL and then right click, you get inmediately the message "this can't be done on a multiple range selection..." .
Not even try anything, just right clicking.
The problem is with the context menu, because if I select multiple cells with Ctrl and the go to start I can do the usual things like format, cell color, etc
Thanks
- WS_8419Sep 29, 2021Copper Contributor
Thanks for the link but it's not the same problem. That link is for the well known case of selecting nonadjacent cells.
This problem is new and it's different and occurs when selecting even adjacent cells but with CTLR and the problem is the context menu because Excel blocks the context menu BEFORE you choose any option. Me and next post have explained it in detail.
Thank you.
- NikolinoDESep 30, 2021Platinum Contributor
You can try the following.
Open Excel workbook and press Alt + F11
Press Ctrl + G and type Application.CommandBars ("Cell"), Reset and then Enter.
Press Alt + Q to log out of Workbook.
Then see if you can insert comments with the right mouse button.Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)