Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2014, 01:51 AM
ricky0309 ricky0309 is offline Unable to "Shift cells down" on unprotected area in a protected worksheet Windows 7 64bit Unable to "Shift cells down" on unprotected area in a protected worksheet Office 2007
Novice
Unable to "Shift cells down" on unprotected area in a protected worksheet
 
Join Date: Aug 2014
Posts: 1
ricky0309 is on a distinguished road
Default Unable to "Shift cells down" on unprotected area in a protected worksheet

Hi all,

I am planning to protect some cells that contain formulas in my worksheet in order to avoid modifications on these cells.


I managed to do just that by having the sheet protected with the protection checkbox ticked only on these cells and having the protection checkbox unticked for the rest of the cells.
However, when I try to perform "Shift cells down" on some of the unprotected cells (basically: highlight cells, right click, insert, shift cells down), I found that the "insert" option is greyed out thereby preventing me to perform "Shift cells down".
I am aware that I could perform insert rows by enabling the selection during protection, but this is not what I want since insert rows will affect my protected cells as well. What I want is just to shift some cells down on the unprotected area of the worksheet.

Could somebody offer me an advice on how to get around this? Thanks.

Last edited by ricky0309; 08-14-2014 at 01:57 AM. Reason: typo
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only mag Excel 0 10-28-2012 08:04 PM
'Linking' entered information to other "cells" from an original "cell" in MS Word Wade Word 6 09-03-2012 05:22 PM
"One or more margins are set outside the printable area of the page." How to kill? WaltR Word 4 07-16-2012 01:55 PM
Unable to "Shift cells down" on unprotected area in a protected worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
"Add Users" to a protected word document jenc Word 0 07-22-2009 02:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft