I like to copy calculated values from a protected sheet to a unprotected sheet. How do i set this up?
In the source workbook, click the sheet tab you'd like to copy, hold down theCtrlkey and drag the sheet to the target workbook. Awesome, isn't it? The next time you need to copy information from one Excel file to another, forget about copy/pasting and drag the sheet. How to copy m...
In case of free access to unprotected cells (selected cells are formatted as not protected) Ctrl+D works as long as selected range (for Ctrl+D) contains only non-protected cells. combo Upvote 0 Downvote Not open for further replies. Similar threads Question Excel formula to count occurre...
Share Resources
Plus symbol next to sheet tabs is grayed, right clicking on sheet tabs Move/Copy grayed. Sheet and Workbook are unprotected. What am I missing?