I have a budget spreadsheet, and I enter various formulas in the rows for different expenditures. When I do, I then hover over the right side of the cell, grab the yellow dot, and drag to the right to fill to the right (each column is a weekly date). Ive don't this for a very long time, and never had a problem. All of the sudden, I try to do this today, and the yellow dot is only appearing on the top and bottom of the cell, but not the left or right. It does this for cells on every row, even though I've dragged to the right on all the cells in the past. Not sure what changed. Any advice?
edit:
If anyone comes across this post that's having the same issue, I found the cause. I had changed the row height to 12 from 15. The rows were not tall enough any more, and for whatever reason won't show the yellow dot that you need to grab and drag to fill right or left. So if you have your row height set to this small, and need to fill left or right, temporarily change the row height back to 15 or greater.
edit:
If anyone comes across this post that's having the same issue, I found the cause. I had changed the row height to 12 from 15. The rows were not tall enough any more, and for whatever reason won't show the yellow dot that you need to grab and drag to fill right or left. So if you have your row height set to this small, and need to fill left or right, temporarily change the row height back to 15 or greater.
Last edited: