» Insert or delete a Row/Column in Microsoft Excel
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
The tip submitted by Matthew Copeland, UK
To Insert Row/ Rows select cell/cells and Press Ctrl+
To Delete Row/Rows select cell/cells and press Ctrl-
Book Store:
Recommended Books:
- Understanding Financial Statements
- Marketing Plans That Work, Targeting Growth and Profitability
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Guide to Financial Reporting and Analysis
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
question
beena joshi Posted on: 31-12-1969
when we press ctrl+ and ctrl- to insert and delete the rows it show the delete and insert dialog box is it possible that we can delete or insert directly?
question from Beena
lkb Posted on: 31-12-1969
Highlight the whole row by clicking on the row label and that will eliminate the need for the insert/delete dialogue boxAdd/Delete row or column
JJ Posted on: 31-12-1969
Play on the keboard:
Select cell, press Ctrl+Spacebar and then Ctrl+ or Ctrl- to add/delete a column.
or
Select cell, press Shift+Spacebar and then Ctrl+ or Ctrl- to add/delete a row.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
