How to Make a Presentation in Excel

You can use Excel to present a chart, dashboard, schedule, or other information in a clean, readable format. Before you begin, decide who will see it and what they should understand. Gather the data, check that it is accurate, and choose a computer with Excel or access to Excel for the web. Menu names and locations may differ slightly by version.

What You’ll Need

An Excel workbook containing your data, or a blank workbook to build one.
A clear purpose and audience for the presentation.
Excel for desktop or the web. If you will present on another device, you can also save a PDF copy.

Step-by-Step

Choose the message. Write down the main point you want the audience to take away. Decide whether the workbook should show a single result, compare categories, explain a trend, or provide an overview. Keep the presentation focused; a spreadsheet full of unrelated information is difficult to follow.
Prepare the data. Put related data in a tidy table. Use one row for each record and one column for each field, with a clear header in the first row. Remove blank rows and columns within the table, correct obvious inconsistencies, and check that numbers and dates use the intended formats. Keep a separate copy of the original data if you plan to make substantial changes.
Plan the presentation layout. Use one worksheet for each main topic or view, and give every sheet a descriptive tab name. Put a short title near the top of the main sheet, followed by the key result or chart. Place supporting details below or on another sheet. Avoid merging cells in the underlying data table; reserve decorative layout choices for the presentation area.
Create a chart or summary. Select the relevant table range, including its headings, then choose a suitable chart from Excel’s Insert tab. A column or bar chart can compare categories, while a line chart can show a trend over time. For a quick overview, you can also use a small summary table or formulas such as SUM or AVERAGE when appropriate. Check the chart title, axis labels, units, and legend so the meaning is clear without extra explanation.
Make the sheet easy to read. Use a consistent font and a restrained set of colors. Make titles and key figures easy to spot, and use number formats that match the data, such as percentages or dates. Keep text concise and ensure important labels are not cut off. Do not rely on color alone to distinguish chart series; add clear labels or markers where they help.
Set up the display. Hide distracting gridlines if they do not help the audience, using the View tab or the relevant display controls. Adjust column widths and row heights, and set the zoom so the main content is readable on the presentation screen. If you will share a live workbook, select the sheet and view you intend to show, and close or move anything private or irrelevant. Menu paths can differ slightly by Excel version.
Preview and share. Review the workbook in the view you will use. For a handout or a fixed layout, open Print Preview, choose an appropriate orientation and scaling, and confirm that the content fits the page without becoming too small. Export or save a copy as PDF if the audience does not need to interact with the workbook. Reopen the saved file and check the charts, text, and page breaks before sharing.

Common Mistakes

Showing too much data: A dense sheet makes the main point hard to find. Lead with a summary or chart and move supporting detail to another sheet.
Choosing an unsuitable chart: A chart can confuse if its type does not match the message. Use a comparison chart for categories and a line chart for a time-based trend; avoid decorative effects that obscure values.
Leaving out context: A number without a title, date range, unit, or explanation may be misunderstood. Label the chart and include the relevant period or measurement.
Relying on screen appearance alone: A sheet that looks fine while editing may print across several pages or shrink to unreadable size. Check Print Preview or export a test PDF.
Sharing the wrong view or data: Hidden sheets, extra tabs, or private information can be overlooked. Review the entire workbook and the exact file you intend to send.

Tips

Put the conclusion or most important figure near the top, then add evidence beneath it.
Use descriptive worksheet names and chart titles so viewers can navigate without guesswork.
Keep colors consistent: use the same color for the same category throughout the workbook.
For a live presentation, practice selecting the right sheet and zoom level before sharing your screen.
Keep an editable workbook as your working copy, even if you distribute a PDF.

Troubleshooting

The chart is blank or incomplete: Check that you selected the full data range, including the labels, and that the values are stored as numbers rather than text. Edit the chart’s data range if necessary.
Labels or values are hard to read: Enlarge the chart, widen columns, increase text size, or simplify the amount of information shown. Check the result at the zoom level or screen size you will use.
The printout is split across pages: Use Print Preview to find the breaks. Change page orientation, adjust margins, or set a print area. Avoid forcing everything onto one page if scaling makes the text too small.
The PDF looks different from the workbook: Check the print area, page scaling, orientation, and page breaks, then export again and inspect the PDF before sending it.
The workbook opens on the wrong sheet: Save the workbook with the intended presentation sheet selected, then close and reopen it to confirm what viewers will see.

Frequently Asked Questions

Can Excel make a slide presentation?

Excel is a spreadsheet application, not a slide editor. You can present charts and formatted worksheets directly, or export a worksheet as a PDF. For a sequence of slides with transitions, use presentation software.

How do I present an Excel sheet on a screen?

Open the workbook, select the sheet you want to show, adjust the zoom, and display the relevant chart or summary. Before screen sharing, close unrelated windows and check that private information is not visible.

Can I turn an Excel presentation into a PDF?

Yes. Use Excel’s save or export option to create a PDF, and review Print Preview first to check page breaks and text size. The exact menu wording may differ slightly by version.

How many worksheets should a presentation have?

Use as few as needed to explain the subject clearly. A single summary sheet may be enough; use additional sheets for separate topics or supporting detail, with descriptive tab names.

Should I hide gridlines?

Hide them when they distract from a polished chart or dashboard, but keep them when viewers need to inspect a data table. You can change the gridline display from Excel’s View controls.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.