Excel Dashboard and AutoFill Tricks
April 28, 2020
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
When you're working in Excel, the active cell has a Fill Handle -- a small black square at its bottom right corner. When you point to the Fill Handle, the pointer changes to a small black plus sign.
You can drag or double-click that Fill Handle, to automatically create entries in the adjacent cells. Here are 3 quick AutoFill tricks.
1) Fill Dates
To fill a series of dates in a column, follow these steps
2) AutoFill Options
Instead of double-clicking the Fill Handle, you can drag it down.
3) Insert or Delete
To insert or delete cells with the AutoFill handle, press the Shift key, then
There are more Data Entry Tips on my Contextures website.
Last week, I helped my daughter with an Excel project management workbook. The file was big and complicated, and the goal was to simplify things, and reduce errors and confusion.
Adding a dashboard can help with those goals, so I sent her a link to this new video from Mynda Treacy -- Excel Project Management Dashboard. The video is about 45 minutes long, and clearly explains the steps for setting up the dashboard, shown below. You'll get lots of great tips if you watch it.
Learn More: This week, you can get a 20% discount on Mynda's Excel courses, such as Power Query, Power BI, Excel Expert and Excel for Finance. She's an excellent teacher, so don't miss out on this deal!
Here are a few Excel-related articles that you might find useful or interesting.
Formulas: Yes, we get wind chill alerts in April, here in Canada. Kevin Lehrbass shows how you can calculate those temperatures with Excel formulas, in Fahrenheit and Celsius. (Level-Int/Adv)
Excel Resources: There's always something new to learn in Excel, so check out Rick and Jordan's list of 100+ best Excel websites and resources. (Level - All)
Excel Humour: See what people said about Excel recently. Could you talk about Excel for days?
There's not much happening in the garden yet, but a few of the spring bulbs have bloomed. These brave narcissuses (narcissi?) have survived several cold, windy days, and even a couple of light snowfalls. The rhubarb plant is sprouting too, and a clump of chives. And, of course, the lovage is back again -- nothing can kill that plant!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200428ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: April 27, 2020 2:55 PM