Excel Sheet में Blank रॉ और कॉलम को कैसे Delete करें।

MS Excel में Blank रॉ और कॉलम को कैसे Delete करें।

Excel शीट में डेटा के बीच में दिये गये Blank रॉ और कॉलम को कैसे डिलीट करें।

[{"selector":"#anim-35006b6c-f14e-4a5a-9616-1635aed789e0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a740bfae-a0bd-4781-8893-ef127faa90f8","keyframes":{"transform":["translate3d(0px, 130.22224%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dc3c62c9-9491-4510-afe0-ede1a2228c6e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6c185fc7-fd1d-4d38-a76d-e78cb678e973","keyframes":{"transform":["translate3d(0px, 66.01009%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a204e5e4-9f3a-4814-a449-2182211d7b91 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-15.230712525368146%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

जब आप एक्‍सेल में डेटा फिल करते होंगे तो उसमें कुछ रॉ या कॉलम Blank रह जाते होंगे।

[{"selector":"#anim-82db1053-5bcf-445e-9f2b-67c843ba7477","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d1396afb-4b43-45c2-b101-9c63d7db77eb","keyframes":{"transform":["translate3d(0px, 66.01009%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4d16b830-893a-4c54-a7cf-0f81216d683f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-70748070-889e-4504-aa5e-c11d0ea3a6d0","keyframes":{"transform":["translate3d(0px, 123.45678%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d9af476e-a38b-484f-bd1e-d8a9c6b2268f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(43.125000071772604%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

तो आइये जानते है कि एक्‍सेल में Blank रॉ और कॉलम कैसे डिलीट करते हैं।

[{"selector":"#anim-c71625b4-1afd-475f-a8be-47c842a373c6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-33de4e8d-d0ce-4a05-97d9-4ebc36cb304b","keyframes":{"transform":["translate3d(0px, 66.01009%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-41e1c2a4-1d82-40bf-af4c-fa8c9320e4cd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a8950c53-f758-427c-b62a-88d1733cfbce","keyframes":{"transform":["translate3d(0px, 94.01709%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dde3bcdb-b03f-4c75-8b81-dc857459e10f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(31.249999886225726%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

इन्‍हें डिलीट करने के लिये कीबोर्ड से Ctrl+G का यूज करें उसके बाद Special पर क्लिक करें।

[{"selector":"#anim-3184b001-7ff4-4174-be1e-03c3dfcb186e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-db438f58-d192-4f6c-be73-295de06bf6d6","keyframes":{"transform":["translate3d(0px, 66.01009%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6fb203c5-b45a-473c-9595-917f07d34f06","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8bca7475-885f-4e12-a5a9-1377f428fe82","keyframes":{"transform":["translate3d(0px, 119.41637%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-014b57a9-02fa-424f-a5ac-a64489ca0671 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Special पर क्लिक करने के बाद Blanks पर क्लिक करें। जिसके बाद शीट में दिये गये Blank रॉ और कॉलम सलेक्‍ट हो जायेंगे।

[{"selector":"#anim-6ff18b76-54b6-4241-a0e2-c38f88bee85c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-443acae8-5f69-4a2b-acc0-8ac0752732d6","keyframes":{"transform":["translate3d(0px, 68.55448%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f8ec3ccb-357b-47b4-9630-207b7336f934","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-44610cce-5c25-44a1-9244-36961cf900bb","keyframes":{"transform":["translate3d(0px, 109.40173%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

इसके बाद कीबोर्ड से Ctrl+- शार्टकट का यूज करना है।

[{"selector":"#anim-3beec4ea-68c4-46b9-bf5f-1d126800baf6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b973768b-a84b-454b-858c-b6e49322d232","keyframes":{"transform":["translate3d(0px, 63.81130%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a06a9648-d628-4a3a-a432-2a3e5d3aa5fe","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9ae194a1-50d3-431d-b277-b3d7c63be54a","keyframes":{"transform":["translate3d(0px, 146.03173%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-289a752a-f4b5-4266-b2cd-b29f6e3c43cc [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(35.00304624864873%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

जिसके बाद रॉ या कॉलम में से जो भी डिलीट करना चाहते हैं उसको सलेक्‍ट करके ओके करें।

[{"selector":"#anim-cf05aebe-db2c-4274-b62a-3178b2424ea9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-75636fd8-927b-4161-8202-6ebec817afd3","keyframes":{"transform":["translate3d(0px, 68.55448%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a2bda6c0-cce0-422d-8408-59f145ddbfb3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1786805a-2507-481e-8435-28d9db1ec341","keyframes":{"transform":["translate3d(0px, 130.52751%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9cf0e624-d2b1-438f-a643-14a8169da99a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

इसके बाद शीट में से Blank रॉ या कॉलम डिलीट हो जायेंगे।

[{"selector":"#anim-1106e2c0-a6c7-436b-8845-6da5ade4a8c5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aa4bf558-a59a-4448-941f-6093da45099d","keyframes":{"transform":["translate3d(0px, 68.55448%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5ef89920-aec9-48c4-9636-07cfa9d4ebf2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-38170ca5-2fd3-44ac-af72-8f86b7e959f7","keyframes":{"transform":["translate3d(0px, 190.03266%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-54327398-941f-4bc1-b5fb-40ea46f604ec [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(31.21249988599818%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Thanks For Reading

[{"selector":"#anim-cdd6aad7-5a73-486b-bdb8-f4f0d5bf31dc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0f1cc6ea-fbed-45a7-a5f9-1f54088143a2","keyframes":{"transform":["translate3d(0px, 298.08852%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-369dc0c0-e2df-48bd-87d4-8591bb66a96b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6861cc78-6b4f-4f5b-a389-371daa5af8e1","keyframes":{"transform":["translate3d(0px, 681.03025%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c031087a-0de0-4dad-aeeb-cbc2e935358d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d222e61f-56f3-4336-813d-83aacb64b4e8","keyframes":{"transform":["translate3d(0px, 308.59793%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more