1. Microsoft Excel Keyboard Shortcuts
- F2: Edits cells
- Shift Space: Selects whole lines
- Ctrl Space: Selects whole columns
- Ctrl Plus: Insert cell
- Ctrl Minus: Delete cell
- Ctrl 1: Edits the cell format
You can find a full list of Excel Shortcuts & Word Shortcuts here.
2. Take a Screenshot
- On Macs, CMD Shift 3 takes a photo of the entire screen, CMD Shift 4 lets you use your mouse and select a portion of your screen to take a screenshot.
- The Print Screen button on your Windows keyboard for PCs and the screenshot can be pasted into any photo-editing software, like Paint or Photoshop. On the PC, you can use the Snipping Tool - a program in Windows - to select a specific area of your screen to take a screenshot.
3. Easily Search Websites
- In Google Chrome, when filling in a web address, for example, www.youtube.com, press TAB instead of ENTER and you can perform your search on the site from the address bar.
4. Use 'Pushbullet' to send files, links, and text between devices
- Pushbullet is an app and extension that brings all your devices together. It lets you easily send messages and reminders from your computer to your smartphone, and share links and files to different devices.
- So, if you take a screenshot or picture on your smartphone, you can easily 'push' it to your laptop. The service is free, and it works with iOS, Android, Mac, and PC devices.
- OneTab is arguably the best Chrome or Firefox extension you can download. The extension places a small button on your toolbar that, when pressed, converts all your open tabs into a list that you can easily open and access later. Or, you can export your tabs as a list of URLs to share with others.
- The extension saves up to 95% of your computer's memory, because your browser is no longer running all those tabs. Goodbye spinning wheel of death!
- In the Chrome address bar, paste this: chrome://flags/
- On your keyboard press CTRL F (or Command F on a Mac)
- Type autoplay
- Click the dropdown menu and set it to "document user activation required"
- On the other hand, you can use the AutoplayStopper chrome extension to disable autoplay videos
7. Clean out your inbox much faster
- If you're buried under thousands of emails in your Gmail inbox, we think you're going to love this search string.
- In the search bar, type the following, then press enter. in:inbox is:unread -category:promotion. This will make it easy to delete a bunch of emails from brands and stores that are trying to sell you something.
- Also, just make a filter for the word "unsubscribe" in your email. This will make it easy to unsubscribe to those pesky emails that never stop coming. If you're new to creating filters, here's how you can do it in Gmail.
We hope you enjoyed reading this article and found this informative and helpful in keeping yourselves up-to-date.