If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you. At times, when dealing with an Excel workbook which consists of a great amount of worksheets, you may want to get the data size of each worksheet. However, there is not a native feature for this requirement. So, you need to use some workarounds, such as the following Method 1. Or you can use the much smarter Method 2 to get all...
Read more »
In an Excel worksheet, if data is entered in nonadjacent cells, you may discover it a bit troublesome to select and copy the data in non-blank cells. Now, in this post, we will introduce 2 ways to quickly select all non-blank cells. Excel users are frequently required to copy and paste data. However, sometimes, there may be some troubles. For example, there are multiple discontinuous blank cells in an Excel worksheet. In this case, it is a bit hard to select all the cells which have content....
Read more »
At times, you may want to batch apply the format of one chart to all the others in an Excel worksheet. In this article, we will expose 2 quick methods to you. Perhaps you have created a lot of charts in an Excel worksheet and these charts may be in different formats. For instance, some are pie charts, some are column charts and some are line charts. Now, you may want to unify the formats of all the charts. You wish to copy the format of a chart to all the other charts in the sheet. In general,...
Read more »
