Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

How can you insert five columns or rows in excel by one step?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/04/18
Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

IF YOUR PAGE LEFT TO RIGHT: the by selecting five header names of columns or rows, the other five will be inserted if you clicked right click and choosed insert column row

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

Simply 

1- Select next five rows or columns by mouse

2- Right click 

3- Insert 

Nisar Hydar
par Nisar Hydar , Timekeeping / Payroll Supervisor , Sendan International Company Ltd

Select Five Columns and click on Insert Tab and than column. Or Select five columns press CTRL & + button and than select column and ok.

 

Padmavathi Duvvuri
par Padmavathi Duvvuri , HR Generalist , Banka Bioloo Private Limited

If you need to insert five rows or columns at a time, then select five rows or columns and right click and click on insert. So many rows or columns will get inserted.

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

Select5 columns and press CTRL+C then right click at any column index and choose insert copied columns.

More Questions Like This