Seating Plan in Excel
March 6, 2018
Note: For some products mentioned below, I earn a commission on sales. That supports the free info on my site!
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)
See more data entry tips on my website.
To see what I did with that age and height data, take a look at my hockey player blog post.
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.
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)
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.
NOTE: For the online version, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2018/20180306ctx.html
I'll also post any article updates or corrections there.
ddalgleish @ contextures.com
Last updated: May 4, 2018 3:27 PM