| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
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
Related Link
Excel Error Cannot Shift Objects Off Sheet ► https://myctx.link/shift
Related Excel Videos
Quickly Delete Objects and Shapes on Worksheet ► https://youtu.be/-h3XTtY4wwg
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.
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1
#ContexturesExcelTips
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
