| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49514 | 2004-09-21 23:53:00 | deleting blank lines in Excel spreadsheet | k8smum (6062) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 274470 | 2004-09-21 23:53:00 | Does anyone know if there is a keyboard shortcut to do this, or a key combination? It's a b*...* nuisance going "Edit/Delete" all the time. Ta. | k8smum (6062) | ||
| 274471 | 2004-09-22 00:11:00 | <ctrl><-> (that's hypen, not minus) Which, I found by opening up MS Excel help and doing a search for "keyboard shortcuts". It's surprising what can be found in an application's help file ;) |
Biggles (121) | ||
| 274472 | 2004-09-22 00:16:00 | > <ctrl > <- > (that's hypen, not minus) > > Which, I found by opening up MS Excel help and doing > a search for "keyboard shortcuts". It's surprising > what can be found in an application's help file ;) Much appreciated. Who would have thought that a help file could actually be helpful? |
k8smum (6062) | ||
| 274473 | 2004-09-22 10:29:00 | Hi there I use the sort or the filter in the data menu to get rid of blank rows. You may need to modify the spreadsheet slightly but its easier than selecting separate rows and then deleting. Cheers Craig. |
Craigb (688) | ||
| 1 | |||||