When I write one into one cell (B1) and two into the cell below of it (B2) like the shape 1, and select both from up to down and then pull the fill handle of the lower right corner until B7, I expect these cells are filled from one through seven. But it just copies those one and two.
When I pull the fill handle by right clicking, the Fill Series is grayed out in right click options! As well as, the Series dialog box (Home > Editting group > Fill drop-down list > Series) seems normal.
What is the problem? Why fill handle doesn't work please?