About Bill Jelen

http://www.mrexcel.com

Posts by Bill Jelen:

Excel Screen Clipping Tool

               

If you need to insert part of a web page … or anything… into Excel. This feature is new in Excel 2010. Go to Insert, Screenshot. Ignore all of the window icons, but go to the bottom and choose Screen Clipping.   Here are some important steps: 1) Go to the web page that has the picture(…)

Excel Filter by Selection

               

There is a great Filter by Selection icon in Access. Excel offers the same functionality, but it is hidden and mislabeled! To add the command to your Quick Access Toolbar: Right click the QAT Choose Customize Quick Access Toolbar From the top left dropdown, change from Popular Commands to All Commands In the left listbox,(…)

Convert Excel Dates to Month Names

               

Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format. Try these: =TEXT(A2,”MMMM”) for full month name =TEXT(A2,”MMM”) for 3-letter month abbreviation =TEXT(A2,”DDDD”) for full month name =TEXT(A2,”DDD”) for 3-letter month abbreviation You can use any valid custom(…)

Excel Fill Alphabet or Roman Numerals

               

Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III? For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) Tip: After filling any of these,(…)

Excel Search Entire Workbook

               

You need to find something, but you don’t know what worksheet it is on.   Display Find with Ctrl+F Click the Options > > button. Open the Search dropdown and change from Sheet to Workbook.

Learn Excel from MrExcel