| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paging down to last entry
How do you page down to the last entry? Since I have formulas that do not
have any entries in them I want to page down to the last entry not the last formula. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paging down to last entry
Ctrl + End will take you to the last cell in the worksheet. Ctrl + Home will
take you to the first cell. Does this help? -- Rae Drysdale "Richard" wrote: How do you page down to the last entry? Since I have formulas that do not have any entries in them I want to page down to the last entry not the last formula. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paging down to last entry
Ctrl + End takes me to the last formula entered. since I've pasted the
formula down several thousand rows in advance, then I go back and enter data as needed but sometimes I need to go back to the last entry not the last formula. Kinda confusing? Thanks in advance! "Rae Drysdale" wrote: Ctrl + End will take you to the last cell in the worksheet. Ctrl + Home will take you to the first cell. Does this help? -- Rae Drysdale "Richard" wrote: How do you page down to the last entry? Since I have formulas that do not have any entries in them I want to page down to the last entry not the last formula. Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paging down to last entry
This *array* formula returns the row number:
=MAX((A1:A10000<"")*ROW(A1:A10000)) -- Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. Since it's an array formula, you can't reference entire rows (A:A) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Richard" wrote in message ... Ctrl + End takes me to the last formula entered. since I've pasted the formula down several thousand rows in advance, then I go back and enter data as needed but sometimes I need to go back to the last entry not the last formula. Kinda confusing? Thanks in advance! "Rae Drysdale" wrote: Ctrl + End will take you to the last cell in the worksheet. Ctrl + Home will take you to the first cell. Does this help? -- Rae Drysdale "Richard" wrote: How do you page down to the last entry? Since I have formulas that do not have any entries in them I want to page down to the last entry not the last formula. Thanks in advance! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paging down to last entry
Of course, I meant that you cannot reference entire *Columns* (A:A)!
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "RagDyeR" wrote in message ... This *array* formula returns the row number: =MAX((A1:A10000<"")*ROW(A1:A10000)) -- Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. Since it's an array formula, you can't reference entire rows (A:A) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Richard" wrote in message ... Ctrl + End takes me to the last formula entered. since I've pasted the formula down several thousand rows in advance, then I go back and enter data as needed but sometimes I need to go back to the last entry not the last formula. Kinda confusing? Thanks in advance! "Rae Drysdale" wrote: Ctrl + End will take you to the last cell in the worksheet. Ctrl + Home will take you to the first cell. Does this help? -- Rae Drysdale "Richard" wrote: How do you page down to the last entry? Since I have formulas that do not have any entries in them I want to page down to the last entry not the last formula. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate entry "x" number of times | Excel Discussion (Misc queries) | |||
| last non-blank column entry | Excel Discussion (Misc queries) | |||
| How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
| How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Linear Mode
