📞 01223 214177 ✉️ karen@roem.co.uk
📞 01223 214177 ✉️ karen@roem.co.uk
This tip was meant to go out last week but my service provider threw a major wobbler, which took three days to sort out. (By the way, isn't it strange that being without an internet connection, which you didn't have the first 20 or 30 - or 60 - years of your life, is now a cause for panic and you end up working in your local gym's bar?) Anyway, here's a tip from one of my readers (thanks, Giovanni) who wrote about the magic of ALT in Excel.
As you may know you can drag the mouse to move and copy cells. (If you don't ... Simply select the cell(s) that is/are to be moved, point to the border of the selection, press and hold down the mouse button and drag the mouse pointer to the new location. To copy a cell or range of cells, hold down CTRL while you point to the border of the selection. When the pointer becomes a copy pointer, drag the cell or range of cells to another location.)
Giovanni emailed to share an alternative method to using the standard Windows cut and paste techniques to move or copy cells from one worksheet to another: use the magic ALT key.
Here's how:
Mind you, if you've ever accidentally dragged text to a different location, you can turn this feature off. (Now she says.) In Excel 2003 select the Tools menu and click Options. On the Edit tab, clear the "Allow cell drag and drop" check box. In Excel 2007 click the blob in the top left hand corner (AKA the Microsoft Office Button), and then click Excel Options, followed by Advanced. Under Editing options, clear the "Enable fill handle and cell drag-and-drop" check box.
.
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.
