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. 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 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

Kutools tutorial for excel