Office Settings & Configuration

Fix Disabled Draw Tab Options in Excel 2016 Workbooks

Maira MehtabMaira Mehtab Nov 20, 2026 868 views

Question details

Restore the Draw tab options in an Excel 2016 workbook when drawing works in other files.

Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
The user wants to draw in a workbook whose Draw tab options are disabled.
Observed behavior
Drawing works in other workbooks, but the affected workbook has disabled Draw options. Frozen panes or columns may be involved.
Before you start

Open the affected workbook and check whether Draw options work in another workbook. On the affected sheet, note any frozen rows or columns so you can restore them later if needed.

Solution 1Recommended

Unfreeze Panes in the Affected Excel Worksheet

Try this first if the affected worksheet has frozen rows or columns.

1
Open the affected sheet

In the workbook, click the worksheet tab where the Draw options are disabled.

2
Unfreeze panes

Select View > Freeze Panes > Unfreeze Panes. This also unfreezes any frozen columns or rows.

3
Test the Draw tab

Select the Draw tab and check whether its drawing tools are available. If the workbook has other affected sheets, check their Freeze Panes settings too.

Frozen panes may be the trigger: Unfreezing columns resolved a similar worksheet-specific issue, but it may not fix every disabled Draw tab.
Free Microsoft Office alternative

Work With Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files, although it does not repair Excel's disabled Draw tab.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLSX and XLS formatsMove existing spreadsheet files without starting overFree and lightweight for everyday office tasks
QA img-9

Frequently Asked Questions

Why are Draw options disabled in only one workbook?

The issue may be specific to that workbook or worksheet. Frozen panes or columns have caused a similar problem, so try View > Freeze Panes > Unfreeze Panes first.

How do I unfreeze columns in Excel 2016?

Open the affected worksheet and select View > Freeze Panes > Unfreeze Panes. This removes all frozen rows and columns on that sheet.

How can I repair an Excel workbook?

Close the workbook, then select File > Open > Browse. Select the file, click the arrow next to Open, choose Open and Repair, and select Repair.

What if the Draw tab still does not work after unfreezing panes?

Try Open and Repair, check File > Account > Update Options > Update Now if available, or copy the needed data into a new workbook and test Draw there.

Can I restore an earlier version of the workbook?

If the workbook is stored in OneDrive or SharePoint and version history is available, open its version history in the storage service and inspect or restore an earlier version.