Headers on Excel Combo Boxes

headers on combo box

You can use combo boxes to show a drop down list, either in a UserForm, or on a worksheet. Sometimes a list is easy to understand, like this one, which shows a part number and part name.

If the list has multiple columns, it might help if there is a heading for each column, like the one in the next screen shot.

You could probably figure it out without the headings, but it removes any potential confusion, if you show the labels at the top of the list.

Continue reading Headers on Excel Combo Boxes

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Change Single Column List to 2 Column Table

clean up imported list

On the weekend, I copied a list of blog names and URLs into Excel. On the website that I copied it from, the list was in 2 columns, but it pasted into a single column in Excel.

Having everything mixed together in one column wasn’t going to be very helpful, so here’s how I put it back into 2 columns. If you have a different solution, please let me know in the comments. Maybe there’s an even easier way to do this.

Add Headings and IDs

I wanted the site names in one column, and the URLs in another.

Continue reading Change Single Column List to 2 Column Table

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Excel Roundup 20140331

Excel for iPad

Last week, three Office apps were released for the iPad – Excel, Word and Powerpoint. Have you downloaded any of the apps, and tried using them?

If you’re not sure whether to download them, you can read Ed Bott’s review of the new apps – he’s quite impressed by them. Bill Jelen (Mr. Excel) also reviewed the Excel app, and you can see his report here. Bill lists what’s in the apps, and what’s missing.

In the video below, there is a short interview with Han-Yi Shaw, head of Microsoft’s Office Design Studio. For more details, click here to read

Continue reading Excel Roundup 20140331

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Least Informative Excel Message Ever

I’ve seen some confusing Error messages while working in Excel, and some rather cryptic ones. But yesterday, I saw the least helpful message ever, while working with a pivot table in Excel 2013.

The message was spread across the entire screen, and all it showed was the yellow warning symbol. I guess Excel was speechless, due to my bad behaviour.

Have you seen any useless messages in Excel? Or is it just me?

Don’t Move the Field

What had I done, to deserve this silent treatment? I was writing a post for my Pivot Table blog, about calculated items

Continue reading Least Informative Excel Message Ever

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Excel Images Change Size After Preview

I ran into an odd problem with images in Excel 2010 last week – after looking at the sheet in Preview, a small logo graphic grew big enough to cover the most of the data on the sheet!

Here’s how it looked before the Preview – just a nice, small-sized logo, at the top left of the sheet.

Check the Picture Settings

The first thing I did was check the picture settings – right-click on the picture, and click Size and Properties

Then, in the Properties category, make sure the image is set to “Don’t move or

Continue reading Excel Images Change Size After Preview

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Excel Roundup 20140324

You might have heard a thing or two about March Madness, even in you don’t live in the USA, and follow college basketball. David Ringstrom explains how to use Excel to manage March Madness.

Contextures Posts

Here’s what I posted last week:

Change the address of a named range, or create a dynamic range, so new items appear in drop down lists. Format a new pivot table in Classic Excel 2003 style, if you prefer the plain look, and drag and drop features from that version. Clear the data entry cells on a worksheet, without touching the formula cells.

Continue reading Excel Roundup 20140324

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest