# 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.

### 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.

### 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.

### 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.

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

I'll also post any article updates or corrections there.

Debra Dalgleish
ddalgleish @ contextures.com

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.

Last updated: May 4, 2018 3:27 PM