Скачать или смотреть #ExcelTips

When trying to insert rows or insert columns in an Excel worksheet, you might see the error message "Cannot shift objects off sheet."

In some cases, the problem can be fixed if you change the Object Display settings.


This video shows you how to change the settings in the Excel Options window.


Or, you can turn this setting on or off with a keyboard shortcut -- Ctrl + 6

Video Timeline
0:00 Introduction

0:44 Open Excel Option Settings
1:00 Advanced - Display Options Workbook
1:17 For Objects, Show: All
1:25 Test the Option Change
1:38 Shortcut to Change Option



Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube:    / contextu.  .
#ContexturesExcelTips