fill does not work for me what can I do

[Jeff]

I have 2 columns I need to fill automatically and the help directions
using the fill handle just do not work for me. I've tried repeatedly
with no effect.

I am using Excel 2007 in Windows 7 64 bit. I checked Excel options and
the drag fill options are selected. But nothing I do seems to work.

Is there some other way (using menu options) to fill a series of cells
without using the drag fill tool?

Here is what I need to fill:
- One column starting with 1 and increasing consecutively.
- One adjacent column that would start with 500 and increase
consecutively by 1 through the column.

Any help appreciated.

Jeff

 

[Jeff]

I have 2 columns I need to fill automatically and the help directions
using the fill handle just do not work for me. I've tried repeatedly
with no effect.

I am using Excel 2007 in Windows 7 64 bit. I checked Excel options and
the drag fill options are selected. But nothing I do seems to work.

Is there some other way (using menu options) to fill a series of cells
without using the drag fill tool?

Here is what I need to fill:
- One column starting with 1 and increasing consecutively.
- One adjacent column that would start with 500 and increase
consecutively by 1 through the column.

Any help appreciated.

Jeff

Right after I sent out the question I discovered the menu toll to do it.
That part works fine. Sorry.
Jeff

 

[Jim Cone]

Fill in the values for the first two cells (500 and 501) and select both cells.
Then drag down (the bottom right corner) to fill.
Also, check under "Excel | Options | Advanced" that "Enable fill handle and drag and drop" is
checkmarked.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30 different ways to sort in excel)




<[email protected]>
wrote in message

 

[Gord Dibben]

I would try to ascertain why my fill handle does not work.

A couple of things to try.

1. Enter 1 in A1, 2 in A2. Select both cells then drag down.

2. Enter 1 in A1. Right-click and drag down to A10. Release button and selet
"Fill Series" from the options.

If those fail, enter 1 in A1.

In namebox type A1:A10 then hit Enter key.

Home Tab>Editing..........click on Fill Icon and select Series>Linear

Note the options for Step Value.


Gord Dibben MS Excel MVP

 

[Jeff]

I would try to ascertain why my fill handle does not work.

A couple of things to try.

1. Enter 1 in A1, 2 in A2. Select both cells then drag down.

2. Enter 1 in A1. Right-click and drag down to A10. Release button and selet
"Fill Series" from the options.

If those fail, enter 1 in A1.

In namebox type A1:A10 then hit Enter key.

Home Tab>Editing..........click on Fill Icon and select Series>Linear

Note the options for Step Value.


Gord Dibben MS Excel MVP

Aha. I was doing the drag wrong.
This worked:

1. Enter 1 in A1, 2 in A2. Select both cells then drag down.
2. Enter 1 in A1. Right-click and drag down to A10. Release button

Here is a harder one. Don't know if it is possible.
A column has names of speakers and the next column the lecture titles
they will give. Because each speaker may give more than one lecture the
speaker name column may have the same speaker name listed several times
before going to the next speaker.
Is there a way Excel can assign a unique number to each speaker? Fill
would give each speaker as many numbers as the lectures he/she gives.
Jeff

 

[mp]

apparently on my old version - excel 2002 - it's under
tools|options|edit and is just "Allow Cell Drag and Drop"

 

[Pete_UK]

Hi Jeff,

just post a little example showing what data you have and what you
would like to be done to it.

Pete

 

[WallyWallWhackr]

Hi Jeff,

just post a little example showing what data you have and what you
would like to be done to it.

Pete

Pivot table.

Tallies together like entries.

I have a time tracking workbook that uses a pivot table to tally daily
work which always includes multiple entries for tasks as I get bounced
around a lot.

I'd say there are probably other ways I could do it, but this worked,
so I stopped pursuing other methods.

http://office.microsoft.com/en-us/t...-expenditure-log-job-tracker-TC030008309.aspx

or

http://tinyurl.com/24rgy67

 

[Jeff]

Pivot table.

Tallies together like entries.

I have a time tracking workbook that uses a pivot table to tally daily
work which always includes multiple entries for tasks as I get bounced
around a lot.

I'd say there are probably other ways I could do it, but this worked,
so I stopped pursuing other methods.

http://office.microsoft.com/en-us/t...-expenditure-log-job-tracker-TC030008309.aspx

or

http://tinyurl.com/24rgy67

Thank you will explore

 

[Jeff]

Pivot table.

Tallies together like entries.

I have a time tracking workbook that uses a pivot table to tally daily
work which always includes multiple entries for tasks as I get bounced
around a lot.

I'd say there are probably other ways I could do it, but this worked,
so I stopped pursuing other methods.

http://office.microsoft.com/en-us/t...-expenditure-log-job-tracker-TC030008309.aspx

or

http://tinyurl.com/24rgy67

Where do I download it from? Can't find it in the download section.

 

[WallyWallWhackr]

Where do I download it from? Can't find it in the download section.

I do not think it forces you to be 2007 version. I am not sure, but
the Template web site link I gave you is my workbook link, I
thought...

Yep.. just verified. The DL link button is at the top of the page
in the Silver bar at the right side.