I know this could be solved by using a formula and then CTRL+D, but unfortunately for this particular case I cannot use a formula.Īt the moment I just have to use the mouse to either highlight and drag the sequence down, or highlight and double click to automatically fill in the formula. A1 = A2 = A3 = etc.) and I want to drag these down so that the sequence continues, is there any way I can do this without using the mouse?įor example, say I have the dates listed above in cells A1:A3 and I want to continue this sequence for cells A4:A6, if I highlight the range A1:A6 and press CTRL+D it just copies the value from A1 into every cell. If I have a sequence of dates in a column (e.g. ![]() This is my first time posting to r/excel so sorry if this doesn't make much sense, I'm not sure if I'm using the correct terminology.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |