How do I select a few cells of a column?

J

John Guin [msft]

There is a standard Windows copy tactic that will work.

To select the items in a column, you can double click each item in the
column while holding the CTRL key. When you paste, it will paste as a table
column.
 
R

Rainald Taesler

There is a standard Windows copy tactic that will work.
To select the items in a column, you can double click each item in the
column while holding the CTRL key. When you paste, it will paste as
a table column.

Thanks for posting this trick!
Had not yet come across that.

Rainald
 
A

Avrohom

John Guin said:
There is a standard Windows copy tactic that will work.

To select the items in a column, you can double click each item in the
column while holding the CTRL key. When you paste, it will paste as a table
column.


Sounds good John. I tried this.

But what I would like to do is select three cells in a column, 'cut', and
then 'paste' these three cells somewhere lower in that column.

I tried what you have suggested, but in order to paste, I cannot select
three cells lower down. Instead, One Note pastes these three cells as a
column all within one cell.

Any more ideas?
 
A

Avrohom

That's an interesting idea. I tried this just now.

It basically worked. The only problem in my case is that I have many cells
highlighted and/or tagged -- and this did not transfer into Excel. And
therefore it didn't transfer back either.

I have been so impressed with One Note in so many ways:

1. the notebooks and tabs at the top and the side are so wonderful to work
with!
2. and the way you can click anywhere on the page and move these boxes
around is ideal!

I just find this one aspect disappointing. I think this is very easy in Word
and Excel. Why does the selecting in One Note work so unusually?

Avrohom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top