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
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
Post a Comment