terewsun.blogg.se - Kutools for excel 2016 mactorrent

This feature will quickly set data validation to accept only IP address entries in the selected range(s). This feature is designed to set up data validation for selected range(s), which only allows Email addresses to be entered.

Only allow specific characters to be entered in a range of cells.

Easily prevent special or certain characters from being typed in cells.

This utility achieves the same function as Excel's Data validation feature, but you just need to select a single column and then apply this utility, then you cannot type in duplicate values in the same column. This utility can prevent entering duplicate data in a single column with one click. You can quickly unhide all the hidden ranges in active worksheet. If you move around your worksheet a lot, or if you have data you don't want readers to explore, this tool is convenient for you to limit the visible area of your worksheet to only that which has actual data. It's a fantastic way to set or limit the scrolling area in your workbook. This feature enables to paste the copied data into visible cells only, ignoring all of the filtered cells and hidden cells.

With this utility, you can quickly sort cells in a range randomly, to sort cells based on each row or column randomly, to sort entire row or column randomly, to randomly select cells, entire rows or columns. The formatting of cells will also be swapped, and the swap operation does not affect the formulas in the two ranges, and they continue referring to the original cells. You can quickly swap the cells or ranges on the same worksheet, on different worksheets or different workbooks. For example, you can't swap two columns with one column. The ranges for swapping must be identical in the same size. Quickly swap ranges, columns, rows, and cells in your workbook. With this tool you can transform the single-column of data into a five-column data table. For example, you may have a single column of data which contains your customer's information, and each customer consists of 5 rows information (such as, name, sex, Tel, Email, and Address). Quickly transform a vertical column into rows with multiple columns. With this handy Transpose Table Dimension utility, you can conveniently convert a cross (two-dimensional) table to a flat (one-dimensional) list at once, and vice verse. For example, if you have selected a column, containing the number 1, 2 and 3, this utility will reverse the order vertically to 3, 2, and 1. Flip Vertical Rangeįlip all cells in the selection vertically with one click. For example, if you have a row data, such as: 1, 2, 3, you can quickly reverse its order horizontally to 3, 2, 1. This is a handy tool for you to handle a large workbook with a bundle of worksheets.įlip all cells in the selection horizontally with one click. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to unhide all hidden workbooks one by one in Excel. Unhide all hidden workbooks with one click. If you have opened multiple workbooks in Excel, this tool allows you to quickly hide all the other inactive workbooks with one click. Normally you have to unhide all hidden worksheets one by one in Excel. Unhide all hidden sheets of the active workbook with one click. It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click. This feature will display the comment of the actively selected cell all the time, no matter where you move your mouse to. To minimize the ribbon, hide the status bar, the formula bar, and the ribbon. To minimize the ribbon, hide the status bar and the formula bar To minimize the ribbon and hide the status bar This utility has embodied 3 types of working area settings in your Excel as follows: One click will toggle all hidden sheets to be visible, click again will toggle all hidden sheets to be invisible in the current workbook. Quickly toggle all hidden sheets visibility in the current workbook. One click will show all hidden columns in the used range, click again will set all hidden columns to be invisible.

With this utility, you can quickly toggle hidden columns visibility with one click. One click to toggle hidden columns visibility in the used range. This feature adds a small icon at the leftmost of the Quick Access Toolbar to help you easily view and use the classic menu in Excel 2007 and later versions. Show Classic Menu on Quick Access Toolbar