Row Number Starting From 0

sunny.mohar · Mar 12th, 2002, 03:07 PM

Can I configure Excel to start from Row 0
instead of 1.

Thanks.

Russell Hauf · Mar 12th, 2002, 03:10 PM

May I ask why you would want to do this? And personally I don't think there is a way to do this.

sunny.mohar · Mar 12th, 2002, 03:19 PM

I have a sheet populated from an oracle
database.That table has two columns(of many) ,which have parent child relationship.If I want to insert a new record I add a new row, run some macros to protect data integrity as it kind of screws up the whole relationship.Fill other columns and insert into database.
Now since my column is always off by one hence it creates a little bit of confusion for other users to find what the parent number is, which is actually XLRow number-1.
First row is used for table columns.

thnx for your time.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 03:07 PM	#1
sunny.mohar New Member Join Date: Mar 2002 Posts: 3	Can I configure Excel to start from Row 0 instead of 1. Thanks.

Mar 12th, 2002, 03:10 PM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	May I ask why you would want to do this? And personally I don't think there is a way to do this.

Mar 12th, 2002, 03:19 PM	#3
sunny.mohar New Member Join Date: Mar 2002 Posts: 3	I have a sheet populated from an oracle database.That table has two columns(of many) ,which have parent child relationship.If I want to insert a new record I add a new row, run some macros to protect data integrity as it kind of screws up the whole relationship.Fill other columns and insert into database. Now since my column is always off by one hence it creates a little bit of confusion for other users to find what the parent number is, which is actually XLRow number-1. First row is used for table columns. thnx for your time.