Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to quickly add and delete rows and columns in Excel - include using a keyboard shortcut ?

user-image
Question added by Zaid Mahadin
Date Posted: 2015/03/12
Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Project Controller , Hayat Communication (www.haytacommunications.com)

SELECT THE  ROW OR THE COLUMN YO WANT TO DELETE 

PRESS Alt + E + D (in all Microsoft  Office Version )

Hossam EL Boghdady
by Hossam EL Boghdady , HR, Payroll Supervisor , (TOP BUSINESS) human recourses consultants

to select the row : press shift & space

to delete it            : press ctrl & "-"

 

for the columns :

to select the column : press ctrl & space 

to delete the column: press ctrl & "-"

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

SIMPLY SELECT THE  ROW OR THE COLUMN YO WANT TO DELETE PRESS 

 

"CTRL" +" -"

Shahid Qureshi
by Shahid Qureshi , Assistant Manager - MIS / Financial Reporting / Agency Management in FRMU , Bank Alfalah Limted

first delete row or column by pressing "ctrl + -"and then press f4 for repetaion the deletion.

 

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.