Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

inserting rows at top

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Les Stockton - 27 Jan 2006 03:40 GMT
I've put together a gas mileage spreadsheet.  It's real simple.  I enter a
row and it calculates the mileage.  The thing is, it gets it's beginning
odometer reading from the ending odometer reading of the previous entry.  And
rather than start at the top of the spreadsheet and add new entries at the
bottom, what I'd like to do is add entries at the top.
How do I do this, and have my formulas in the new row?

1/3/2006    2.079    41.503077    19.963    168139    168589    450 22.54170215
                    168139       

These are rows 2 and 3.  I have a header row (1).

How do I insert a new row at 2, that will have the formulas and push these
two rows down, making them 3 and 4?
cycling-rod - 27 Jan 2006 15:22 GMT
I would record a macro, see here for instructions:
http://www.helpwithpcs.com/tipsandtricks/microsoft-excel-macro-tutorial.htm
Or, search Google for "Recording a macro excel" for further info..

Signature

cycling-rod

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.