Though Microsoft Excel is a popular spreadsheet application used by people of all age groups, it is largely used by professionals. Working people or computer users use this application extensively for storing and managing large amount of data. Shortcuts are always better way to save your productive time and Excel users many times require them for performing their work quickly.

This article is containing top five timesaving tips for MS Excel users:

1. Perform Multiple Insert and Multiple Delete: This tip is useful for those who work on a large Excel workbook and want to add multiple rows in-between the rows where data is already present. Clicking a row and inserting single row for n (n = number of rows you want to add) number of times is really a time-taking task. However, if you get a trick by which you can insert multiple rows at once, then you can save a lot of time. For this, you have to follow the below steps:

• a. Drag your mouse or highlight the rows before which you want to add rows. In this selection, select the number of rows that you want to add, and then right click. After this, click ‘insert’, and then multiple rows will be inserted in your Excel sheet all at once. This option adds the rows across the complete worksheet.
• b. For adding rows in a table, you just have to highlight the range of rows of this table and click ‘insert’. An alert box pops up; select ‘shift cells down’ radio button and click ‘OK’.

2. Replicate Specific Format or Style Several Times in Your Sheet: Have you ever encountered a situation wherein you want to replicate a font or color in more than one rows or columns of your worksheet? Copying and pasting the format for several times is hectic and time taking too. If you are facing this problem, then ‘Format Painter’ is the solution for you. Highlight a cell or a set of cells of which you want to copy and click ‘Format Painter’ provided at the toolbar of your MS Excel. A small paintbrush icon will appear, now drag this icon over the cells where you want to copy the formatting and you are done.

3. Use CTRL, Shift, Left, Right, Up, and Down Keys Instead of Mouse: Using these keys saves you lots of time as you need not use your mouse always for going up and down selecting and unselecting multiple rows or columns. If you use the arrow key with CTRL, you can do two things:

• If you are in-between the data selection, this combination will take you to the end of the data selection in any selected direction. Suppose, you are at 10th record of the worksheet of 2000 records, then CTRL with down arrow will take you down to the 2000 record immediately.
• If you are on a blank cell of a workbook, then this trick will take you to the next non-empty cell of the selected direction.

Using the arrow keys with shift key highlights all the cells coming in the direction, which allows lightning fast selection of the cells. The CTRL, Shift, and arrow keys allow you to select the complete data of a table.

4. Easy Comparison of Two Excel Sheets: Trying to compare two sheets by constantly switching sheets on one monitor is really a time-taking process. However, if you reopen an Excel sheet and drag this instance to other screen, it can solve your problem.

5. Find and Replace for Easy Working: Finding through ‘CTRL+F’ is one of the known functions for MS Office users, which is used for highlighting some specified data on a complete sheet. However, ‘Find and Replace’ does a great job in this line. By pressing ‘CTRL+H’ together, you get a ‘Find and Replace’ popup from which you can replace the data from multiple cells in one go.

If you start using these five tips vastly in your Excel while working, then you can certainly make your Excel more powerful, quick, and timesaving application than ever before.