Select the cell (A4 for you example) then hover the cursor over the small solid square in the lower right corner of the selection border around the cell... when it turns to a thin black cross (plus sign), left click and drag down for as many cells as you want and then release the mouse button... the number in the cell will be copied down through all the cells you click/dragged across.I would like to enter the same number in a specific amount of cells, i.e. the number "14" in A4 needs to be entered down the next 17 cells. Is there an easier way than just doing the math in my head?
What math?
You can select A5:A21, type =A$4, and press CTRL + ENTER
Select the cell (A4 for you example) then hover the cursor over the small solid square in the lower right corner of the selection border around the cell... when it turns to a thin black cross (plus sign), left click and drag down for as many cells as you want and then release the mouse button... the number in the cell will be copied down through all the cells you click/dragged across.
What math?
You can select A5:A21, type =A$4, and press CTRL + ENTER
Press ALT+F11... this will take you into the VB editor... locate the Immediate Window (it should be showing at the lower part of the screen (if you do not see it, press CTRL+G to make it appear)... then put this inside that window...Thank you... but I would still need to figure out where 17 cells would end. I would like to just fill-in the following 17 cells without counting or doing math.
You could put this in A5, and fill it down a sufficient amount of rows, say to row 100
=IF(ROWS($1:1)>17,"",A$4)