It’s common practice to have multiple Excel files open at the same time, but we can waste a lot of time flitting back and forth between them. In this tutorial you’ll learn some game-changing tips that are guaranteed to streamline your workflow, making it easier than ever to navigate, arrange, and seamlessly work between multiple Excel files.
27 Excel Tricks That Can Make Anyone An Excel Expert. One Click to Select All. ... Open Excel Files in Bulk. ... Shift Between Different Excel Files. ... Create a New Shortcut Menu. ... Add a Diagonal Line to a Cell. ... Add More Than One New Row or Column. ... Speedily Move and Copy Data in Cells. ... Speedily Delete Blank Cells.
Another way to increase your productivity in Excel is by changing the color of the sheets tab. If your workbook has a multiple sheets, coloring them is a good example for easing navigation. All you need to is right-click on a tab and select a color from the Tab Color pane.
The productivity hack involves three steps: brain dumping, setting priorities, and planning your day. Brain dumping is when you spill your mind into an empty box. You can write about the activities you have to do, concepts for future ideas, or anything you think is worth putting in ink.