How do I autofill in excel using keyboard?



How do I autofill in excel using keyboard?..

Answer / Anshu Rathi

To autofill in Excel using the keyboard, follow these steps:
1. Enter the first value you want to fill.
2. Select the cell containing this value.
3. Press and hold 'Ctrl' key.
4. Press 'Shift' + 'Down Arrow' (or 'Up Arrow', 'Right Arrow', or 'Left Arrow') to fill in the desired direction.
5. Release all keys.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you compare two lists in excel and pull matching data?

1 Answers  


Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?

1 Answers  


What is difference between ms word and ms excel?

1 Answers  


What is a if function in excel?

1 Answers  


How do you copy a list of numbers from word into excel?

1 Answers  


What are basic excel skills?

1 Answers  


Where is pivot table in excel?

1 Answers  


How do you combine graphs in excel 2016?

1 Answers  


What is #name in excel?

1 Answers  


How do I format multiple sheets in excel?

1 Answers  


How do you categorize data in excel?

1 Answers  


Is index match better than vlookup?

1 Answers  


Categories