This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you […]

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot […]

The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. See also: Complete […]

Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data, […]

Sometimes, you may need to dynamically insert blank rows between each of the existing rows into your Worksheet. Although blank rows are […]

You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a […]

If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. […]

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells […]

Sometimes if you need to find and replace cells formatting in Excel, how could you do? Find and Replace Format in Excel On […]

sometimes if you want to set the column width or row height to centimeters or inches for some purpose, how could you […]