Autocompleting Cells
If you have the numbers 1 and 2 in the first two cells, Google Sheets will recognize the pattern and continue the series (3, 4, 5, etc.).< Instead of dragging, you can double-click the blue circle, and Google Sheets will automatically fill the column down to the last filled row in the adjacent column.
The table will continue the sequence (3/1/2024, 4/1/2024, etc.).
Google Sheets will automatically continue the series based on the entered data, and this will work for days, months, or years.
If you enter 1/1/2024 and 1/2/2024, the table will continue the sequence by month: 1/3/2024, 1/4/2024, etc.
Kiitos palautteestasi!
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Kysy minulta kysymyksiä tästä aiheesta
Tiivistä tämä luku
Näytä käytännön esimerkkejä
Awesome!
Completion rate improved to 1.45Autocompleting Cells
Pyyhkäise näyttääksesi valikon
If you have the numbers 1 and 2 in the first two cells, Google Sheets will recognize the pattern and continue the series (3, 4, 5, etc.).< Instead of dragging, you can double-click the blue circle, and Google Sheets will automatically fill the column down to the last filled row in the adjacent column.
The table will continue the sequence (3/1/2024, 4/1/2024, etc.).
Google Sheets will automatically continue the series based on the entered data, and this will work for days, months, or years.
If you enter 1/1/2024 and 1/2/2024, the table will continue the sequence by month: 1/3/2024, 1/4/2024, etc.
Kiitos palautteestasi!
