If you receive error This action won’t work on multiple selections when you attempt to selectcells or groups of cells in Microsoft Excel, then this post will help you.
This action won’t work on multiple selections – Excel error
In Excel, the common reason for getting This action won’t work on multiple selections error is because of a bad selection. This article will demonstrate the most common selection error and how to avoid it.
What causes this Excel error
This action won’t work on multiple selections error in Excel is usually caused when you select cells in Excel incorrectly. The cells will select but you will not be able to copy. When you select in Excel, you can do multiple cells or groups of cells. If you want to select groups of cells with spaces between them, you can select one group then hold Ctrl and select another group.
This is an image showing the entries in Excel just like you may have them in your spreadsheet.
This is an image showing you the election of two groups with a space between them.
This is the incorrect selection that will cause you to get the This action won’t work on multiple selections error.
When you try to copy or cut the selected cells, the error message will pop up. Note that the selection is not incorrect as you can perform other actions on the selection, however, you cannot cut or copy the selection.
How to fix This action won’t work on multiple selections error
The error message is just Excel telling you that you have an incorrect selection. If you want to move both groups of information together then you will have to make a full selection of the groups. If you want to copy or cut full information from one group then just a part of the other group, you will have to copy or cut them separately.
How to avoid getting this error
To avoid getting the error when you want to copy or cut groups of information in Excel, be sure to select the information fully from both groups. If you want to copy or cut parts of one group of information then you will have to do them separately.
Read: How to subtract a Date from Today in Excel
How do I select multiple items in a group in Excel?
To select multiple items in a group in Excel hold Ctrl then select each item in the group. You can also select from multiple groups by holding Ctrl as you click. If you want to remove something that you selected, you can simply hold Ctrl then click the selected cell
How do I create a drop-down menu in Excel?
To create a drop-down menu in Excel, you will need to create a column with the items that you want to be in the drop-down menu. You would then select the cell where you want the drop-down menu to appear. you would then go to Data then Data Tools then Data Validation. In the Data Validation dialogue box, within the settings tab, select List as Validation Criteria. In the Source field, select the cells which have the items that you want in the drop-down. when you are finished click OK.
