I have data on the clipboard which I want to paste into multiple cells in a
column that is selected. When I Ctrl+V, it only pastes into the first cell.
How can I get it to paste into all the cells that I have selected?
Thanks . . . Walt
I have data on the clipboard which I want to paste into multiple cells in a
column that is selected. When I Ctrl+V, it only pastes into the first cell.
How can I get it to paste into all the cells that I have selected?
Thanks . . . Walt
click on the cell > right-click > select Paste Special> Text
should break it up for you...
"wrdennig" wrote:
> I have data on the clipboard which I want to paste into multiple cells in a
> column that is selected. When I Ctrl+V, it only pastes into the first cell.
> How can I get it to paste into all the cells that I have selected?
>
> Thanks . . . Walt
WHen I do that, the wizard sez the data on the clipboard is not the same size
and shape as the cells selected. If I click OK, it just pastes into the
first selected cell.
More help, please . . . TIA
"ufo_pilot" wrote:
> click on the cell > right-click > select Paste Special> Text
> should break it up for you...
>
> "wrdennig" wrote:
>
> > I have data on the clipboard which I want to paste into multiple cells in a
> > column that is selected. When I Ctrl+V, it only pastes into the first cell.
> > How can I get it to paste into all the cells that I have selected?
> >
> > Thanks . . . Walt
I was trying to do this but no success. But I notice when thing that can be
useful for you. When you copy data within from excel then you can paste into
multiple cells without any problem.
So, you can use a trick, see if it works.
Paste Clipboard data into Excel in a cell then copy that cell and paste it
into multiple cells.
Let us know, if the information was in any use.
"wrdennig" wrote:
> WHen I do that, the wizard sez the data on the clipboard is not the same size
> and shape as the cells selected. If I click OK, it just pastes into the
> first selected cell.
>
> More help, please . . . TIA
>
> "ufo_pilot" wrote:
>
> > click on the cell > right-click > select Paste Special> Text
> > should break it up for you...
> >
> > "wrdennig" wrote:
> >
> > > I have data on the clipboard which I want to paste into multiple cells in a
> > > column that is selected. When I Ctrl+V, it only pastes into the first cell.
> > > How can I get it to paste into all the cells that I have selected?
> > >
> > > Thanks . . . Walt
It works!! Thanks. Much easier than finding a way to do a script.
g'day . . .
"rajkohli" wrote:
> I was trying to do this but no success. But I notice when thing that can be
> useful for you. When you copy data within from excel then you can paste into
> multiple cells without any problem.
>
> So, you can use a trick, see if it works.
>
> Paste Clipboard data into Excel in a cell then copy that cell and paste it
> into multiple cells.
>
> Let us know, if the information was in any use.
>
> "wrdennig" wrote:
>
> > WHen I do that, the wizard sez the data on the clipboard is not the same size
> > and shape as the cells selected. If I click OK, it just pastes into the
> > first selected cell.
> >
> > More help, please . . . TIA
> >
> > "ufo_pilot" wrote:
> >
> > > click on the cell > right-click > select Paste Special> Text
> > > should break it up for you...
> > >
> > > "wrdennig" wrote:
> > >
> > > > I have data on the clipboard which I want to paste into multiple cells in a
> > > > column that is selected. When I Ctrl+V, it only pastes into the first cell.
> > > > How can I get it to paste into all the cells that I have selected?
> > > >
> > > > Thanks . . . Walt
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks