All Questions
Tagged with microsoft-excel-2016 copy-paste
10
questions
0
votes
2
answers
1k
views
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
For every cell in the “Sales Sheet” that is blank, the corresponding ...
- 1
0
votes
2
answers
1k
views
How can I get consistent copy/paste behavior when copying data that spans hidden columns
I'm trying to copy data from selected cells, all in the same row. One of the columns in the middle of the selected range is hidden (hidden, not filtered). When I copy, the data is copied only from the ...
- 158
0
votes
1
answer
96
views
How to paste sparse columns so they line up with existing data?
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test ...
- 208
0
votes
1
answer
277
views
Copy and paste loop in Excel
In Excel I would like to have a macro which does the following 100 times:
Copy the range A1:F4
Paste to A7:F10, i.e. leaving two empty rows
Then copy A7:F10, i.e. copy what was just pasted
Paste to ...
- 1
3
votes
2
answers
5k
views
Missing Paste (P) option in Excel 2016
I'm copying some data from a webpage which is tabulated. When I click Ctrl+C in Excel 2010 and Ctrl+V to paste, it pastes correctly.
However, in Excel 2016, the Paste (P) option is not there.
Only - ...
- 131
0
votes
2
answers
546
views
Excel will paste the last thing copied in Excel, not the most recent thing in the clipboard (pic included)
I am trying to copy data from another program and then paste it into excel. If I have previously copied something in Excel, and the green flashing border is still visible, it will paste what I had ...
- 175
1
vote
1
answer
951
views
How to copy data from a CSV file opened in Excel, into a Word table?
I'm using MS Office 2016, and I have a CSV file 2 columns, that I wish to copy into an existing table within Word, also with 2 columns, i.e. a 1 to 1 paste from Excel to Word, following with the ...
- 177
2
votes
1
answer
5k
views
MS office 2016 excel paste values with transpose
Is it possible to make this paste option (paste only values with transpose at the same time). As it shown on the schreenshot:
and having one button for this option in drop-down menu here:
- 336
0
votes
1
answer
99
views
How to copy from a normal Excel column and paste into compressed column of another Excel file
I have the following excel sheets:
sheet#1 - all rows present
Row_id Var1
1
2
3
4
5
6
sheet#1 - some rows compressed/filtered (not longer visible)
Row_id Var1
1
2
4
...
- 159
3
votes
1
answer
4k
views
How to disable “marching ants” from overriding my external clipboard data in Excel 2016?
Did the copy-and-paste behavior change in Excel 2016?
Every time I want to copy something from an external application, I have to press Esc first in Excel 2016 to cancel the marching ants (selection ...
- 1,061