ADDING NEW RECORDS IN EXCEL 2000

[CHASPILLS]

IN ACCESS, THERE IS AN ASTERISK WHICH YOU CHECK FOR
ADDING NEW RECORDS. CLICKING THIS ASTERISK BRINGS YOU
RIGHT TO THE BOTTOM OF THE DATA LIST WHERE YOU CAN ENTER
A NEW RECORD.

WHERE IS THERE A SIMILAR QUICK ICON OR LOCATION FOR
ADDING A NEW RECORD IN EXCEL 2000? ( OTHER THAN SCROLLING
ALL THE WAY DOWN TO THE BOTTOM OF THE LIST OF ALL
RECORDS )?

 

[Frank Kabel]

Hi
first lease turn off your CAPS-Lock: Difficult to read and considered
as shouting in newsgroups

For your question: AFAIK this is a new feature of Excel 2003

 

[Debra Dalgleish]

In Excel, if your data is in a list, you can use the Data Form.
Select a cell in the list, and choose Data>Form
Click the New button, and enter the data.

 

[Don Guillett]

Please don't SHOUT. It is considered to be impolite.
You can use the control+arrow down key or make a macro and assign to a
button.

 

[Guest]

Hi.

I wrote a macro for this problem and assigned it to a button at the top of the sheet in a frozen pane:

Range("A65536").End(xlUp).Offset(1, 0).Select

basically this selects the end of the sheet vertically then returns up to the last cell with an input.

or alternatively you could press CTRL+(arrow down)

regards
camron, UK