Hi there,
We have just had a system update at work and since this Excel isn't allowing me to delete multiple rows by selecting 2 or more cells from the same column.
So for example, if I hold Ctr and select cell A1 and A3, usually I would be able to right click and select delete rows. If I try this now I get the error message, "This Can't be done on a multiple range selection. Select a single range and try again".
The same error will occur if I select all blank row using "Go to Special" and try to delete all rows.
I am using Office365 and it has probably updated since the system upgrade. Are there some settings somewhere that I need to configure to allow the deletion of multiple rows that are not sequential? Or is this an issue with the latest version of Office365? I have never experienced this issue before.
We have just had a system update at work and since this Excel isn't allowing me to delete multiple rows by selecting 2 or more cells from the same column.
So for example, if I hold Ctr and select cell A1 and A3, usually I would be able to right click and select delete rows. If I try this now I get the error message, "This Can't be done on a multiple range selection. Select a single range and try again".
The same error will occur if I select all blank row using "Go to Special" and try to delete all rows.
I am using Office365 and it has probably updated since the system upgrade. Are there some settings somewhere that I need to configure to allow the deletion of multiple rows that are not sequential? Or is this an issue with the latest version of Office365? I have never experienced this issue before.