Contextures News 20180306

Seating Plan in Excel

March 6, 2018

Create a seating plan, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That supports the free info on my site!

Quick List

Here's a quick way to make a long list of numbers or dates. For example, do this to create a list of 200 numbers (see the steps in the animated screen shot below)

  • In the Name Box, type a range the size that you need - A1:A200
  • Press Enter, to select that range
  • Type the number 1
  • Press Ctrl+Enter, to put a 1 in all the selected cells
  • In the second cell, type 2
  • Select the first and second cells
  • Double-click the fill handle, to create the long list of numbers

See more data entry tips on my website.

long list of numbers

Age and Height Part 2

In last week's newsletter, I asked what formulas you'd use to calculate age and height. Thanks for sending your suggestions, and you can download the hockey player solutions file to see the formulas.

To see what I did with that age and height data, take a look at my hockey player blog post.

hockey player data

Seating Chart

There's an Excel seating plan workbook on my website, and I just created a new version, which is easier to use. Instead of circle shapes, this plan uses doughnut charts - thanks to Oz du Soleil for that idea.

Also, the source list for the drop down names uses a different formula now - it shows used names at the end of the list, instead of removing them. That prevents data validation errors warnings on the sheet.

Click here to download the new seating plan, and it works in Excel Online too, when I tested in the desktop version.

seating plan

Excel Articles

Here are a couple of Excel articles that you might find useful or interesting.

Data Entry - Jan Karel Pieterse shows how to add an Info button for data entry cells. He uses Excel Styles and hyperlinks, but you could keep it simple and skip those steps. Add them later, it you want a fancier setup. (Level - Intermediate)

Macros - John Michaloudis is hosting a free VBA (macros) webinar this week (March 6 or 7), and he's offering a full VBA course, if you want to go further. Course registration ends March 9th, and use code XL for 20% off (Level - Intermediate/Advanced)

Also see: My Excel Products || Excel Events || Previous Issues || Excel Humour

Stay Organized

Our granddaughter was here on the weekend, and she likes to keep things organized. (She might get that from me!) On Saturday morning, she wrote out her plan for the day, starting with pancakes, and ending with "go to sleep". As you can see, we had a very busy weekend! The weather was cold but sunny, so we really enjoyed our walks, as well as all the indoor activities, like art and play.

weekly photo

That's it for this week! If you have any comments or questions, send me an email.

NOTE: For the online version, paste this URL into your web browser:
I'll also post any article updates or corrections there.

Debra Dalgleish
ddalgleish @

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.



Get weekly Excel tips from Debra


pivot power free






Last updated: May 4, 2018 3:27 PM