Preenchimento automatico

How to Autofill in Google Sheets Without Dragging by Using Keyboard Shortcuts

You can use keyboard shortcuts to autofill formulas instead of dragging. All you have to do is:

1. Highlight the cells you wish to autofill, including at least one with the formula you wish to autofill

2. Use one of the following keyboard shortcuts:
   Fill Right: Ctrl + R
   Fill Down: Ctrl + D
   Fill Range: Ctrl + Enter (For Mac OS, use the ⌘ button instead of Ctrl)

If you want to autofill an entire column with a formula:

1. Put the formula into the first cell in the column

2. Click on the column header

3. Press Ctrl + R