6 essential steps I take before screen-sharing my Excel workbook

Nothing kills an online Excel presentation faster than sensitive data leaks or disorienting navigation. Here's my pre-flight checklist that ensures my interface is clean, my delivery is seamless, and my sensitive data stays out of sight.

Creating a presentation mode using Custom Views

When I'm building an Excel workbook, I work at 100% zoom with all my filters visible. But when I'm sharing my screen, that same view is often unreadable for my audience. That's why I use custom views to create a presentation mode with a 140% zoom level and specific filtering states already applied.

First, I create a standard view with all my personal filters applied, so I can quickly switch back to it as soon as my presentation has finished. Then, I click "Custom Views" in the View tab on the ribbon, select "Add," and give it a generic name, like Standard view.

Then, I make my presentation-ready tweaks and follow the same steps to set up another view, which I call Presentation.

Custom views store the following aesthetic properties:

• Hidden and visible columns and rows.

• Applied filters and sorts.

• Zoom percentage.

• Cell selection.

• Window settings (such as the exact position of the scroll bar and any frozen panes).

• Print settings (such as page orientations, margins, and specific print areas).

Just bear in mind that views are sheet-specific, meaning you must create separate views for each tab you plan to show. Also, custom views don't work if there are any Excel tables in the workbook, so make sure you check for these first.

Hiding distracting objects using the Selection Pane

My working Excel files are often littered with scratchpad objects, such as text boxes with temporary notes, draft charts, or shapes used as placeholders. These are helpful during creation, but they look like unpolished clutter during a live demo.

Instead of deleting these objects altogether, I use the selection pane to "sweep the desk." To open it, expand the "Find & Select" drop-down menu in the Home tab, and click "Selection Pane."

This pane lists every object on your sheet with a small eye icon to toggle visibility. I use the "Hide All" button to instantly clear my worksheet of all floating notes and draft figures, and once the screen share ends, I simply click "Show All" to resume my work.

Like custom views, the selection pane is sheet-specific, so remember to run this check on every tab you plan to share.

Cleaning the interface to hide the Excel noise

I want my audience focused on the data, not the Excel ribbon or background clutter. To create a clean, dashboard-like appearance, I uncheck "Gridlines" and "Headings" in the View tab, making the spreadsheet look like a finished report rather than a work-in-progress. I also uncheck "Formula Bar" to ensure my audience only sees the final result, not the logic behind it.

Beyond the basic checkboxes, I also press Ctrl+F1 to collapse the ribbon. This maximizes my vertical screen real estate, which is especially helpful when presenting on a video call where the meeting app's UI often eats into the view.

Auditing the File menu and Recent Workbook lists

The most dangerous button to click during an Excel screen share is "File." This opens the backstage view, revealing my recently opened workbooks, which can contain sensitive client names, internal project titles, or simply personal files I don't want others to see.

To prevent this backstage leak, I audit this list before I go live. To do this, I click File > Options > Advanced, scroll down to the Display section, and set "Show this number of Recent Workbooks" to zero.

This instantly clears the list, ensuring my file history stays private even if I have to navigate through the menu system in front of an audience.

By the same token, if you have other Excel workbooks open and hover over the Excel icon in the task bar, all these file names become visible. So, before you share your screen, hover over the icon and close any sensitive files.

Opening duplicate windows for multi-tab demos

Flipping between Excel tabs is the easiest way to give your audience motion sickness. When I need to demonstrate the relationship between two different sheets, I use the New Window tool on the View tab. This opens a second instance of the same workbook, allowing me to view two tabs at the same time.

To arrange them perfectly, I click "Arrange All," or simply snap the windows side-by-side using the Windows key with the Arrow keys.

This setup lets me point to a data source in one tab while showing the resulting chart in another, all without a single jarring transition.

When you're done using the two views of the same file, simply close one of the windows. As long as the other window remains open, Excel won't prompt you to save or close the entire file. Then, the last version you have open becomes the main version, which you can save and close when you're ready.

Silencing notifications and choosing the right sharing mode

The final step in my checklist happens outside of Excel. To prevent embarrassing pings from Slack or email, I always toggle Windows Focus mode by clicking the calendar on the task bar and selecting "Focus" before I join the call. If you're using a Mac, open the "Control Center" (top-right menu bar), click the "Focus" icon (the moon), and select " Do Not Disturb ."

Also, when it's time to present, I'm always careful to select "Share Window" instead of "Share Screen." This creates a virtual sandbox where my audience stays locked onto the Excel interface, even if I have to switch monitors to check a private reference or an email.

This is the ultimate safety net for professional privacy, but do keep these notes in mind:

• The dialog box trap:If you share a specific window and then open an Excel dialog box (like Format Cells or the Conditional Formatting manager), some meeting apps won't show that box to your audience. I always test this with a coworker first.

• Audio alerts:Turning off notifications might only stop visual pop-ups for some apps. So, make sure your system volume or the notification sounds for specific apps are also muted to prevent "ding" sounds from interrupting your flow.

---

Once your meeting ends, your job isn't quite over. If you need to send the file to your participants, you should use Excel's built-in tool to scrub personal information from the file's metadata . Also, take some extra steps to make the shared spreadsheet easier to navigate for the next person who opens it, ensuring your hard work remains professional long after the screen share is over.