🔹 Alt + D + S - Open Sort dialog  

🔹 Ctrl + E - Flash Fill  

🔹 Alt + A + E - Text to Columns  

🔹 Alt + N + V - Create PivotTable  

🔹 Alt + A + M - Remove duplicates  

🔹 Ctrl + T - Create table  

🔹 Ctrl + Space - Select entire column  

🔹 Shift + Space - Select entire row  

🔹 Ctrl + - (Minus) - Delete selection  

🔹 Ctrl + + (Plus) - Insert cells  

🔹 Ctrl + Shift + L - Toggle filters  

🔹 Alt + W + F - Freeze panes  

🔹 Alt + W + S - Split window  

🔹 Ctrl + Page Up - Previous sheet  

🔹 Ctrl + Page Down - Next sheet  

🔹 Alt + E + S + V - Paste values  

🔹 Alt + H + O + I - Auto-fit column width  

🔹 Alt + H + O + A - Auto-fit row height  

🔹 Ctrl + 1 - Format Cells dialog  

🔹 F2 - Edit cell  

🔹 F4 - Repeat last action/Toggle references  

🔹 F9 - Calculate worksheets  

🔹 Shift + F3 - Insert function  

🔹 Ctrl + F3 - Define name  

🔹 Alt + F8 - Macro dialog  

🔹 Ctrl + Shift + : - Insert time  

🔹 Ctrl + ; - Insert date  

🔹 Alt + = - AutoSum  

🔹 Ctrl + Shift + $ - Currency format  

🔹 Ctrl + Shift + % - Percentage format  


Bonus: Use Alt + D + S for multi-column sorting (Data > Sort in newer versions).  


Comments

Post a Comment

Popular posts from this blog

Apple releases second macOS Tahoe test version

Image
  Apple releases second macOS Tahoe test version macOS 26 💥Apple has rolled out the second test version of macOS Tahoe 26 to developers for trying out new features. This update arrives two weeks after the first test and focuses on smoothing out issues before the public gets to try it next month. You’ll need a sleek new look, Apple! This macOS brings a fresh style called Liquid Glass, which makes everything look shiny and see-through, a bit like the iPhone’s design. It changes how you use apps like Mail, Calendar, and Photos, making them feel new and lively. There’s also a new Phone app for Mac, so you can handle calls and texts right from your computer. Plus, Spotlight search is now quicker and can dig through your emails to find what you need fast. For those eager to test it, macOS Tahoe is still just for developers, but anyone can sign up with an Apple Developer account to give it a go. Be careful, though—Apple warns not to put this early software on your main Mac since it...
Read more

🛰️ *Apple’s iOS 18 to Introduce Satellite Messaging*

Image
🛰️ *Apple’s iOS 18 to Introduce Satellite Messaging* *Published: June 27, 2025* Apple is taking iPhone communication to the next level. With *iOS 18*, users will soon be able to send messages even when there’s *no mobile signal*, using satellite connectivity.   This feature is designed for emergencies, hiking trips, or rural areas. It works seamlessly via the iMessage app, ensuring you're never out of touch again. *Tags*: Apple, iOS 18, Satellite, Mobile Tech
Read more