This quick data entry trick for Excel works best in a table where you already have quite a few entries. To see the trick, watch the short video below. There are written steps too, below the video.
Category: Excel tips
How to Add Emojis in Excel Worksheets
In the old days, we typed emoticons in our messages, to show a grin, or wink, etc. Now we use emojis online, and I finally learned how to add emojis in Excel too. Thanks to Wyn Hopkins who showed me this trick – my worksheets will never be the same! Also, thanks to Duncan Williamson, who shared a Sparklines trick.
Fun and Games with Excel 20190912
Even a normal day of working with Excel can be lots of fun (or not!), but today we’ll see a couple of different ways to enjoy fun and games with Excel. Or, at least, fun that mentions Excel!
Excel Roundup 20190711
It’s been a long time since the last Excel roundup, so here’s a new one! Check out these Excel links and articles, and I’m sure you’ll find a few interesting things to read.
Your Top Excel Tips For Beginners
On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the content ready, but wanted ideas from other people who have taught similar courses. What are your top Excel tips for beginners?
Preview Picture Problems in Excel
In the good old days of Excel, you could change a workbook setting, and see a preview picture of the file contents, before you opened it. That feature was available in Excel’s Open window, but has disappeared in newer versions of Excel. Here’s how to see Preview Pictures, and a warning about using them.
Confusing Options on Excel Status Bar
The Excel Status Bar shows you messages about what’s going on, while you work. Some of those messages are optional, and you can turn them on or off. Here’s how you can customize the Excel Status Bar, and see my notes on a couple of the options that were confusing.
How to Close All Excel Files
In Excel 2013 and later versions, each file opens in a separate window. Unlike earlier single-window versions, there is no Exit button or command, to close all the files, without clicking each window individually.
Excel Roundup 20181025
We’re well into autumn, here in Canada, so it’s time for another Excel roundup. To get Excel links and articles every week, sign up for my weekly Excel newsletter.
Happy Spreadsheet Day 2018
Happy Spreadsheet Day 2018! It seems like we just took down the decorations from last year’s party, and here it is again, our favourite celebration of the year.