Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Is there a way to "lock" columns, rows and borders so new data

Hi Julie, I tried this with a slightly different out come. i need to lock the
formats and i tried all what u suggested with one minor difference. i need to
be able to sort the selected cells, and not have the formats move. which they
are moving and its driving me batty.

any suggestions?

Gregg

"JulieD" wrote:

Hi

what version of excel are you using ... i've just tested it here ... if you
choose the cells that you want them to enter data in & "unlock" them and
then choose tools/protection /protect sheet and only have
select locked cells & select unlock cells ticked then they shouldn't be able
to change the formatting of the sheet. (or even of the "unlocked" cells)

Cheers
JulieD

"glaserk" wrote in message
...
thanks... but I'm stupid. I need to know how to lock the columns, rows
and
borders without locking the whole sheet. I tried to allow users to select
unlocked cell and format cells, but then nothing could be changed.

"Frank Kabel" wrote:

Hi
have a look at 'Tools - Protection

--
Regards
Frank Kabel
Frankfurt, Germany

"glaserk" schrieb im Newsbeitrag
...
Help! I don't want to have reformat each time. I have several pages
that
should look exactly the same, and I want to just fill in the blanks
once the
format is set up. Is there a way to lock the formats?





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
Plz help me w/ "GROWTH" function. My data in rows not columns bk Excel Worksheet Functions 1 March 2nd 07 12:29 AM
Plz help me w/ "GROWTH" function. My data in rows not columns bk Excel Worksheet Functions 0 March 1st 07 10:50 PM
Make pivot table with multiple "data" fields in columns not rows? cdomby Excel Discussion (Misc queries) 1 January 15th 07 05:54 PM
Possible to "rotate" range of cells so columns are rows and vice versa? [email protected] New Users to Excel 3 January 5th 07 06:21 PM
2 questions one on list/combo boxes and the other on "atomically" hiding columns or rows. Marc New Users to Excel 1 March 4th 06 06:13 AM


All times are GMT +1. The time now is 01:13 PM.

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

About Us

"It's about Microsoft Excel"