Excel Nyheder

There are bad characters, musical spreadsheets, and more, in this month’s Excel news. AutoFit Specific Cells Quick Grand Totals Bad Characters Number Keypads Spreadbeats Monthly Photo New on Contextures Pivot Table Tips: Make your Excel pivot tables look better with these 3 quick layout tips. One tip – AutoFit Cells – is described below Overlap … Continue reading “Debra’s Excel News–July 2024”

There’s an Excel calendar, Excel lookup functions, and more, in this month’s Excel news. Excel Event Calendar Quick Ribbon Tip Excel Lookup Functions Excel and AI Monthly Photo Excel Event Calendar Long ago, I made an Excel holiday planning calendar that showed a list of events under each date. The calendar worked, but it needed … Continue reading “Debra’s Excel News – June 2024”

I’ve got an Excel  lookup functions question for you, in the quick poll below. And I’ve got some breaking news for you too! Contextures Monthly Newsletter First, here’s my news — I’m starting a monthly Excel newsletter, which I’ll send on the second Tuesday every month. That way, it won’t land in your inbox, while … Continue reading “Which Excel Lookup Functions Do You Use Most Often?”

Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you only think about saving, right after Excel crashes? Save, Save, Save After many painful experiences, I learned to save my work in Excel, every 5 … Continue reading “Excel File Auto Backup When Workbook Saved”

One of my favourite Excel features is a data validation drop down list. In just a couple of minutes, you can make a list of items, then make that list appear in a worksheet cell. It’s like magic! The drop down lists make it much easier to enter data, and they help prevent typos, or … Continue reading “Excel Dependent Drop Down Lists – Block Changes”