Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
I have some data that I would like to copy down and want to click the black
box in the lower right corner to do so. The problem is the data is a number and when I do it Excel assumes that I want the next row to be that number plus 1. Is there anyway that you can turn that off so that it copies the same number the entire way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
Greg,
That thing is called the Fill Handle. If you hold Ctrl, it will stop incrementing the numbers. Be sure you're still holding Ctrl when you release the mouse button. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Greg" wrote in message ... I have some data that I would like to copy down and want to click the black box in the lower right corner to do so. The problem is the data is a number and when I do it Excel assumes that I want the next row to be that number plus 1. Is there anyway that you can turn that off so that it copies the same number the entire way? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill
Right-click and drag.
Release the button and select "copy cells". Gord Dibben MS Excel MVP On Wed, 1 Nov 2006 14:40:02 -0800, Greg wrote: I have some data that I would like to copy down and want to click the black box in the lower right corner to do so. The problem is the data is a number and when I do it Excel assumes that I want the next row to be that number plus 1. Is there anyway that you can turn that off so that it copies the same number the entire way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill but with a custom rule?? | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill | Excel Worksheet Functions | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |