F8—Select a large range of cells without holding down that mouse button by clicking your starting cell, pressing F8 and clicking the ending cell. Range selected! Esc turns off the feature.
F9—See the resulting value of a formula in edit mode by pressing F9. Press Enter to effect a “past values.” It will convert your formula to its result. Undo or Ctrl+Z will get your formula back.
F11—Choose any chartable range and press F11. Excel will insert a new work sheet with this data charted in the default chart format. The Change Chart Type button will let you choose a different chart type.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34250/keyboard-shortcuts-excel-function-key "