have i mentioned that i love excel???? well, i do. that is aside, but i thought i'd just say it.
i spent some time today learning keyboard shortcuts for excel tasks i do all the time. i figure since my job entails me using excel about 90% of the time, these are worth knowing. also, my keyboard & mouse setup is not all that great, so using a mouse is annoying. but i have always hated using a mouse.
here are some of my faves:
shift+space: highlight entire row
alt + = : autosum function
ctrl + +: enter a new row
supposedly, ctrl+alt+V will open your paste special menu box. however, you then have to revert to the old keyboard trick of Alt + the applicable underlined letter, use your arrow keys, or transfer back to the mouse...so, still not the greatest shortcut key. anyway, i have a pretty custom menu bar for my paste special tasks. yes, i have to use the mouse...but customized menus are worth the pain!
i guess i will never know as much about excel as some of the bigger geeks out there; but, i can keep learning!
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment