#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
On this page of the site you can watch the video online #ExcelTips with a duration of hours minute second in good quality, which was uploaded by the user The FilmyJi Official 26 December 2021, share the link with friends and acquaintances, this video has already been watched 8,418 times on youtube and it was liked by 9 viewers. Enjoy your viewing!
