Fix Disabled Draw Tab Options in Excel 2016 Workbooks
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.
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.
Unfreeze Panes in the Affected Excel Worksheet
Try this first if the affected worksheet has frozen rows or columns.
In the workbook, click the worksheet tab where the Draw options are disabled.
Select View > Freeze Panes > Unfreeze Panes. This also unfreezes any frozen columns or rows.
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.
Repair the Workbook and Update Excel 2016
Use these checks if unfreezing panes does not restore the Draw options.
Move Worksheet Data or Restore an Earlier Workbook Version
Try a new workbook or an earlier version if the problem remains specific to the original file.
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.

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.




