![]() |
#1
|
|||
|
|||
![]()
I have been doing data entry in excel 2007 for about an hour now and I've inserted a new row for each receipt. My problem is that I can't insert a new row now even though I just did about thirty seconds ago. I've checked other forums and solutions haven't worked for me. Please help me, I'm starting to panic.
|
#2
|
||||
|
||||
![]()
Hi k1w1999,
Why are you inserting rows? Is there a reason you can't just move down one row at a time? Excel 2007 supports 65536 rows in compatability mode, and 1048576 rows in native mode. So, unless you've done a great deal of data entry, I doubt you've used up all the available rows. The most likely explanation is that you already have something on the last available row. What row do you end up on if you press Ctrl-End? Is there anything on that row between whatever column you ended up in and column A?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
I'm trying to keep the dates in order, unless there is a way I can have excel reorganize them for me.
|
#4
|
||||
|
||||
![]()
You can sort the dates with the Data Ribbon - Sort and Filter
|
#5
|
||||
|
||||
![]()
As Pecoflyer says, Excel can easily re-sort the data after you've input it. You still haven't told us the answer to the other questions I posed, though, so we can't tell you anything more about why you can't add more rows.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
![]()
When I press ctrl + end, I end up on row 104. Between 104 and 1 are all the entries I've made using data from the receipts. The problem is now fixed and I thank everyone who helped me out. I guess I need to study excel literature a little bit more so I don't give myself a heart attack.
|
#7
|
||||
|
||||
![]()
If OK, you can mark the thread solved using the Thread Tools in the menu bar
|
![]() |
Tags |
insert, row |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rockwellsba | Word VBA | 2 | 05-31-2011 01:07 AM |
![]() |
kali90 | Outlook | 5 | 05-12-2011 02:56 PM |
![]() |
markg2 | Word | 5 | 01-04-2011 11:03 AM |
![]() |
PKTEE | Word | 1 | 10-24-2009 05:55 AM |
![]() |
sussertown | Office | 4 | 06-16-2009 06:04 AM |