Data can be quite daunting especially if you don’t know your way around Ms-Excel that has 1.2 billion users as per 2016. Bringing you your weekly dose of Google Sheets Cheat series, this time we focus on your Excel productivity. Here are five quick ways to save time and instantly improve your efficiency while working with Excel:
Keyboard shortcuts on excel will increase your productivity multiple folds if used correctly. By reducing your dependence on the mouse and using keyboard shortcuts to navigate through your spreadsheet should be the first and best investment you will ever make. It will take some time to get used to when you initially get started but persevere and you shall be rewarded.
Here are a few quick shortcuts to begin with:
- To move around within your spreadsheet data: Ctrl and Shift key and the direction keys (Up, Down, Left or Right)
- Moving between sheets within a workbook: Ctrl and Page up or Page Down.
- Switch between Relative and Absolute reference with F4.
- Edit cell contents by pressing F2 instead of a mouse double click.
- To highlight an entire row: Shift and Spacebar
- To highlight an entire column: Ctrl and Spacebar
If you often find yourself formatting the data within your workbook to match the font, font size, color for your recurring reports try using the smarter approach to formatting with the Format Painter tool in excel. Simply select the data range whose format you wish to copy, click the format painter tool and then the data where you want it to apply the format of your choice and voila!
While creating columns in a new spreadsheet, highlight the row where you will be placing your column headings. When you hit enter you will be directed to the adjacent cell on the right instead of the cell below (the default excel setting). You can also set this manually for all rows and columns if your work requires enter to direct you to the adjacent cell by selecting
Preferences > Edit > After pressing Return, move selection: > Right
4.Status Bar and Functions
Use your status bar to show you a quick calculation of your minimum, maximum, average, sum, etc when you select a specific data range. To set this up right click on the status bar at the bottom of your workbook and select the functions you would like to be displayed instantly.
5. Find Those Blanks
How many times have you come across a situation where you are unsure of what to enter in a specific cell and think of doing it later after consulting someone else. When you finally get on to analysis you realize there’s a bunch of missing data in the ocean that is your spreadsheet. A quick way to find those blanks easily and fill them up is by selecting your entire data range then
Edit>Find>Go To> Special> Blanks
This will bring out all the blanks in your spreadsheet irrespective of rows and columns. You can highlight them yellow and beginning the ‘fill in the blanks’ process. We hope you found this article useful. Use our guide Free Keyboard Shortcuts: Spreadsheet Secrets and watch yourself transform from a Google Sheets newbie to a ninja in no time! Stay subscribed to Wyzebulb Blog for more blogs and articles on Automation, Marketing and Productivity!