 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Lock only borders
I want to create an exceel worksheet where the borders are protected from copy/paste and drag/drop but the users can still type in data. Thanks By default all cells on a sheet are locked when sheet is protected. For Excel 2002 and newer versions....................... Select the cells to type in.......presumably these cells have borders. Format>Cells>Protection. Uncheck the "Locked" option. Tools>Protection>Protect Sheet>Allow users to: Checkmark "select unlocked cells". All other checkboxes remain cleared. OK your way out. Gord Dibben MS Excel MVP >I want to create an exceel worksheet where the borders are protected from >copy/paste and drag/drop but the users can still type in data. > >Thanks I want a sheet that someone can type into the cells but the borders remain locked. > By default all cells on a sheet are locked when sheet is protected. > [quoted text clipped - 18 lines] > > > >Thanks That's what you would have if you followed the instructions given but only for some cells. For "ALL" the cells? CTRL + a(twice in 2003) to select all cells. Follow my instructions for unlocking and protecting. Gord >I want a sheet that someone can type into the cells but the borders remain >locked. [quoted text clipped - 21 lines] >> > >> >Thanks I have a table with thick borders around the table heading and then regular borders around the rest of the cells. If I lock the header portion and not the rest of the cells (which I want to be able to type into) and type in the first row and drag/drop the information through a column, the thick border continues down the column also. I would like to lock all borders so that there is less time spent formatting the borders. > That's what you would have if you followed the instructions given but only for > some cells. [quoted text clipped - 32 lines] > >> > > >> >Thanks I can't visualize what you are saying. You say you type into row 1 then drag and drop. Where is the Table Heading area that is locked? Post the exact range please. In my mind I see it above the cells you wish to type into and you should not be able to select any cell in that range because it is locked and sheet protected. Gord >I have a table with thick borders around the table heading and then regular >borders around the rest of the cells. If I lock the header portion and not [quoted text clipped - 39 lines] >> >> > >> >> >Thanks Lets say A10:T10 has title cells --- Date Recieved, Date used etc. Those cells have thick border (top, bottom, right and left). Cells A11:A30 B11:B30...T11:30 have thin borders. If you type a date in A2 and drag drop A2 to fill cells A3:A30 with the same date the bottom border of A1 (i.e. the top border of A2) will appear in A3:A30 when those borders should remain a thin border. > I can't visualize what you are saying. > [quoted text clipped - 51 lines] > >> >> > > >> >> >Thanks Assume A10:T10 is a typo and you mean A1:T1 The bottom border of A1 is thick. That is also the top border of A2. You could change the top border of A2 to thin which would result in bottom border of A1 being thin. I would insert a row between 1 and 2. You can set the height of this row to a very small number. Give it no borders and lock A1:T2 Gord >Lets say A10:T10 has title cells --- Date Recieved, Date used etc. Those >cells have thick border (top, bottom, right and left). Cells A11:A30 [quoted text clipped - 58 lines] >> >> >> > >> >> >> >Thanks > I want a sheet that someone can type into the cells but the borders remain > > By default all cells on a sheet are locked when sheet is protected. [quoted text clipped - 19 lines] > > > >Thanks what a frustration saver, thanks I suppose I could just add another row that below A1:T1 that is locked but does not have a thick bottom border. That will accomplish what I want.... > I want to create an exceel worksheet where the borders are protected from > copy/paste and drag/drop but the users can still type in data. > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.