The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells. To save time, I used something called End mode in combination with the arrow keys on my keyboard to quickly select all the cells I needed to change. Many of my own coworkers have never heard of End mode, so I thought you might not know about it either. It's a handy status bar option, and in my opinion it's often easier to use than fill down when you need to Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/09/06/speed-up-data-entry-tasks-by-using-end-mode.aspx
Sep 06 2011, 01:45 PM