But with Kutools, you can select multiple selected ranges at once. Multiple selected ranges is not possible with Excel only. This allows you to randomly select cells, entire rows and columns using Kutools for Excel. Instantly sort cells in range randomly based on each column and row. Make sure the ranges are of the same size as you cannot swap two columns with one column. Quickly swap the ranges, columns, rows and cells in your workbook or different workbook. The Transform range feature allows you to transform vertical columns into rows with multiple columns. Transform a single column of data into multiple column table and quickly transform columns into rows. This tool comes in handy for transpose utilities. Transpose Table DimensionsД¬onvert two dimensional table into one dimension and vice versa using Kutools for Excel. Suppose, you are having an order in range 1,2,3 you can change it to 3,2,1 accordingly. Reverse the order of the range vertically and horizontally only using a one-click function. The Kutools for Excel provides you with wide operations of ranges and cells that reduces your mass work. It often tricky to manipulate ranges for data entry and other operations. The work area can be adjusted to minimize and hide the status bar, formula bar, and the entire ribbon. You can hide the worksheets from your work area to keep a clean environment while you work. The one-click toggle hides the column visibility in the used range and also shows the column when in need. You can also adjust the work area as per your needs. This feature in Kutools for Excel allows you to quickly hide or show workbooks, worksheets and ranges. You can also preview any changes interactively before committing your work. With the view options, you can unclutter the workspace and improve your productivity. There are many optional tools on your screen that you might not be interested to use for the current data. Directly manipulate data using the data form dialog for individual row by row order. With the data form, you can add, delete and view your data for specified range or whole sheet. Data FormДЄdding, deleting and manipulating data has never been so easy. All of this can be done with a single click and you donвЂ™t have to save multiple copies of your workbook. With Kutools for Excel, you can save multiple snapshots of your working state and roll back to changes when needed. It is wise to save the current state of your excel workbook right after you have completed a task. You can also view long cell contents and edit individual cell using the unique window. The enhanced bar allows you to quickly manipulate the excel operations in a different window. The reading layout highlights the line and column of current cell to avoid minor mistakes. It is common to make mistakes while operating on large number of rows and columns. The navigation panel can be adjusted to any area and be activated or hidden depending on your requirement. You can also quickly navigate to a specific column and name in your workbook with one click. It also allows you to add quick advance features directly from the pane. The navigation pane lets you browse through your worksheets and workbooks with ease.

How to use kutools for excel 2003