Lock format changes

Is there anyway to lock format changes. Specifically, users are clicking and dragging cell values down the columns.  I know education is the answer....copy/paste special/values only, but this is a bunch of old dogs that dont want to learn new tricks.  I would like for them to be able to click and drag down but not copy borders and shading.  We are using xl2000
Thanks
0
anonymous (74721)
11/29/2003 12:56:30 AM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
450 Views

Similar Articles

[PageSpeed] 24

I saw Gavins reply in a previous post recommending to unlock the cells in question and then protect sheet.  This doesnt appear to work.  I might also add that copying down changes the Font size.  The size currently alternates between 8 and 10.  Basically, I want the click and drag to only copy the cell value.
Thanks in advance
Steve
0
anonymous (74721)
11/29/2003 9:01:06 AM
I use xl2002 and when I rightclick and drag, I get an option for:

"Fill without Formatting"

Maybe you could train rightclick/drag.

steveh wrote:
> 
> I saw Gavins reply in a previous post recommending to unlock the cells in question and then protect sheet.  This doesnt appear to work.  I might also add that copying down changes the Font size.  The size currently alternates between 8 and 10.  Basically, I want the click and drag to only copy the cell value.
> Thanks in advance
> Steve

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
11/29/2003 3:12:22 PM
Yes I have that option (xl2002) on my tablet PC bit not on the desktops (XL2000)
0
anonymous (74721)
11/30/2003 4:51:07 AM
My memory ain't what it should be.  I meant that I could see that option in
xl2002, but I'm not sure when it was added.  If it's been there since xl97 or
xl2k, then you might want to use it.

(But if it was added in xl2002, then your desktop users will be out of luck.)

Sorry about the confusion.


steveh wrote:
> 
> Yes I have that option (xl2002) on my tablet PC bit not on the desktops (XL2000)

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
11/30/2003 4:24:22 PM
Reply:

Similar Artilces:

Maintain Formatting with Formulas
I am writing a formula that references multiple cells as the possible source cell depending on certain parameters being met. My question is whether anyone knows how to maintain the formatting in the display cell? My possible source cells all contain different number formats (i.e. -1234.0 and ##00.0E-+00). Is there a way to write this into the formula, or is there a formatting option that allows you to keep the source cell's format? Any help would be great! Use the TEXT function to apply the same format to the values from the referenced cells as was used on those referen...

locking up
This might be more of a GDI question, but since I'm in MFC, I'll ask: Would BitBlt-ing to the screen repeatedly tend to lock up a program, after alt+tabbing to another application? If so, why? This seems to be happening to me, and I want to get to the bottom of the problem. What I have is either a fade loop or a screen-size redraw, both based on a timer and bitblt. Quite often, after I leave the program to go to another app, I cannot return and must "end task". "Steve Russell" <srussell@removethisinnernet.net> wrote in message news:%23YFL5Ks%23F...

FRX row format, MDA codes should allow me to use wild card charac.
FRX row format, MDA codes should allow me to use wild card characters, such as 11-1100-00,[Group.CODE???] 11-1100-00,[Group.CODE001]+11-1100-00,[Group.CODE002] -- Regards, Raja Raja, When using MDA Group and/or MDA Code within FRX you must explicitly enter the code IN FULL Use of wildcards is not supported, nor permitted. You will have to list each Code individually as you illustrate in your second line. Robert "Raja V" <rvijayarangan@hotmail.com> wrote in message news:84D34C61-13BC-42DF-B393-3F16E3E9C151@microsoft.com... > FRX row format, MDA codes should allow me to...

Desktop Alert Locks Computer
Greetings, I am seeing a little quirk on some of my desktops. It only happens occasionally, but it happens to different models of PC. Not all the time, but once in awhile, I have users that complain of their PC freezing. The only remedy is to do a hard reboot. I have noticed in these instances, that the desktop mail alert ( the preview that pops up by the system clock when you get a new mail) is showing when it froze. If I go into Outlook and turn off the desktop alert, then the PC freezing stops. So, I know that the Desktop Alert is the cause of the problem. Has anyone else ever seen this? Th...

Change Field Caption
Is there a way to change the text on field labels? For instance, I want to use the Requested By field in POP for something else. Can I set GP to replace the text “Requested By” with something else across the board, and in SmartList? Thanks. Scott Not sure about SmartList but changing the text field to say Requested By is very simple. Open the POP window... go to tools - customize - modify current window (depending on your gp version) and change it. Then grant access to the modified window. "Scott Ferrar" wrote: > Is there a way to change the text on field labels? ...

Capturing date changes
Hi I have an excel spreadsheet let me set up this example: Column A Column B Client Name Date Called ABC XYZ Situation if I call ABC on 5/16/89 but I change the date the next day to 6/16/90 I need to maintain in another sheet all of the dates I contacted ABC for purposes of reporting. I could use your help thanks One approach -- though awkward and CPU-intensive -- would be to tie into the Worksheet_Change() event. You could use the 'Target' parameter to determine if the change was in the column (and/or row) you're interested in and, if so, cop...

Changing item width in a CTreeCtrl
H When we increase the font size of the string in a tree item, the font changes; but the width of the tree item remains unchanged. Hence, part of the string gets truncated. Is there a way to change the item width I have done something similar to this guy. Pretty much a partial owner draw tree control http://www.codeguru.com/treeview/item_color_font.shtml The problems that I have ran into and haven't gone back to fix yet are, 1. The tool tip only activates with in the rect of the original font, and the selection rect is only as big as the text in the orginal font. Ali R. "Sarav...

how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY ie. Saturday; May 23, 2005. Woudl you please help me out ? Thank you. Regards, Hesam Shakourian Check this out. http://support.microsoft.com/?kbid=213742 but change the format to "dddd, MMMM dd, yyyy" "Hesam" <Hesam@discussions.microsoft.com> wrote in message news:93495F75-4196-4208-9C0D-E800BCAE3A89@microsoft.com... > I need to chage my date format, in the header to Day; Month DD, YYYY > ie. Saturday; May 23, 2005. > > Woudl you please help me out ? > > Thank you. > &g...

Formatting envelopes
Hi, I posted this question before, but I don’t think I asked my question correctly. I have a table with name and addresses and another table with envelope sizes (width and height in inches). Is it not possible to select a LETTER size paper in LANDSCAPE mode and print envelopes using the width and height to calculate the margins needed to print on the selected envelope? Another question? When printing in landscape mode do all printers print the page from left to right? If not, my idea will not work. I would really like to get this to work and your help would be greatly appr...

Lock formula to cell
I want a formula to lock to a cell so that when I add or delete a column the formula will always remain with say column H I know if the sheet is Password protected this will prevent this happening but that is no use when I have to unprotect the sheet to delete a column. Anyone got thoughts on this? regards Pat Hi Pat without using VBA you can't achieve this Frank Pat wrote: > I want a formula to lock to a cell so that when I add or delete a > column the formula will always remain with say column H > > I know if the sheet is Password protected this will prevent this >...

locked excel File ??
Hi . I am working with my colleges with one Excel file in a shared file system. Sometime - when I open the file, there is the message "locked from College" - but he is definetly out of office and shut down his PC. We are using Excel 2003 + Excel 2007. What can I do?? THnks for help Susan ...

Cannot Use 2007 Office Resource Kit Technical Library in Compiled Help format
I downloaded the 2007 Office Resource Kit Technical Library in Compiled Help format, double clicked on it, cleared the Always ask before opening this file check box and clicked Open. All I got was a window with a little icon in the top left. How do I get this to display properly? Thanks for reporting. It appears something is wrong with the latest published version (version 5 published on 6/12/2009). I've passed it on to the Office Resource Kit writer team at Microsoft. In the mean time, you can still access the content on-line via; http://go.microsoft.com/fwlink/?LinkId=127122 The c...

cleared transactions change to reconciled
I am using Money 2003 Standard. The "Tools/Options/Online Services/Automatically mark downloaded transactions" box is not checked. I mark a transaction as 'cleared', close Money, and shut down. The next time I open Money, all 'cleared' transactions are marked as 'reconciled'. Any suggfestions? Thanks in advance! ...

Locked out of database
Not sure what happened but get a message saying "database has been converted from a prior version of Access by using DAO compactdatabase and is now in a partially converted state." It says I should be able to import tables into a new data base but when I try this it just gives the same message about converting and the data base just doesn't open. Please help because lots at stake, have to do a report based on these tables so am waiting with anticipation!!!x Hi Pete, Usually this means you are opening an earlier version of Access in a new version. Make a copy of the data...

Outllook2007 to open my Outlook2002 Win7 says files locked.
I'm following 2002 to 2007 instructions step by step. When I point Outlook to my ..pst file, I get access restriction messages. How do I make sure these files can be accessed by Outlook 2007? Thanks. Which exact steps are these? From your Outlook 2002 machine, copy the pst-file to your Outlook 2007 machine and place it in a convenient location such as My Documents\Outlook\ In Outlook 2007 you can then reconnect to the pst-file via; File-> Open-> Outlook Data File... For details see; http://www.howto-outlook.com/howto/backupandrestore.htm -- Robert Sparnaai...

How do I change the name of Access 2007 Database?
Unable to rename or delete Access 2007 databases created for practise. Can anyone help? On Nov 22, 3:56 pm, leroyd <ler...@discussions.microsoft.com> wrote: > Unable to rename or delete Access 2007 databases created for practise. Can > anyone help? What is the error message you are getting? navin "navin" wrote: > On Nov 22, 3:56 pm, leroyd <ler...@discussions.microsoft.com> wrote: > > Unable to rename or delete Access 2007 databases created for practise. Can > > anyone help? > > What is the error message you are getting? > > navi...

excel locks up after selecting a cell #2
excel locks up after selecting a cell. When ever, I select a Cell, that will automatically selects all the cell and this freezes the entire computer. Can any body who would help me resolve this issue? Please help.... ...

Formats for Printing Macros
Excel 2007 I have been asked to produce some printouts of macros. How do I set the print format (margins, etc.)? -- Gary''s Student - gsnu200909 Do you mean you want to print the code itself out? If so, I don't know the specific answer to the question as you asked it; but, if this was for me to do, what I would do is just copy/paste the macros into a Word document, format them there as needed and then print them out from there. -- Rick (MVP - Excel) "Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message news:...

Lock autoshape to fixed position
Hello, Does anybody know if it is possible to keep an autoshape to a fixed position. I have a worksheet that has two panes, one is frozen i.e. a fixed header and scrollable rows. On the bottom of the page I want to put a button bar made of shape buttons. The problem is that when I scroll, the buttons scroll too! It would be nices if I can keep them in position. I know that is is possible to add a second window, but that does not look so well... Any ideas? Multiple fixed panes would be a great option! Change the alignment option to be absolute. Picture properties > Layout tab > Advan...

Changing Primary Attribute after creation
I cannot seem to find a way to change any aspect of the primary attribute after creation. Is this the case? It is very hard to work with. I cannot even change the requirement level after creation. This is very diffcult to work with. There's no way to change the primary attribute after creation, so define it carefully when creating a new entity. A big problem is that it's somewhat hidden on the second tab in the entity creation form and it's very easy to forget about it. Anyway, before creating a new entity, you should write down the settings that are not changeable la...

Money "lock-out" solution-thanks Kurt
Kurt Thanks for the idea. It worked. I unistalled money 2002 and the reinstalled using custom mode...up and running again! Thank -you What happens to all your data when you do that? Do you still have your data? I tried reinstalling, but no luck. I hate to uninstall, since I would lose all the data, right? Would appreciate info. Thanks, Alice >-----Original Message----- >Kurt > >Thanks for the idea. It worked. I unistalled money 2002 >and the reinstalled using custom mode...up and running >again! Thank -you >. > Your data is in a file *.mny. This is ind...

Form locking up
I've completed my own Linked Table Manager wizard, so that the connections I create to SQL Server and Oracle database on my network don't require a DSN (DSN-less connections). This wizard exists in its own mda file, which I have added as a reference in several of my databases. In my test database, this wizard runs great. I've got a command button that calls a function (fnRefreshLinks) that exists in the wizard. It opens a form, refreshes a list of the linked tables, tests the link, and provides me with some options. When I run this same function from another database, it...

change lname, fname to fname last name
I have work sheet with names listed as last name, first name, I would like to have them as just first name last name. Suggestions?? if your data starts in cell A1: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1)) "Al Wills" wrote: > I have work sheet with names listed as last name, first name, I would like to > have them as just first name last name. > > Suggestions?? Hi! Try this: A1 = Smith, John =MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1) R...

Where am I being locked out?!
This is an unusual problem and I'm hoping someone will have come across something similar before. Before I start I should state that I've hardly used Windows Server or Active Directory, so go easy on me if this is something obvious! I am having my account locked out on a daily basis. I know that this isn't to do with my machine as it happens even if I get my account unlocked and wait a day without turning my machine on I still can't log on the day after. I'm pretty sure it's a piece of software that I've installed somewhere that keeps trying to con...

Changing the View options
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Something happened to my View and I'm missing toolbar elements I like. I used to have font, bold, alignment, paragraph, format paint etc across my top bars. Now when I want something like that I have to go find it and it pops up these palettes. Also, there is a bar for document elements that I don't want showing. How can I get back to my original bars. I've tried all kind of tool bar clicks but not finding it. Thanks, What you're describing sounds like the Formatting Toolbar is not being displaye...