Tips.Net > ExcelTips Home > Editing > Deleting > Quickly Deleting Rows and Columns
Quickly Deleting Rows and Columns
Summary: Keyboard shortcuts allow you to quickly perform routine tasks. One such task is the deletion of rows or columns. This tip explains how you can get rid of unwanted rows and columns very quickly, without once resorting to a mouse or menu. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
You probably already know how to completely delete rows or columns by using Excel's menu commands. Excel provides an even quicker way to delete rows or columns, however. All you need to do is select the row or column that you want to delete, and then press Ctrl+- (that's Ctrl and the minus sign at the same time). Excel removes the row or column from your worksheet, as directed.
Tip #2107 applies to Microsoft Excel versions: 97 2000 2002 2003
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.
Check out ExcelTips: Times and Dates today!
Save Time!
Have thousands of ExcelTips at your fingertips, on your own system. Answer your own questions or help support others. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site