0

As shown in the following screenshot I have clicked across the headers of three columns:

enter image description here

But - as you might have also noticed - the first row entry on the third column seems to also in some fashion have been specially selected. That is causing an issue when the columns are "cut":

enter image description here

Note: when selecting a single column this issue does not arise: the specially selected cell does not show up - and the entire column may be cut and paste as expected.

So then - how to select all columns as a single selection that can be manipulated together - as for example cut and paste ?

I am on excel 15.39 on macos.

Improve this question
2
  • What version of Excel on what platform?
    – teylyn
    Dec 10, 2017 at 20:51
  • @teylyn yea- that's starting to look important - excel 15 on macos . have updated the OP.
    – WestCoastProjects
    Dec 10, 2017 at 21:12

1 Answer 1

Reset to default
0

The "Special selection" seems be the currently selected cell. It should not affect copy and paste possibilities.

What would affect the possibilities to copy is if you have Hidden rows.

Click the square just left of the "A"-column (above "1"-row) to select all cells. The right click above any row label and select "Unhide" in the pop-up menu.

Improve this answer
6
  • I have not done any hiding of columns. When selecting a single column this issue does not arise. I will update the OP.
    – WestCoastProjects
    Dec 10, 2017 at 20:18
  • I assume you meant "hiding of rows" (why not check anyway, mistakes do happen?).
    – Hannu
    Dec 10, 2017 at 20:36
  • There are no hidden rows.
    – WestCoastProjects
    Dec 10, 2017 at 20:38
  • Something to try: Select a cell OUTSIDE the columns you wish to copy, then select the columns, copy.
    – Hannu
    Dec 10, 2017 at 20:39
  • As mentioned in the update to the OP - cut/paste of a single one of the mentioned columns does work.
    – WestCoastProjects
    Dec 10, 2017 at 20:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .