Ms excel mein kaam karte hai to hume rows ya column ko hide ya unhide karna padta hai , taaki data ko manage ya present karna easy ho jaye. Aaj ke blog me hum jaanenge ki Excel ke important shortcut jo aapke time ko bachayenge aur productivity ko badhyenge.

✍Why Hide or Unhide Rows/ Columns?

• Presentation ke time irrelevent data ko chhupane ke liye.
• Print karne se pahle unwanted rows/ column ko hide karne ke liye.
• Data  ko temporarily simplify karne ke liye.
• Print karne se pahle unwanted row / column ko hide karne ke liye.

📌Shortcut to hide Rows and Column

1. Sbse phle ms excel me apna data open kar lenge.

(Ms excel ke Jis bhi workbook me data ke row and column ko hide Aur unhide karna hai vo data open kar lenge.)  

2. Ab hume jis bhi column ko hide karna hai us column ko select kar lenge (select karne ke liye Column me click karke shortcut key ctrl + space button press karenge.)

3. Ab column ko hide karne ke liye shortcut key ctrl +0 button press karenge.

To aap dekhnge ki column hide ho jayega.

📝Ab hum row ko hide or unhide karna sikhnge jiske liye sbse phle :-

4. To sbse phle  aapko jis bhi row ko hide karna hai sbse phle us  row select karenge . jiske liye shortcut key shift +space ka use karnege .

5. Ab  row ko hide karne ke liye ctrl +9 button press karenge

6. To aap dekhnge ki aapki row hide ho jayegi.

📌 Shortcut to Unhide Rows and Column

Ab hum Row or column ko unhide karna sikhenhge. To sbse phle row ko unhide karne ke liye apne table me kisi bhi cell main click kare aur shortcut key ctrl + A use kare jisse aapka pura data select ho jaye ga.

Ab rows ko unhide karne ke liye aap  shortcut key Ctrl +Shift +9 button press karenge jisse aapki row unhide ho jayegi .

Isi tarah coloumn ko bhi unhide karenge iske liye sbse phle table  ko select karenge Ctrl + A ki madad se .

Select kare ke baad shortcut key Alt +H ,O,U,L Button press krenge.

To aap dekhnge ki Column Unhide ho jayegi.

CONCLUSION

Excel mein hide or unhide bahut basic lekin powerful feature hai . Agar aap in shortcuts ko yaad rkhte ho ,to aapka data management aur presentation dono super fast ho jayega. Aise he aur bhi tricks or tips ke liye hume follow kare