Home WINDOWS This action won’t work on multiple selections

This action won’t work on multiple selections

0
This action won’t work on multiple selections

[ad_1]

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

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 action won't work on multiple selections - Excel error - Excel entries

This is an image showing the entries in Excel just like you may have them in your spreadsheet.

This action won't work on multiple selections - Excel error - Two groups selected

This is an image showing you the election of two groups with a space between them.

This action won't work on multiple selections - Incorrect selection for action

This is the incorrect selection that will cause you to get the This action won’t work on multiple selections error.

This action won't work on multiple selections - Selection with error message

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.

TheWindowsClub Icon

[ad_2]

Source link

www.thewindowsclub.com

LEAVE A REPLY

Please enter your comment!
Please enter your name here