Use the Visible Cells Command in Excel to Paste Subtotal Results

Earlier this week a client asked me to help her paste the Subtotal results to a new Excel workbook. She was frustrated and nearly hysterical because her manager needed the results in an hour. If you work with Subtotal reports in Excel I am sure that you share my client’s frustration.

The key to making this work is to use the “Visible Cells Only” command before you copy your selection. You can find this command on the “Find and Select” drop-down menu. If you like keyboard shortcuts, you can use Alt + ; for this command. However, remember to make your selection first!

Watch me demonstrate how this works in this short 4 minute 58 second Excel Video Lesson. You can also view it on iTunes and on my YouTube channel. This is one of the tips that I share on my DVD, “The 50 Best Tips for Excel 2007.”

Learn how you can “Master Excel in Minutes – Not Months!”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind