Jan 1 2009

Top Posts in 2008

I’d like to wish everyone a Happy New Year.  Excel Hints had a great 2008 and hopes to make 2009 even better.  Thanks again to all our subscribers and visitors. 

Here are the most viewed posts of 2008:


  1. Hyperlink Formula in Excel
  2. ISNA, ISERROR, and ISBLANK Formula in Excel
  3. Excel Keyboard Shortcuts
  4. Excel Trim Formula
  5. Create a Drop Down Menu in a Cell
  6. Rank Formula in Excel
  7. Excel Length Formula
  8. Concatenate Formula in Excel
  9. VLookup in Excel
  10. Quick Way to Check for Duplicates in a Column

Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 


2 Comments on this post


  1. Dennis Horn said:

    The hint titled Summing Across Multiple Sheets is something I am interested in using. I tried to use it with the example provided and it did not work. Can you provide any more hints as to how to use this? I am trying to sum a cell from one sheet with a cell in the next sheet and have been having problems.

    January 2nd, 2009 at 9:12 am
  2. john said:

    Hi Dennis,

    Sorry it didn’t work for you. Try this and let me know if it works…

    Type: “=sum(” in the formula box, then click on the first cell you want to sum across the sheets. After clicking the first cell, hold shift and then click on the other sheet you want the sum accross. Hit enter and your formula should sum the two numbers. The final formula should look something like this: =SUM(Sheet1:Sheet2!A1).

    If that doesn’t work for you, can you post what your formula looks like when you finished?

    January 2nd, 2009 at 9:56 am

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks