answersLogoWhite

0

There are different ways. You could type in the numbers, which would be a slow way. You could use the fill facility. You could use a function, such a ROW(). It will always give you the number of the current row. If you wanted to start at number 1, but were not in row 1, then you could just adjust the value that row gives. So if you were in row 5 and wanted to get 1, then that is 4 less than the current row, so you would subtract 4 from row like this:

=ROW()-4

Then that could be copied down for more values.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you do Auto Save in Excel 2007?

You don't. "Auto" means automatic - Excel does it for you.


Is there an auto to set widths on excel columns?

yes


Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


What is the keyboard shortcut for the Auto-Sum feature on excel is?

Alt+=


What Excel feature automatically saves your workbook?

auto save


What is the definition of auto filter?

It is like a boss that in the excel it bad


How do you get merged cells to auto height with out a macro in Excel?

I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.


What is the bottom number on Microsoft Excel?

The last row number for Excel 2007 is 1048576.


What is a number that can be entered into a cell on Excel?

Which of the following is a number that can be entered into a cell?


Create Auto save macro in Excel?

In XLS 2003 you can simply turn the "Save AutoRecovery info" in EXCEL (Tools/Options/Save)


What is the path button to auto sum on Excel?

Home Tab/Editing Group


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000