All Questions
3
questions
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 ...
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:
67
votes
11
answers
263k
views
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...