Auto-complete data

While working with excel, you would have been thinking if there was an easy way of repeating entries which were previously entered in the column.  The first action you would take is to copy the contents of the previous cells and repeat them in the current cells. If the column is not too long, its fine. But sometimes if the column has loads of data and runs into many rows, you would have to scroll up the sheet each time to copy that entry (if it cant be typed manually) and again scroll down to the current cell to paste it. This is not only time consuming but also can become a headache after doing it several times.

You actually have a better way of doing it.  Any time you want to repeat previously entered data in a column, simply press Alt+Down arrow and you will get a list of all the data already present in the column.  You can use the arrow keys to select an item and then press Enter.

If you want to use the mouse, right click on the current cell and select “Pick from Dropdown List” and choose an item to enter in the cell.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube