More Things Bill Gates Never Told You

In my job with the County Engineer's Department, I had both fieldwork and a WHOLE LOT of paper work. Alas, the perils of having a government job. I had hundreds of documents in Word and Excel. By default, I was the office expert in Excel since I used it daily and sometimes nightly when I had deadlines. In compiling hundreds of worksheets in Excel with several lines of the same entry, I found it too much trouble and time consuming to use the "copy" method of left clicking the mouse and dragging to copy only a few lines down the column. I always disliked having to move my hands off the keyboard when I was on a roll. However, I found a much quicker keyboard shortcut. When you need to copy the above information in a column, just hold Ctrl and hit the " key. The above information will automatically be copied to the line below. It sure is easier to do this, than to keep dragging for only a few lines. As far as I know, I've never seen this shortcut in any manual. This shortcut will greatly benefit all office workers, especially those of you who work for the government because you will now have more time for coffee breaks. {;-)

+) Mike (+