| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
suspend auto increment
You're welcome, sorry for the brain fart.
Bill Johnson wrote: Perfect! Thanks Bob. "Bob I" wrote: My bad, it's the Ctrl key, that switches the "increment" vs. copy. BUT, only have the box around one cell. Bill Johnson wrote: I left click the lower right corner of the cell I want to copy down and hold the alt key while dragging down over all the cells I want to copy to and Excel is still incrementing all the way down. When I right click and drag down, I get a menu that allows me to choose to copy or fill the series. "Bob I" wrote: Hold down the alt key. Bill Johnson wrote: I'm working in some rather large sheets with data generated from Pivot tables. To use the data I have to fill all the empty cells so I'm using the handle tool to drag down, copying the data as I go. In Year fields when I drag down the auto increment feature always takes the year and increments ... same with most of the fields where the last character is a numeral. I want to turn that off to save me steps. Barring a fix for the handle tool, is there a view of pivot tables that fills in every cell? That would be even better. Thanks in advance Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto increment | Excel Discussion (Misc queries) | |||
| DP Auto increment | Excel Worksheet Functions | |||
| Auto-increment cell values by one | Excel Worksheet Functions | |||
| How to auto-number (increment) invoices in Excel? | Excel Discussion (Misc queries) | |||
| Auto increment over multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
