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. 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.
KUTOOLS FOR EXCEL 2003 WINDOWS
Windows: Windows 7/8/8.Show Classic Menu on Quick Access Toolbar.System Requirements and Technical Details With it, you can easily insert check box in a cell or range.A collection of tools make the selection of various items easier in Excel.Flip all cells in the selection vertically with one click.Flip all cells in the selection horizontally with one click.This utility will unmerge the merged cells in a range with one click.Merge adjacent cells that contain the same value in a single column with one click.A collection of utilities allow you to quickly process the following operations in ranges and cells.A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges.Quickly toggle all hidden sheets visibility in current workbook.Quickly toggle hidden columns visibility with one click.Easily take a glance at all the workbooks, worksheets, and switch between all of them.This utility has been renamed as Track Snap.Kutools for Excel is undoubtedly an incredible handy add-in which will save your time and effort.
KUTOOLS FOR EXCEL 2003 DOWNLOAD
You can also FREE download Macabacus for Microsoft Officeįor example, you can combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color, batch operations with one click in Excel and so on. It enhances and adds more than 200 advanced functions for you to easily cope with various kinds of tasks in Excel. Kutools for Excel 19 is the handy tool for you to simplify complicated tasks into a few clicks.
KUTOOLS FOR EXCEL 2003 FULL VERSION
Free Download Kutools for Excel 21 full version offline installer it Combines More Than 200 Advanced Functions And Tools For Microsoft Excel.
0 kommentar(er)
