Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering lines
I am trying to enter lines of data and push other data down keeping the lines
properly numbered, for instance Jan, Feb, April checks are listed and I need to add in Mar. pushing April's down. Can not for the life of me figure this out and I Know it has to be simple!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering lines
I have a couple thoughts:
Do the checks have some kind of serialized information? check date, check number, etc. If yes, can you just append them to the list, then sort the list to get everything into the right order? Alternatively, you could just: Select the cell where you want the new data to begin Hold down the [Shift] key and press [Page Down] a few times Release the [Shift] key Then InsertRows Does that help? *********** Regards, Ron "dabowl824" wrote: I am trying to enter lines of data and push other data down keeping the lines properly numbered, for instance Jan, Feb, April checks are listed and I need to add in Mar. pushing April's down. Can not for the life of me figure this out and I Know it has to be simple!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
whole lines are disappearing before I finish entering data | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions |