Copying and pasing multiple cells (2000)

Topic

New Reply

On trying to copy and paste multiple cells l appear to be getting an error messgae, see attachement.

I have tried various methods to do this but no luck,i.e using shift.
I was told this in a previous posting.

Any help would be appreciated.

Reply | Quote

Replies

You asked this identical question in post 567,482 …

I presume (you do not show the row numbers) that the list has hidden rows or is filtered. This makes multiple selections.

Steve

Reply | Quote

I am sorry l am not sure what you mean? please can you explain a bit more clearly.

Reply | Quote

If some of the rows (or columns) in your spreadsheet are hidden, and you then select a range that includes some of the hidden cells, you’re actually selecting the visible cells only. That means that there’s a gap between the beginning of your selection and the end; as a result, you’ve selected more than one continuous area – a multiple selection.

Reply | Quote