Collaborate Disseminate
Charted zero values can have unintended results you can easily miss. Here are a few techniques you can use to hide and manage zeros in your workbook to keep that from happening. Continue reading How to Hide and Handle Zero Values in an Excel Chart
Sparklines are mini charts placed in single cells, each representing a row of data in your selection. But if Sparklines is missing or not showing up in your Excel spreadsheet when opening the file, this post will show you how to enable Sparklines in Ex… Continue reading Sparklines not showing up in Excel [Fix]
One of the most popular tasks in Microsoft Excel is filtering dates by month, or another particular criterion. However, there are times when the Excel date filter grouping does not work as intended, and as such, users may find that dates are no longer … Continue reading Excel Date Filter is not grouping by month [Fix]
Properties, also known as metadata, are information about a file. They include details, such as title, author name, subject, and keywords identifying the file content. In this tutorial, we will explain the steps to view a Properties dialog box in Excel… Continue reading How to view or display Document Properties in Excel
The Theme feature changes the color and size of the Excel spreadsheet. The Theme package consists of colors, font, and effects to change the appearance of your spreadsheet. But what if suddenly, you find that Excel themes are not applying or the Excel … Continue reading Excel theme not applying [Fix]
In Microsoft Excel, the Autocomplete feature helps users quickly automate the same text in multiple rows. In some cases, the Autocomplete feature will not work. In this article, we will explain what you can do if Excel Autocomplete is not working. The … Continue reading Autocomplete is not working in Excel [Fix]
If keyboard shortcuts are not working in Excel, here is how you can troubleshoot the issue. Whether it is one particular or multiple keyboard shortcuts, you can follow the same set of solutions to get rid of this problem. Before getting started, you ne… Continue reading Keyboard shortcuts not working in Excel [Fix]
While opening an Excel spreadsheet, if you get an error message saying External Data Connections have been disabled, here is how to get rid of it. It appears when Excel fails to fetch a few settings, such as Data Connections, Linked Data Types, Dynamic… Continue reading External Data Connections have been disabled in Excel [Fixd]
There’s no need to pay for expensive office software or subscriptions when a lifetime of documents, spreadsheets, presentations and PDFs is so affordable. Continue reading Get This Excellent MS Office Alternative While It’s on Sale for Just $40
Regular users of Microsoft Excel know about Workbooks and Worksheets, but do they know the differences? You see, many people confuse the terms Workbooks and Worksheets more often than not, and that is understandable because, from the outset, they appea… Continue reading Difference between Worksheets and Workbooks in Excel