10 Excel Tricks To Excel Your Work Rate
1. One click to select all
Selecting all data by using the Ctrl + A shortcut is a commonly known trick, 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. Fast Navigation with Ctrl + Arrow Button
Clicking Ctrl + any arrow button on the keyboard, will enable you to jump to the edge of the sheet in different directions. If you want to jump to the bottom line of the data, just click Ctrl + downward button. This function can be exceptionally helpful when you have a spreadsheet with large amounts of data.
3. Shift between different excel files
If you have different spreadsheets open, it can be quite frustrating shifting between files because sometimes working on the wrong sheet can ruin the whole project. Using Ctrl + Tab you can shift between different files freely.
4. Pin your frequently used Excel documents to the task bar
Pinning your most used Excel documents to the task bar can be a huge timesaver. To do this right click on the excel icon and then click the pin icon to the right of your recent files.
5. Create new menu shortcuts
- Generally, there are three shortcuts in the top menu navigation, which are 'Save', 'Undo' and 'Redo'. However, if you want to set up more, all it takes is a few clicks!
- Go to File > Options > Quick Access Toolbar and simply select the functions you would like to add. Options include 'Cut', 'Copy', 'Paste' and 'Quick Print'.
6. Move and copy columns
- To move one column of data in a spreadsheet, select it by clicking its letter designation and move the pointer to the border. The arrow will turn into a cross icon, allowing you to drag and move the column.
- To copy the data of an entire column to another, hold down the Ctrl button while you drag.
7. Add more than one new row or column
- Right clicking and adding one new row or column is a commonly known process, but it wastes a lot of time if you need to insert more than one of these.
- The speedy way: drag and select i.e ‘5’ rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop down menu. New rows will be inserted above the row or to the left of the column you first selected.
8. Transpose Data from a Row to a Column
- If you wanted to change the display of the data from a row to a column, you would use the transpose feature because retyping all of the data would be a huge time waster.
- Copy the area you want to transpose, move the pointer to another blank cell. Go to Home->Paste-> Transpose button
- Remember: You must copy the data first before the transpose function will activate!
9. Automatic forecasting
- You can select columns on a table and have the spreadsheet predict how the results will play out in the future using historical data.
- Highlight your columns then go to Data > Forecast Sheet and set your parameters.
10. Use Quick Analysis to create graphs quickly
Selecting a group of cells will display the 'Quick Analysis' icon in the bottom right hand corner. This function pulls together your data and translates it into tables or graphs. Click the icon and use the tabs to select the visual you want.