Home > IT Answers > Microsoft Windows > numberig.............
Help

Question

  Asked: Jul 4 2007   6:57 AM GMT
  Asked by: aliyani

numberig.............


Microsoft Office

Hi,
Is there a way that I can numbering a column automaticaly such as numbering in the MS Word!!!?
Thank you.
----
Mahnaz

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 4 2007  7:39 PM GMT  by SheldonLinker




In DB2:

SELECT RRN(t),
______t.*
___FROM myTable t

or for more complicated queries:

WITH myView AS(
___complicated stuff goes here)
SELECT RRN(v),
______v.*
___FROM myView v

For Oracle:

SELECT ROWNUM,
______*
___FROM myTable

For more complicated queries in Oracle, nothing to worry about. RRN counts rows in the input table, but ROWNUM counts rows in the output result set.
---
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
+1-949-552-1904
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Microsoft Windows.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchEnterpriseDesktop.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

aliyani  |   Jul 7 2007  1:39AM GMT

Hi,
sorry of all,I forgot to say that I wanted to do numbering on a column in Excel such az in MS Word,when I click numbering icon it gets me a number for every row,when I goes next row it gets next number …..
Is it possible by writting a formula in excel for a Column!!!???
Could you help me!!!??
Thank you.
—
Regards
Mahnaz

 

PMiller78  |   Jul 17 2007  2:45PM GMT

This is taken from the Help file in Excel:

Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function.

Fill a column with a series of numbers

Note These numbers are not automatically updated when you add, move, or remove rows. You can manually update the sequential numbering by selecting two numbers that are in the right sequence, and then dragging the fill handle to the end of the numbered range.

Select the first cell in the range that you want to fill.
Type the starting value for the series.
Type a value in the next cell to establish a pattern.
How?

For example, if you want the series 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8…, type 2 and 4.

Select the cells that contain the starting values.
Drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) across the range that you want to fill.
To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

Is the fill handle missing?

To display the fill handle on a selection of cells, click Options on the Tools menu, click the Edit tab, and then select the Allow cell drag and drop check box.

Try that… I don’t think there is an actual “Auto Number” function to use.
Paul

 

PMiller78  |   Jul 17 2007  2:52PM GMT

Forgot to post this link:

Try this: <a href="http://office.microsoft.com/en-us/excel/HP011542321033.aspx?pid=CH010006321033" rel="nofollow">http://office.microsoft.com/en-us/excel/HP011542321033.aspx?pid=CH010006321033</a>