You can add a new worksheet (tab) in Excel three ways: right-click Insert, the Shift + F11 shortcut, or the + control on the sheet tab bar. New tabs start blank unless your template workbook already defines defaults.

Why tab hygiene matters for finance models

Separate inputs, calculations, and board-ready outputs on different sheets so reviewers do not edit the wrong block. Name tabs clearly (P&L, TB, Bridge) instead of leaving Sheet12. Structure helps; live data helps more. LiveFlow FP&A keeps Excel reports updating from your books without rebuilding every tab from exports.

Method 1: Insert from the sheet tab menu

1. Right-click the sheet tab that should sit to the right of the new sheet (Excel inserts to the left of the tab you click).

2. Choose Insert.

3. Select Worksheet and click OK.

Method 2: Keyboard shortcut

1. Select a sheet tab as the insert anchor.

2. Press Shift + F11 (on some Mac keyboards: Shift + Fn + F11).

A new worksheet appears.

Method 3: The + button

1. Look at the sheet tab bar at the bottom of the workbook.

2. Click the + control (usually to the right of the last visible tab).

Excel adds a new sheet to the right of the active tab area.

Quick tips

• Double-click a tab name to rename it.

• Drag tabs to reorder month packs or entity sections.

• Right-click → Move or Copy when you need a duplicate of an existing layout.

• Color-code tabs lightly for Inputs vs Outputs if your team shares the file.

Why finance teams use LiveFlow

Adding tabs organizes the workbook. LiveFlow reduces how often each tab starts as a pasted CSV. LiveFlow FP&A connects QuickBooks Online (and other books) to Excel so formatted sheets refresh without a monthly rebuild.

CTA: Book a demo of LiveFlow FP&A for Excel.