Call us on 01223 214177 or email us
In the first tip of this year I wrote how to use the drag and drop technique to move or copy cells. (See tip_530.php if you missed it.) The disadvantage of this method is that the Paste Options button won't be displayed, so you won't be able to perform special copy and paste operations "on the fly", such as converting columns to rows and rows to columns). That said, it still offers a great trick if you want to paste values, not formulas.
Here's how:
Related tips:
1. Tip # 530: Move or copy cells using drag and drop (
tip_530.php )
2. Tip #467: Display the Auto Fill Options on the fly (
tip_467.php )
3. Tip # 465: Keep the column width when pasting (
tip_465.php )
4. Tip # 35: How to quickly change columns to rows or rows to columns
(tip_35.html )
.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.