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”
Un-filter the sheet first. Then select the whole sheet from the left top corner of excel(besides "A") and apply the filter. Check once then.
jitinm sorry that didn't work . what happened here is that some of the rows contents are shifted to the right eg. the marital status contents are shifter to the next column in kids_home. I just cannot think of a way to do it as i am not a regular user of excel.
- If its possible for you to share a sample sheet that would help much
jitinm https://learnermanipal-my.sharepoint.com/:x:/g/personal/subhranshu_nayak_learner_manipal_edu/EfoUHzPdhlxKs68wAD0-HnUB6sifNdTPzka-YUFoFQqbSA?e=ueNs9K
Here is the link for the excel file.
thank you for your help.
theInsiderall worked ok to me, see attached