Very Use-full MS-Office Short-Cut Keys

Very Use full MS-Office Short-Cut Keys नमस्कार दोस्तो इस पोस्ट में मैने MS-Office से Related  कुछ Short-Cut Keys के बारे में बात की है उम्मीद है कि  ये Post आपको अच्छा लगेगा ।

• Alt + H +O+A ➨ For Auto Fit Row.
• Alt + O +C+A ➨ For Auto Fit Column.
• Alt + H +B+A ➨ For Apply all border to Selected Areas.
• Alt + H +B+N ➨ For Remove Border to Selected Areas.
• Alt + F+A ➨ This is the Best Method for Save as.
• Ctrl + Shift + L ➨ For Apply Filter.
• Alt + A+S+A ➨ For Sorting Data Ascending Wise.
• Alt + A+S+D ➨ For Sorting Data Descending Wise.
• Ctrl + Space ➨ For Select One Or More Column.
• Shift + Space ➨ For Select One Or More Rows.
• Ctrl + L ➨ For Creating Table of Data Sheet.
• Ctrl + 9 ➨ For Hide Selected One Row or More Row.
• Ctrl + Shift + (➨ For Unhide Selected One Row or More Row.
• Ctrl + 0 ➨ For Hide Selected One Column or More Column.
• Ctrl + Shift +) ➨ For Unhide Selected One Column or More Column.

You can also use following method

• Alt + O + C +H ➨ For Hide Selected One Column or More Column.
• Alt + O + C +U ➨ For Unhide Selected One Column or More Column.
• Alt + O + R +H ➨ For Hide Selected One Row or More Row.
• Alt + O + R +U ➨ For Unhide Selected One Row or More Row.
• Alt + T + P + P ➨ For Protect & Unprotect Datasheet.
• Alt + W + F + F ➨ For Freeze & Unfreeze Excel Sheet Panes.
• For Using Format Painter Excel Shortcut Keys ➨ Press Ctrl + C and then Press Shift + F10 + R.

• For Doing the Transpose Value Excel in Excel Shortcut Keys ➨ Press Ctrl + C and then Press Shift + F10 + T & Then Hit Enter Key.
• ALT + H + F + K ➨ For Decreasing Font Size.
• ALT + H + F + G ➨ For Increasing Font Size.
• ALT + H + F + S ➨ For change Font Size of your choice.
• ALT + N + V ➨ For creating Pivot table in Excel
• Ctrl + L➨ For Creating List in table.
• ALT + A + E ➨For Open Text to Column Dialog Box.
• ALT + D + E ➨For Open Text to Column Dialog Box.
• ALT + A + M ➨For Remove Duplicate value in sheet.

धन्यवाद !
दोस्तों उम्मीद है की ये पोस्ट आपको पसंद आई होगी !