Excel is packed with shortcuts and automation tools that handle formatting, analysis, and repetitive work in seconds. These beginner-friendly features eliminate tedious spreadsheet tasks so effectively that the results feel almost too good to be true.

Using Flash Fill to handle messy data

Ctrl+E skips tedious typing

If you have a column filled with hundreds of names formatted as “Last, First” and need to separate them into individual columns, your instinct might be to look up text-manipulation functions. However, Flash Fill can handle the job by detecting patterns in your typing.

1. Type the correct first entry.
2. Press Enter to move to the next row.
3. Press Ctrl+E.

Excel then fills the remaining cells automatically.

This trick works just as cleanly for isolating phone number area codes or combining raw text into email addresses.

Repeating actions with a single keystroke

Don’t ignore the power of F4

When building out an interactive tracker or corporate dashboard, formatting cells can eat up a surprising amount of time. You find yourself constantly jumping back and forth to the ribbon just to highlight specific rows yellow, apply a thick border, or convert text to bold italics.

To speed things up, Excel has a hidden action repeater built right into the F4 key. While many people only use F4 to toggle absolute cell references, its secondary function is far more useful for everyday formatting chores.

1. Perform any single structural or formatting action once—such as changing a cell’s background color or deleting a blank row.
2. Select any other cell or range anywhere else in your workbook.
3. Press F4, and Excel instantly 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.

Converting photos into editable spreadsheets

Stop manually copying data

Whether you’re working from a printed ledger, a receipt, or a PDF screenshot, retyping rows of numbers into your workspace by hand gets tedious fast. It’s mind-numbing work and only takes one typo to throw off your numbers.

Instead of typing everything manually, you can use Excel’s built-in Data From Picture tool to convert copied or saved photos directly into spreadsheet data.

1. Select an empty cell in your Excel workbook.
2. Open the Data tab, then click From Picture.
3. If you copied a table image, select Picture From Clipboard and Excel will process it immediately. If you’re using a saved image, select Picture From File and choose your image from the file picker.

Excel then analyzes the image and opens a preview pane where you can review the conversion. Click Insert Data when you’re happy with it.

If you are away from your computer, you can also use this feature on the go. Open the Excel app on your phone and tap the Data From Picture icon in the toolbar. You can then either upload a picture you’ve already taken or use your phone’s camera as a scanner.

Filtering tables with clickable buttons

Turn boring filters into visual slicers

Standard drop-down table filters are functional, but they aren’t very pleasant to use. They hide filtering choices inside tiny drop-down arrows and make shared spreadsheets clunky to navigate for anyone who didn’t build the sheet themselves.

Slicers turn formatted Excel tables into interactive, user-friendly dashboards.

1. Select your dataset.
2. Press Ctrl+T (or click Insert > Table) to format it as an Excel table.
3. Select a cell in the table, then open the Table Design tab on the ribbon.
4. Click Insert Slicer.
5. Check the boxes for categories you want to filter by.

After clicking OK, you can filter the table using large on-screen buttons instead of tiny drop-down menus.

Letting Excel analyze your data

No need for Copilot

If you’re staring at a wall of raw numbers, it can be difficult to know where to start. You might not know how to build a PivotTable from scratch or which chart type will best display core insights to your team.

Fortunately, Excel includes a built-in analytics tool called Analyze Data that automatically suggests charts, summaries, and PivotTables from your data with very little manual setup.

1. Select any cell in your data grid.
2. Click the Analyze Data button in the Home tab or Data tab (depending on your Excel version).
3. An intelligent assistant pane opens, showing trends and patterns in your data. If you see a visual breakdown that fits your needs, simply click Insert to add it straight to your worksheet.

You can also click inside the text field to ask questions or see suggested queries.

Pulling live information into your worksheet

Get up-to-date figures from online sources

Populating a sheet with external context usually requires constant bouncing back-and-forth between Excel and a web browser. If you are tracking locations, companies, or stocks, you might spend an hour researching populations or currency exchange rates.

Excel eliminates this step by pulling live information from online sources, turning ordinary spreadsheet entries into live data cards.

1. Type a list of real-world entries into a column—such as a list of countries, states, cities, or corporate stock tickers.
2. Select your list and open the Data tab.
3. Select an option in the Data Types group, such as Geography or Stocks.
4. Click the small Insert Data icon that appears at the top-right of your selected column to choose the metrics you want to extract.

Ready for your next spreadsheet project?

Once you start using Excel’s built-in automation tools, repetitive spreadsheet work becomes much faster and easier to manage. These shortcuts can save hours of spreadsheet busywork, leaving you ready to tackle your next Excel project with confidence.