Forum Discussion
Solved
Shifting of excel rows
So I want to shift all the rows /columns to the left .If you see that if i filter education columns now it will show that marital status has blanks. so, every content those cells are shifted to the r...
- Remove the filer
Go to 2nd cycle
Select the data next to it in D column
With right click select delete
Select “shift cells left”
jitinm with filter on if we try to delete it shows to delete the entire row .without the filter on we can delete that column and shift it . but here for other education types the placement of these columns are perfect.
if i try deleting with filter on then it is just deleting the entire rows
Remove the filer
Go to 2nd cycle
Select the data next to it in D column
With right click select delete
Select “shift cells left”
Go to 2nd cycle
Select the data next to it in D column
With right click select delete
Select “shift cells left”
- Thanks for your help and patience ,all my doubts are clear now 😄