#Tip - ctrl+down arrow - Dynamic Drop-down List

When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly.

A very good shortcut for this would be the ctrl+down arrow. It is an easy means to speed through repetitive data entry within a column.

Just one thing to remember, this shortcut does not work with numbered lists and here you need to type the entire number. Friends just try this tip while using your excel workbooks and do remember to share your tips that you thin are interesting and should be in the upcoming videos.

Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

Comments

Wildcard search and functions in Excel to Extract first name, last name ...

COUNT and SUM formula

Here is a simple explanation of the various COUNT and IF formulas Here are some of the simple COUNT and IF formulas: COUNT - Counts number of cells with numbers in a range COUNTA - Counts number of non blank cells in a range COUNTBLANK - Counts number of blank cells in a range COUNTIF - Counts if a criteria is met in a range COUNTIFS - Counts if multiple criteria is met in a range SUM - Sum of a range SUMIF - Sum of a range if a single criteria is met SUMIFS - Sum of a range if multiple criteria are met Watch the video to understand the working of these formulas Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1

Excel Is Simple

Search This Blog