Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilling in Pivot tables
Just got a quick questions, I've got about 50 different 4 digit numbers
in column A. Each 4 digit number can have about 3-9 blank rows between it. How can I autofill it?Currently I am just doing the double clicking and filling..but with 50 different numbers this can be very time consuming..is there a easier way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilling in Pivot tables
You can't fill those cells and still keep it a pivottable.
But you can convert to values select the table, edit|copy, edit|Paste special|values or even past to a new worksheet???? Then you could use the techniques at Debra Dalgleish's site to fill those cells: http://www.contextures.com/xlDataEntry02.html Gor_yee wrote: Just got a quick questions, I've got about 50 different 4 digit numbers in column A. Each 4 digit number can have about 3-9 blank rows between it. How can I autofill it?Currently I am just doing the double clicking and filling..but with 50 different numbers this can be very time consuming..is there a easier way? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilling in Pivot tables
Assuming that you mean column A in the source data table, there are
instructions here for filling blank cells: http://www.contextures.com/xlDataEntry02.html Gor_yee wrote: Just got a quick questions, I've got about 50 different 4 digit numbers in column A. Each 4 digit number can have about 3-9 blank rows between it. How can I autofill it?Currently I am just doing the double clicking and filling..but with 50 different numbers this can be very time consuming..is there a easier way? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronising pivot tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |