Prev: Unknown Device: how to figure out what is that?
Next: XP gets hung up in "Windows is shutting down"
From: jwmtx on 13 May 2010 20:14
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

From: RobertVA on 13 May 2010 23:52
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

From: jwmtx on 14 May 2010 01:28
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
>
> .
>
From: Alan Edwards on 14 May 2010 02:09
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/newsgroups/en-us/default.aspx?dg=microsoft.public.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
<jwmtx(a)discussions.microsoft.com> 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
From: RobertVA on 14 May 2010 02:43

>>
>> 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).
 |  Next  |  Last
Pages: 1 2
Prev: Unknown Device: how to figure out what is that?
Next: XP gets hung up in "Windows is shutting down"