Spreadsheet Tips

You are here: Home : Spreadsheet Tips

About MrExcel

Bill Jelen

CFO.com contributing editor Bill Jelen, known worldwide as "MrExcel", works with clients to design custom Excel applications, solve their Excel emergencies and provide tips and hints that help Excel users get the most out of their spreadsheet applications.

To view a list of Bill's upcoming live Excel webcasts click here or check out CFO's On Demand Excel library by clicking here.

Excel Newsletter

Excel Newsletter fan 75 px

52 Issues

300+ Excel

Weekly 'how-to' videos

Subscribe Now

New Digital Edition

Subscribe Now

Spreadsheet Articles

BootCamp 450 x 128

Community Center

    Share your tips with CFO.com readers here. No trick or hint is too small. Or take five minutes to browse tips from other readers. Who knows how many hours they might save you?

    9 readers have shared spreadsheet tips on CFO.com
    Latest Reader Posts
    posted at 10:13 am ET on June 7, 2011
    by Amanda Funderburke
    The formulas should read (A2:D2) instead of (A2:C2). Sorry for the confusion, but an edit function would be nice. :)
    posted at 10:07 am ET on February 12, 2011
    by Nicholas Cammarata
    Regarding pivot tables, I recommend that you always select empty cells to show zeros. The following example will illustrate why: First, consider … more
    posted at 10:02 am ET on February 12, 2011
    by Nicholas Cammarata

    » See all tips

    Suggest a topic or ask a question that you want Mr. Excel to address in an upcoming column. If your suggestion is published on CFO.com, we'll send you one of Jelen's most popular books as a thank you.

    66 CFO.com readers have suggested a column topic
    Latest Reader Posts
    Why would the GetPivotData command work for all columns but the last one? I have a spreadsheet in which I use VBA code to create a GetPivotData … more
    posted at 2:34 pm ET on June 11, 2012
    by John Collier
    Concatenate and place in specified length: Bill, Greetings. I have a very tricky issue. We are trying to set up an excel based journal entry … more
    posted at 12:37 am ET on November 2, 2011
    by Shrikant Sortur
    Just as you can select to repeat rows at the top of a page as you print it, is there a way to repeat rows at the bottom of a page as you print … more
    posted at 8:23 am ET on August 22, 2011
    by David Horn

    » See all suggestions