Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Zaid Mahadin
Date de publication: 2015/03/12
Mohammed Yaseen MBA  PMP®
par Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

SELECT THE  ROW OR THE COLUMN YO WANT TO DELETE 

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

Hossam EL Boghdady
par 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
par 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
par 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