15 helpful Microsoft Excel tips to use in the software
By Indeed Editorial Team
Published 13 April 2022
The Indeed Editorial Team comprises a diverse and talented team of writers, researchers and subject matter experts equipped with Indeed's data and insights to deliver useful tips to help guide your career journey.
Microsoft Excel is a popular spreadsheet application that has become a vital tool for companies to manage their data for multiple purposes, including data analysis. It has a powerful suite of features that makes it easier to work with data, especially if you have the knowledge of Excel's abilities. To get the most out of your Excel software, it can help to learn a few tips that can increase your productivity and organisation. In this article, we share 15 Excel tips for both new and advanced users.
15 Microsoft Excel tips
With the right Microsoft Excel tips, you can unlock a huge range of features and functionality that makes working with Excel much easier. From using Excel as an analysis tool to organising data more efficiently, knowing how to get the most out of Excel can vastly improve your experience with it. Here are several useful tips for beginners and advanced Excel users:
1. Highlight all cells in a spreadsheet
This handy tip allows you to quickly highlight all the cells in your spreadsheet so that if you want to edit all cells at the same, you can do it in a few clicks. To select all cells, click CTRL + SHIFT + *. You may do this if you want to change the formatting or apply a text style.
2. Use format painter
Format painter is a tool that lets you apply formats across multiple cells. This can help with formatting how a spreadsheet looks, so if you want to colour-code certain cells or make specific rows bold, you can do so quickly. To use the format painter, do the following:
Click on the cell that you want to copy the formatting of.
Click on the home menu.
Select ‘format painter'.
Click on the cell that you would like to paste the formatting to.
If you want to format multiple cells at once, double-click on the format painter icon to leave it engaged, then select the multiple cells and click the icon again to disable it.
3. Turn on flash fill
Flash fill is a feature within Excel that recognises patterns in formatting automatically and replicates them for you. If you're typing in formatted phone numbers, for example, Excel picks up on the pattern after you input it twice. From here, Excel replicates the pattern automatically, so all you do is input the numbers rather than the formatting. To do this, click the ‘data' tab and select ‘flash fill' to switch the feature on.
4. Import data
You can import data into Excel from an external source easily using the ‘external data' feature. This can be useful if you have data sets from other sources, especially if they are complex or contain a lot of data. In most cases, copying and pasting data works, but for larger data sets, it may be an easier and quicker process to import. To import data into Excel, do the following:
Select the ‘data' tab.
Click on ‘get external data'.
Use the instructions Excel provides to pull the data from the external source.
5. Copy and paste across multiple cells
You can copy and paste the same data across multiple cells easily in Excel, which can save you a lot of time. To do this, follow these steps:
Select the cells that you want to paste data into.
When you reach the last cell, input the data you want to copy into multiple cells.
When complete, click CTRL + ENTER to copy and paste the data from the last cell across all selected cells.
6. View formulas in Excel
If you have a populated spreadsheet from someone else, it can be useful to look at the various previously used formulas that populated the cells. Do this by selecting the ‘formulas' tab and selecting ‘show formulas'. This brings up all the used formulas across the entire spreadsheet.
7. Freeze rows and columns
Spreadsheets in Excel can contain a huge number of rows and columns, so if there's a lot of data, the spreadsheet can become quite wide and long. This can make it difficult to find the correct data points, but you can work around this by freezing specific rows or columns in place. To do so, apply these steps:
Click on the area of the spreadsheet that you would like to freeze.
Select the ‘view' tab.
Select the ‘freeze panes' button.
8. Pivot tables
Pivot tables is an advanced feature of Excel that allows you to reorganise the data found in a spreadsheet. It doesn't change the existing data, but it can sum up various values and draw comparisons between different data sets in the spreadsheet. To make a pivot table, follow these steps:
Select the columns and rows that you want to evaluate.
Click on the ‘insert' tab.
Click on ‘pivot table'.
9. Replicate patterns
If you have a pattern that you would like to replicate across Excel, you can do this easily using this trick. First, input the start of the pattern in the row or column across separate cells. Next, click on the small square located in the bottom right of the last cell. Finally, drag that square until you have selected all the cells that you want to replicate the pattern into. Excel does the rest by populating the selected cells with the right figure.
10. Input text to columns
If you are inputting multi-word data sets, such as full names, Excel can make the process much faster thanks to the text to columns feature. If you need a group of words to appear in their cell, text to columns can read large data sets to automate the process. To do this, follow these steps:
Highlight the data after copying it into Excel.
Click on the ‘data' tab.
Click on ‘text to columns'.
Adjust the formatting to your specifications.
11. Insert graphics
Inserting graphics is a little-known feature of Excel that can drastically improve the functionality of a spreadsheet. This is a great way to illustrate data or display more visually appealing spreadsheets. To insert graphics into your spreadsheets, do the following:
Highlight the cell where you intend to place the graphic.
Right-click and select ‘series'.
Select your graphic.
Insert the graphic into the cell.
12. Save your charts to templates
Excel allows you to customise several graphics, such as charts and graphs, to better illustrate data and trends. You can even save these graphics as templates to use again in future spreadsheets. To save a template:
Right-click on the completed chart.
Select ‘save as template'.
Save the file as a .CRTX file. This saves the chart as a template that you can use in the future.
13. Create a drop-down menu
If you want to format data within certain rows or columns, a drop-down menu can cleanly display the data. To create a drop-down menu within Excel, do the following:
Highlight the data you want to include in the drop-down menu.
Click on the ‘data' tab.
Select ‘data validation'.
Click on ‘allow'.
Choose your list.
Add your list items under ‘source'.
14. Hide specific rows or columns
Excel can become confusing when there are lots of rows and columns within the same spreadsheet. To make it easier to focus on the cells you're working on, you can hide rows or columns that aren't in use. To do this, follow these steps:
Click on the header of the row or column you want to freeze.
Select the ‘home' tab and click on the ‘format' button.
Select ‘hide columns', then click on ‘hide columns'.
15. Copy and paste across different spreadsheets
To transfer information from one spreadsheet to another, Excel makes this a relatively simple task. In Excel, do the following:
Press the CTRL button while highlighting the tab of the spreadsheet you want to copy information onto.
Select the cell that holds the information you want to copy from.
Press the F2 key and then ENTER.
What is Microsoft Excel?
Microsoft Excel is an application that reads, edits, creates spreadsheets and performs data analysis. Spreadsheets consist of rows and columns that create cells, or boxes that contain data. The type of information that you can input into the cells could be numbers, words or phrases. When using Excel, you can also input various formulas to make work easier by automatically sorting, copying or manipulating the cells in some way. Excel has a lot of functionality, with a wide range of features and shortcuts that make tracking, analysing and sorting data much easier.
Please note that none of the companies mentioned in this article are affiliated with Indeed.
Explore more articles
- IT degrees: definition, types and career opportunities
- What is retargeting? (How to create a retargeting campaign)
- What is social media advertising? (Plus types of ads)
- What is workload management? (With tips and elements)
- What is marketing automation? (tips, benefits and examples)
- A guide to social media manager tools (tips and examples)
- Six useful Pomodoro apps to help improve productivity
- What does a senior data analyst do? (Steps and skills)
- What are key deliverables and how are they tracked?
- What is a technical recruiter job? (Description and how-to)
- How to be more productive (including ideas and tips)
- What is an enterprise application? (Definition and examples)