View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 65
Default A way to auto insert at top of each column with each entry?

If you need to scroll up to where the data is in the row that you're in, you
can press End + the Up Arrow, or End + the Down Arrow to scroll down to the
bottom of data in a column.

HTH,
Paul

"Channing" wrote in message
...
I have a lot of data I'm entering into a sheet like this:

A B C D
1 2 3
2 4
2
3
1
3

Simple. But some columns end up with little or nothing in them, some get a
hundred+ entries. When I enter something in "A", then need to enter the
next
value into "B", I have to move to the right column, scroll up or jump to
bottom, then enter. Back to A? Same thing. Lots of scrolling up and down.

Is there some way to set up a row at the top that's the "entry" row so
each
entry is in the same place vertically and the numbers pop down, as if I
hit
insert before each entry? Then I would only have to move left and right
and
the values would cascade down from that row. Kind of like doing a split to
keep the column titles at the top, this would keep the next empty cell of
each column at the top.

Does that make any sense? Any ideas?