20 Tricks That Can Make Anyone An Excel Expert
After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. 1. You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds. 2. Rather than open files one by one when you have multiple files you need to handle, there is a handy way to open them all with one click. 3. When you have different spreadsheets open, it’s really annoying shifting between different files because sometimes working on the wrong sheet can ruin the whole project. 4. Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. 5.
Related: DropZone Dump