Final answer:
To drag down in Excel without changing numbers, use the right-click and drag method with the Fill Handle, and then select 'Copy Cells' from the context menu.
Step-by-step explanation:
To drag down in Excel without changing numbers, you can use the Fill Handle with a specific technique. Here's how you do it:
First, select the cell that contains the number you want to copy.
Move your cursor to the lower right corner of the cell until it turns into a plus sign (the Fill Handle).
Now, instead of just dragging down, you must right-click and drag down.
Release the mouse button and a context menu will appear. Select Copy Cells from this menu.
This will copy the exact value to all the selected cells without incrementing the numbers. If you want the format to be the same but not the values, choose 'Fill Formatting Only' from the context menu.
Remember that dragging down normally without holding a right-click will cause Excel to auto-increment the values by default.