ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fill down on a protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/4193-fill-down-protected-sheet.html)

Pat

Fill down on a protected sheet
 
I notice that the filldown feature is not available in a protected sheet,
does it mean protection must be removed first before using filldown?

Pat



Gord Dibben

Pat

If the cells selected for your filldown are unlocked and the sheet protected,
you should be able to access the filldown.

Otherwise...unprotect the sheet.


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 16:52:31 -0000, "Pat" wrote:

I notice that the filldown feature is not available in a protected sheet,
does it mean protection must be removed first before using filldown?

Pat




All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com