Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default Protecting a block in a cell

I don't want to protect an entire cell, but part of it. Example: Iwant to be
able to protect cells F28-F39 and not protect Cells F1-F27. How can I do
that!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Protecting a block in a cell

By default the cells will be locked if you protect the sheet. Select cells
F1-F27, Format/ Cells/ Protection, & unselect "Locked". Then protect the
sheet.
--
David Biddulph

"Rosa" wrote in message
...
I don't want to protect an entire cell, but part of it. Example: Iwant to
be
able to protect cells F28-F39 and not protect Cells F1-F27. How can I do
that!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting a block of Word info into a single Excel cell PeterJordan Excel Discussion (Misc queries) 3 May 7th 07 07:24 PM
Password Protecting One Cell Erinayn Excel Discussion (Misc queries) 1 January 11th 07 08:52 PM
Can I insert a cell reference into a block of text? painterpat Excel Discussion (Misc queries) 2 June 12th 06 11:31 AM
comparing a cell to a block off cels B4MB4M Excel Worksheet Functions 4 May 14th 06 10:21 PM
Cell Block and Furmula Bar display MAC Excel Discussion (Misc queries) 3 April 11th 06 02:43 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"