Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Painting Range - extend the range on the top part
-- Shrikant |
#2
|
|||
|
|||
continue... ( I accidently pressed 'enter')
When I define the range by painting the cells, and when the cursor is on the last row of the range, i had a need to extend the range on the upper part by, say 2 rows. How do I move the curser to the top row without un-painting the selection ? -- Shrikant "Shrikant" wrote: -- Shrikant |
#3
|
|||
|
|||
By pressing Ctrl . (dot), I am able to move my cursor to the four corners of
the range without un-painting the range. However, this does not help in extending the range on the top row side. -- Shrikant "Shrikant" wrote: continue... ( I accidently pressed 'enter') When I define the range by painting the cells, and when the cursor is on the last row of the range, i had a need to extend the range on the upper part by, say 2 rows. How do I move the curser to the top row without un-painting the selection ? -- Shrikant "Shrikant" wrote: -- Shrikant |
#4
|
|||
|
|||
You have it almost all figured out. Pressing Ctrl-Period twice will make the
bottom row active. From there, all you need do to extend the painted range up by 2 rows is hold the shift key down while pressing the up arrow twice. "Shrikant" wrote: By pressing Ctrl . (dot), I am able to move my cursor to the four corners of the range without un-painting the range. However, this does not help in extending the range on the top row side. -- Shrikant "Shrikant" wrote: continue... ( I accidently pressed 'enter') When I define the range by painting the cells, and when the cursor is on the last row of the range, i had a need to extend the range on the upper part by, say 2 rows. How do I move the curser to the top row without un-painting the selection ? -- Shrikant "Shrikant" wrote: -- Shrikant |
#5
|
|||
|
|||
Thanks Duke Carey.
I got it. Earlier, I thought that I will be able to extend the range in the direction in which the curser is. Actually it turns out that the extension of the range is in the opposite direction. The logic of this solution is still not convincing. But I got the solution. -- Shrikant "Duke Carey" wrote: You have it almost all figured out. Pressing Ctrl-Period twice will make the bottom row active. From there, all you need do to extend the painted range up by 2 rows is hold the shift key down while pressing the up arrow twice. "Shrikant" wrote: By pressing Ctrl . (dot), I am able to move my cursor to the four corners of the range without un-painting the range. However, this does not help in extending the range on the top row side. -- Shrikant "Shrikant" wrote: continue... ( I accidently pressed 'enter') When I define the range by painting the cells, and when the cursor is on the last row of the range, i had a need to extend the range on the upper part by, say 2 rows. How do I move the curser to the top row without un-painting the selection ? -- Shrikant "Shrikant" wrote: -- Shrikant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extend a data range | New Users to Excel | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Extend data range format and formulas | Excel Worksheet Functions | |||
extend data range formats and formulas | Setting up and Configuration of Excel | |||
summing part of cells in a range | Excel Discussion (Misc queries) |