Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In Microsoft Excel what is the use of "Shift Cells Down" and "Shift Cells Right" options?

user-image
Question added by Shoaib Ahmed , Administration & HR Manager , Jobeco Group (FMCG)
Date Posted: 2017/01/11
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

Shifting cells down or right or left or up.

it one of the most important feature in excel.

let's say you have a list of items and you want to remove one item without changing the whole row. you can just remove the cell and shift the rest of cells up or down.

 

it will help to keep other columns an rows untouched.

hope this helps you.

Hicham Hariri
by Hicham Hariri , Project Engineer , Setraa Al Amal Manufacturing Co. (SAMCO) (Schneider Electric platinum partner for LV PanelBoard).

To insert a new cell with the same formula of the previous one.

More Questions Like This