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.

Bill Jelen's next MrExcel webcast, "Consolidating Data for Financial Reporting" is Thursday, July 14, at 2:00 Eastern Time. Click here for more details when they become available.

Excel Newsletter

52 Issues

300+ Excel
Solutions

Weekly 'how-to' videos
Subscribe Now

This Month in CFO

Spreadsheet Articles

Want the full story? Click here to read the entire article.

Community Center

Share a Tip

Ask a Question

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?

Share a tip Browse best tips

9 readers have shared spreadsheet tips on CFO.com

Latest Reader Posts

123

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.

Suggest a topic See all suggestions

65 CFO.com readers have suggested a column topic

Latest Reader Posts

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 cpa

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

Using the "Find" feature in Excel is nice to locate items quickly, but is there a way to use this or another function that will expand the search to … more

posted at 11:10 am ET on August 19, 2011
by David Horn

» See all suggestions

advertisement

Spreadsheet Tips

About MrExcel

Excel Newsletter

This Month in CFO

Spreadsheet Articles

Community Center

TOPICS

MEDIA

EVENTS

SERVICES

ABOUT CFO

Want the Magazine?