If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Ads |
#2
|
|||
|
|||
Numbering on spread sheet
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 |
#3
|
|||
|
|||
Numbering on spread sheet
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 |
#4
|
|||
|
|||
Numbering on spread sheet
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 . |
#5
|
|||
|
|||
Numbering on spread sheet
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 . |
#6
|
|||
|
|||
Numbering on spread sheet
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 |
#7
|
|||
|
|||
Numbering on spread sheet
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 |
#8
|
|||
|
|||
Numbering on spread sheet
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). |
#9
|
|||
|
|||
Numbering on spread sheet
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). |
#10
|
|||
|
|||
Numbering on spread sheet
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 |
#11
|
|||
|
|||
Numbering on spread sheet
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 |
#12
|
|||
|
|||
Numbering on spread sheet
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 . |
#13
|
|||
|
|||
Numbering on spread sheet
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 . |
#14
|
|||
|
|||
Numbering on spread sheet
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 . |
#15
|
|||
|
|||
Numbering on spread sheet
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 . |
|
Thread Tools | |
Display Modes | |
|
|