ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When dragging a number down in Excel, how do we turn off the grow. (https://www.excelbanter.com/excel-discussion-misc-queries/53552-when-dragging-number-down-excel-how-do-we-turn-off-grow.html)

Carl

When dragging a number down in Excel, how do we turn off the grow.
 


Mladen_Dj

When dragging a number down in Excel, how do we turn off the grow.
 
Drag it by holding right mouse buton. When release it, you should get pop-up
menu with "Copy Cells", "Fill Series" and other options. Chose "Copy Cells".



Nick Hodge

When dragging a number down in Excel, how do we turn off the grow.
 
Or hold the Ctrl key while dragging

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mladen_Dj" wrote in message
...
Drag it by holding right mouse buton. When release it, you should get
pop-up menu with "Copy Cells", "Fill Series" and other options. Chose
"Copy Cells".





All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com