Excel is full of shortcuts and automation tools that handle formatting, analysis, and repetitive tasks in seconds. These beginner-friendly features eliminate tedious spreadsheet tasks so effectively that the results seem too good to be true.
Use Flash Fill to manage mixed data
Ctrl+E skips tedious typing
If you have a column full of hundreds of names formatted as “Last, First” and need to separate them into separate columns, your instinct may be to look up. text manipulation functions. However, Flash Fill can handle the job by detecting patterns in your writing.
-
type correct first entry.
-
press Enter it to move to the next row.
-
press Ctrl+E.
Excel then automatically fills in the remaining cells.
This trick works just as cleanly for isolating phone number area codes or concatenating raw text into email addresses.
Your Flash Fill data works best when it follows a consistent pattern without jumbled formats or empty spaces.
Repeating actions with a single button
Don’t underestimate the power of F4
When designing an interactive viewer or corporate dashboard, formatting cells can be surprisingly time-consuming. You’re constantly jumping back and forth on the ribbon to highlight specific rows in yellow, apply a bold border, or change text to bold italics.
To speed things up, Excel has a hidden operation repeater F4 key. While many people only use F4 definitely change the cell referencesits secondary function is more useful for everyday formatting tasks.
-
Play any single structure or formatting perform a single action—for example, changing the background color of a cell or deleting an empty row.
-
Select any other cell or range elsewhere in your workbook.
-
press F4and Excel immediately repeats the same action.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more. includes
Convert images into editable spreadsheets
Stop copying data manually
Whether you’re working from a printed book, a receipt, or a PDF screenshot, manually retyping rows of numbers with your workstation can quickly become tiresome. It’s mind-numbing work, and it only takes one typo to throw off your numbers.
Instead of writing everything manually, you can use Excel’s built-in software Data from Image tool to convert copied or saved photos directly into spreadsheet data.
-
choose empty cell in your Excel workbook.
-
open Data icon, then click From the picture.
-
Select if you copied the table image Image from clipboard and Excel will process it instantly. Select if you are using a saved image Image from file and select your image from the file picker.
Excel then analyzes the image and opens a preview panel where you can review the conversion. click Enter information when he is happy with her.
If you’re away from your computer, you can use this feature on the go. Open the Excel app on your phone and tap Information from the image icon on the toolbar. You can then either upload a photo you’ve already taken or use your phone’s camera as a scanner.
This feature works best with clear, high-resolution images and well-defined table borders. Blurred photos or handwritten information will reduce accuracy.
Filtering tables with clickable buttons
Turn boring filters into visual stunners
Standard dropdown table filters are functional, but not very pleasant to use. They hide filtering options inside small dropdown arrows, making shared tables difficult to navigate for anyone who didn’t create the sheet themselves.
Slicers turn formatted Excel spreadsheets into interactive, user-friendly dashboards.
-
Select your dataset.
-
press Ctrl+T (or click Insert > Table) for Format as an Excel spreadsheet.
-
Select a cell in the table, then open it Table design icon on the ribbon.
-
click Enter the slicer.
-
Check the boxes for the categories you want to filter.
After clicking OKyou can filter the table using large screen buttons instead of small drop-down menus.
Let Excel analyze your data
No need for Copilot
If you’re staring at a wall of raw numbers, it can be hard to know where to start. You don’t know how to do it Create a Pivot Table from scratch or which graph type will best convey key ideas to your team.
Fortunately, it includes a built-in analytical tool called Excel Analyze the data automatically suggests charts, summaries and Pivot Tables from your data with very little manual setup.
- Select any cell in your data network.
-
click on it Analyze the data button inside House mark or Data tab (depending on your version of Excel).
-
A smart dashboard opens that shows trends and patterns in your data. If you see a visual piece that suits your needs, just click Enter it to add it directly to your worksheet.
You can also click the text field to ask a question or see suggested polls.
Data Analysis works best when your table has clear column headings and no empty rows or columns.
Capture live data into your worksheet
Get the latest figures from online sources
Populating a sheet with external context usually requires constant jumping back and forth between Excel and the web browser. If you’re tracking locations, companies, or stocks, you can spend an hour researching populations or currency rates.
Excel eliminates this step by pulling live data from online sources, converting regular spreadsheet entries live data cards.
-
write the list real world inputs enter a column such as countries, states, cities, or a list of corporate stocks.
-
Select and open your list Data badge.
-
Select an option in Data types group like Geography or Shares.
-
Small press Enter information icon that appears at the top right of the column you selected to select the dimensions you want to extract.
This feature requires an internet connection and some data types may not be available for less common logins.
Ready for your next spreadsheet project?
Once you start using Excel’s built-in automation tools, repetitive spreadsheet work becomes faster and easier to manage. These shortcuts can save you hours of busy schedule work and get you ready tackle your next Excel project with confidence.
