After inserting many comments in an Excel workbook, you may want to customize the fonts of all the comments. In this situation, you can refer to this article. Here we will share you 2 easy methods.
As we can see, the comments inserted in Excel automatically use the default font. At times, you may want to alter the comments' fonts. If there are a few comments, you can simply use the following Method 1 to manually change them. However, if there are hundreds of comments, you are better off...
Read more »
VBA is an excellent tool in Microsoft Office suite, including MS Excel application. It can assist you to accomplish a lot of tasks not supported by the native features in Excel. Now, in this article, we will teach you to run VBA code in Excel step by step.
If you intend to write some VBA codes to achieve some of your requirements, you have to firstly figure out how to run VBA code in your Excel. Now, thereinafter, we will use MS Excel 2010 for an instance to show the detailed steps,...
Read more »
If you would like to count the emails by sender, you can refer to this article. Here we will expose 2 quick approaches to you.
So as to know the most active sender for you, you may want to count the emails by sender. Although Outlook doesn't provide a direct feature for this, you still can seek some workarounds, such as the following Method 1. If you think the Method 1 is too tedious, you can opt for the Method 2. It is much more effective in that it uses VBA to quickly count emails by...
Read more »
