Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Good Afternoon -
I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Multiple selections need to be done with the mouse
-- Regards, Peo Sjoblom "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Perhaps this:
1) Shift+SpaceBar.........to select an entire row 2) Shift+F8...............to engage "add" mode (visible in the status bar) 3) Use arrow keys to move to a different row 4) Shift+SpaceBar.........to select that entire row (now...here's the trick) 5) Shift+F8...TWICE.....to re-engage "add" mode repeat steps 3, 4, and 5 as needed. Caveat: One false step and you lose your selections. Consequently, if practical....enter an X in an empty flag column for each row to be removed. At the end of the process... Select that column Press [F5] .....Click [Special] .....Check: Constants .....Click [OK] (Now only the marked cells are selected) <edit<delete.....Check: Entire Row.....Click [OK] Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Ditto to Peo.
However, to select rows instead of columns, I believe the keyboard shortcut is Alt + Spacebar. Regards, Paul -- "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Oops.
Correction. That was supposed to be Shift + Spacebar. -- "PCLIVE" wrote in message ... Ditto to Peo. However, to select rows instead of columns, I believe the keyboard shortcut is Alt + Spacebar. Regards, Paul -- "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Very Nice!
-- "Ron Coderre" wrote in message ... Perhaps this: 1) Shift+SpaceBar.........to select an entire row 2) Shift+F8...............to engage "add" mode (visible in the status bar) 3) Use arrow keys to move to a different row 4) Shift+SpaceBar.........to select that entire row (now...here's the trick) 5) Shift+F8...TWICE.....to re-engage "add" mode repeat steps 3, 4, and 5 as needed. Caveat: One false step and you lose your selections. Consequently, if practical....enter an X in an empty flag column for each row to be removed. At the end of the process... Select that column Press [F5] ....Click [Special] ....Check: Constants ....Click [OK] (Now only the marked cells are selected) <edit<delete.....Check: Entire Row.....Click [OK] Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Thank you to all - it seems this process (while exactly what i asked for) -
is probably more work then the mouse clicking - BUT - i really like the idea of the x's... fantastic - thank you! "Ron Coderre" wrote: Perhaps this: 1) Shift+SpaceBar.........to select an entire row 2) Shift+F8...............to engage "add" mode (visible in the status bar) 3) Use arrow keys to move to a different row 4) Shift+SpaceBar.........to select that entire row (now...here's the trick) 5) Shift+F8...TWICE.....to re-engage "add" mode repeat steps 3, 4, and 5 as needed. Caveat: One false step and you lose your selections. Consequently, if practical....enter an X in an empty flag column for each row to be removed. At the end of the process... Select that column Press [F5] .....Click [Special] .....Check: Constants .....Click [OK] (Now only the marked cells are selected) <edit<delete.....Check: Entire Row.....Click [OK] Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Katie" wrote in message ... Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
I'm glad you liked that......Thanks for letting me know.
-------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Katie" wrote in message ... Thank you to all - it seems this process (while exactly what i asked for) - is probably more work then the mouse clicking - BUT - i really like the idea of the x's... fantastic - thank you! "Ron Coderre" wrote: Perhaps this: 1) Shift+SpaceBar.........to select an entire row 2) Shift+F8...............to engage "add" mode (visible in the status bar) 3) Use arrow keys to move to a different row 4) Shift+SpaceBar.........to select that entire row (now...here's the trick) 5) Shift+F8...TWICE.....to re-engage "add" mode repeat steps 3, 4, and 5 as needed. Caveat: One false step and you lose your selections. Consequently, if practical....enter an X in an empty flag column for each row to be removed. At the end of the process... Select that column Press [F5] .....Click [Special] .....Check: Constants .....Click [OK] (Now only the marked cells are selected) <edit<delete.....Check: Entire Row.....Click [OK] Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keyboard Navigation - selecting non-adjacent rows
Surely there is something in each row that would allow you to decide which rows
to select for deletion. How do you decide by eyeball which to delete? You should be able to filter to find these rows. Gord Dibben MS Excel MVP On Tue, 6 Nov 2007 09:23:01 -0800, Katie wrote: Good Afternoon - I am looking to navigate with keyboard only to highlight multiple rows to be able to delete these rows. For instance, I need to manually go through and decide in a 2000 row sheet and delete almost half of the rows, but in no consistent pattern. Is there keyboard shortcuts to select a row (Control + spacebar) and then be able to highlight to a new row and select that as well? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shorcut for selecting | New Users to Excel | |||
Selecting rows with keyboard | Excel Discussion (Misc queries) | |||
Keyboard shortcut or selecting entire column | Excel Worksheet Functions | |||
selecting adjacent cells | New Users to Excel | |||
selecting non adjacent cells | Excel Worksheet Functions |