Numbering on spread sheet

Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

Thanks RobertVA. In this one I can't highlight a cell number, or I don't know
how. When I try to highlight it does nothing to the number but highlights the
complete cell.
James


"RobertVA" wrote:

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

.

Thanks RobertVA. In this one I can't highlight a cell number, or I don't know
how. When I try to highlight it does nothing to the number but highlights the
complete cell.
James


"RobertVA" wrote:

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

.

You should get an answer at the Works newsgroup from the Works gurus.

microsoft.public.works.win

In a proper newsreader:
news://msnews.microsoft.com/microsoft.public.works.win

If you must use a web interface:
http://www.microsoft.com/communities...blic.works.win

....Alan
--
Alan Edwards, MS MVP Windows - Internet Explorer
http://dts-l.com/index.htm


....Alan
--
Alan Edwards, MS MVP Windows - Internet Explorer
http://dts-l.com/index.htm


On Thu, 13 May 2010 17:14:01 -0700, in
microsoft.public.windowsxp.basics, jwmtx
wrote:

Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

You should get an answer at the Works newsgroup from the Works gurus.

microsoft.public.works.win

In a proper newsreader:
news://msnews.microsoft.com/microsoft.public.works.win

If you must use a web interface:
http://www.microsoft.com/communities...blic.works.win

....Alan
--
Alan Edwards, MS MVP Windows - Internet Explorer
http://dts-l.com/index.htm


....Alan
--
Alan Edwards, MS MVP Windows - Internet Explorer
http://dts-l.com/index.htm


On Thu, 13 May 2010 17:14:01 -0700, in
microsoft.public.windowsxp.basics, jwmtx
wrote:

Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

"RobertVA" wrote:
I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

On 5/14/2010 1:28 AM, jwmtx wrote:
Thanks RobertVA. In this one I can't highlight a cell number, or I
don't know
how. When I try to highlight it does nothing to the number but
highlights the
complete cell.
James

While you can click inside an empty cell to enter a new value, you might
have to click a cell that already contains data then edit the content in
an edit bar between the tool bar and the main content pane. If the first
character is a letter the data type will be text. If the first character
is a number (or + -), the type will be some type of numeric. Entering an
equals sign will start the process of entering a formula.

Click inside a cell to select it. If you select a single cell its
content will be duplicated in the edit bar above the main content frame.
If the cell contains a formula, the result of the formula will be
displayed in the cell, but the formula will appear in the edit bar.

To select multiple cells press the mouse button while pointing to a cell
at one end of the range and hold it down (drag it) while moving it to
the cell at the other end of the range you want to select (the opposite
corner). Multiple cell selections (ranges) can be part of a column, part
of a row or a rectangle of cells.

Fills will be completed based on the mathematical relationship between
the two selected cells. If the two cells contain consecutive numbers
(1,2), the fill will be cosecutive (1,2,3,4). If alternating numbers
(2,4) the fill should be alternating (2,4,6,8). If dates (Jan 5, 2010;
Jan 19, 2010 two weeks apart) the fill should work with dates (Jan 5,
2010; Jan 19, 2010; Feb 2, 2010; Feb 16, 2010 each at two week intervals).

On 5/13/2010 8:14 PM, jwmtx wrote:
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting at
#1 it starts at #6. I realise I did it, but how can I change the numbering so
it is numerically correct? I want it to start at #1. Thanks very much.
James

"RobertVA" wrote:
I don't have that particular spreadsheet application, but many
speadsheets have a similar "Fill" function for that process. You could
probably find a description using the "Help contents" item on the
application's "Help" menu.

Try this procedure and PLEASE report back whether it works:

Enter a 1 in the first cell of your list

Enter a 2 in the cell immediately below

Highlight both cells

Keeping your mouse pointer in the same column, drag the little black
square on the lower right corner of the highlighted area downward
however many lines you want to be numbered

On 5/14/2010 1:28 AM, jwmtx wrote:
Thanks RobertVA. In this one I can't highlight a cell number, or I
don't know
how. When I try to highlight it does nothing to the number but
highlights the
complete cell.
James

While you can click inside an empty cell to enter a new value, you might
have to click a cell that already contains data then edit the content in
an edit bar between the tool bar and the main content pane. If the first
character is a letter the data type will be text. If the first character
is a number (or + -), the type will be some type of numeric. Entering an
equals sign will start the process of entering a formula.

Click inside a cell to select it. If you select a single cell its
content will be duplicated in the edit bar above the main content frame.
If the cell contains a formula, the result of the formula will be
displayed in the cell, but the formula will appear in the edit bar.

To select multiple cells press the mouse button while pointing to a cell
at one end of the range and hold it down (drag it) while moving it to
the cell at the other end of the range you want to select (the opposite
corner). Multiple cell selections (ranges) can be part of a column, part
of a row or a rectangle of cells.

Fills will be completed based on the mathematical relationship between
the two selected cells. If the two cells contain consecutive numbers
(1,2), the fill will be cosecutive (1,2,3,4). If alternating numbers
(2,4) the fill should be alternating (2,4,6,8). If dates (Jan 5, 2010;
Jan 19, 2010 two weeks apart) the fill should work with dates (Jan 5,
2010; Jan 19, 2010; Feb 2, 2010; Feb 16, 2010 each at two week intervals).

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James

Thanks to all of you. I will try these things and get back to you. I
appreciate your suggestions. James

"Don Schmidt" wrote:

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James



.

Thanks to all of you. I will try these things and get back to you. I
appreciate your suggestions. James

"Don Schmidt" wrote:

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James



.

Thanks, men. I've tried these suggestions, but none of them work for me. I'm
not very good at this anyway. I've got the spread sheet backed up on an other
drive. I think I'll just try to transpose it onto this one. Thanks for all
the help. James

"jwmtx" wrote:

Thanks to all of you. I will try these things and get back to you. I
appreciate your suggestions. James

"Don Schmidt" wrote:

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James



.

Thanks, men. I've tried these suggestions, but none of them work for me. I'm
not very good at this anyway. I've got the spread sheet backed up on an other
drive. I think I'll just try to transpose it onto this one. Thanks for all
the help. James

"jwmtx" wrote:

Thanks to all of you. I will try these things and get back to you. I
appreciate your suggestions. James

"Don Schmidt" wrote:

Lotus 1-2-3 user here but this may help you.

Place the mouse pointer on the number 1 (left of column A), left click and
drag down and include number 5.
Release click but with the pointer in the darkened area, right click and
select "Delete Rows".

Your sheet should now be displayed starting on row 1.

--
Don
Vancouver, USA


"jwmtx" wrote in message
...
Greetings; I am using XP and Works Suite 2003.
I have made a spread sheet listing a number of items. Instead of starting
at
#1 it starts at #6. I realise I did it, but how can I change the numbering
so
it is numerically correct? I want it to start at #1. Thanks very much.
James



.