About Me

My photo
kalaburagi, karnataka, India
somalingmuppar kawalga economics

Monday, August 18, 2025

Computer learning shortcut key's

🔹 Alt + H + D + S - Delete worksheet
🔹 Alt + H + I + S - Insert worksheet
🔹 Alt + H + O + R - Rename worksheet
🔹 Alt + H + O + M - Move or copy worksheet
🔹 Alt + H + T - Apply cell style
🔹 Alt + H + L + H - Highlight cells with conditional formatting
🔹 Alt + H + L + T - Apply top 10 conditional formatting
🔹 Alt + H + L + D - Apply data bars conditional formatting
🔹 Alt + H + L + I - Apply icon sets conditional formatting
🔹 Alt + H + V + U - Paste as linked picture
🔹 Alt + H + V + I - Paste as picture
🔹 Alt + H + F + Z - Open font dropdown
🔹 Alt + H + F + U - Apply underline (single)
🔹 Alt + H + F + O - Open format painter
🔹 Alt + H + B + M - Apply medium border
🔹 Alt + H + B + I - Apply diagonal up border
🔹 Alt + H + B + G - Apply diagonal down border
🔹 Ctrl + Shift + 9 - Unhide selected rows
🔹 Ctrl + Shift + 0 - Unhide selected columns
🔹 Alt + A + S + S - Sort by color
🔹 Alt + A + F + S - Open sort dialog
🔹 Alt + A + V - Open data validation dropdown
🔹 Alt + A + D + D - Remove data validation
🔹 Alt + N + W - Insert WordArt
🔹 Alt + N + I - Insert icon
🔹 Alt + N + K - Insert hyperlink
🔹 Alt + H + E + R - Remove hyperlinks
🔹 Alt + H + F + Y - Apply accounting number format
🔹 Alt + H + F + L - Apply long date format
🔹 Alt + H + F + M - Apply short date format
🔹 Ctrl + Shift + ` - Apply general format
🔹 Ctrl + Alt + Shift + V - Paste special
🔹 Alt + H + V + M - Paste matching destination formatting
🔹 Alt + H + V + B - Paste borders
🔹 Alt + H + S + M - Modify cell style
🔹 Alt + H + S + N - Create new cell style
🔹 Alt + W + V + S - Show/hide scroll bars
🔹 Alt + W + V + T - Show/hide formula bar
🔹 Alt + W + C - Calculate now
🔹 Alt + W + A - Calculate sheet
🔹 Ctrl + Shift + F6 - Switch to previous workbook
🔹 Ctrl + F6 - Switch to next workbook
🔹 Alt + H + O + T - Tab color for worksheet
🔹 Alt + H + P - Protect sheet
🔹 Alt + H + U + P - Unprotect sheet
🔹 Alt + A + E - Export data to text file
🔹 Alt + A + R - Refresh all data connections
🔹 Alt + A + W - Manage data connections
🔹 Alt + N + D - Insert 3D model
🔹 Alt + N + B - Insert stock images
🔹 Alt + H + F + X - Apply fraction format
🔹 Alt + H + F + C + C - Apply custom number format
🔹 Ctrl + Shift + B - Show/hide formula auditing toolbar
🔹 Ctrl + Shift + E - Trace precedents
🔹 Ctrl + Shift + W - Trace dependents
🔹 Ctrl + Shift + Q - Remove trace arrows
🔹 Alt + H + I + P - Insert page break
🔹 Alt + H + D + B - Remove page break
🔹 Alt + H + O + H - Hide sheet
🔹 Alt + H + O + U - Unhide sheet

Delete Worksheet Tip: Use Alt + H + D + S to quickly delete a worksheet when cleaning up your workbook, keeping your project organized!


No comments:

Post a Comment

Tally Prime Shortcut Keys

Tally Prime Shortcut Keys 1. Alt + G : GO TO 2. Ctrl + G : Switch To 3. Alt + K : Company Menu 4. Alt + Y : Manage Company Data 5. Alt + Z :...