1. Messages
  2. Excel 365: How to use autofill to make list of dates

Re: Excel 365: How to use autofill to make list of dates

Chris Mullins
 

 

Hi Brian

Type a date in cell a1, enter the formula “=A1+1” in cell a2, put cursor in cell a3 and press Control+d.  Hold down the shift key and use the down arrow to highlight all the cells you want to fill, then press Control+d again.    

Cheers

Chris

Sent from Mail for Windows

 

From: Brian Vogel
Sent: 26 August 2021 20:28
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel 365: How to use autofill to make list of dates

 

On Thu, Aug 26, 2021 at 02:04 PM, Chris Mullins wrote:

Put the cursor in the cell below the cell you want to replicate down the column and press Control+d,

-
But the initial query is not about replication, but auto-filling.  When I attempt to follow your instructions the CTRL + D results in the single cell above being duplicated in the present cell, but I cannot use the keyboard and down arrow to the last row in which I'd like the cell duplicated and have all in between be filled.

I will repeat, though, that these questions and answers have nothing whatsoever to do with NVDA.  This is really an office accessibility question that's utterly divorced from the screen reader being used.
 
--

Brian - Windows 10, 64-Bit, Version 21H1, Build 19043  

Nothing in all the world is more dangerous than sincere ignorance and conscientious stupidity.

         ~Martin Luther King, Jr.

 

 
Join nvda@nvda.groups.io to automatically receive all group messages.