General

VLOOKUP on multiple columns
I am trying to write a validation formula that can evaluate 4 columns. The issue is I need to use a list the is 50.000 items in length. I want to store the list in an external workbook. In using VLOOKUP an error message occurs when trying to save a spreadsheet linking to an extrenal worksheet in which the ... 3 Jul 2008 21:45

Copy Command
Hello All, As part of a security system I have set up, I need to prevent users from copying any worksheets. I have protected the workbook, but the copy button is still accessable in the edit drop down. Is there any way that I can disable this action. Thanks ... 4 Jul 2008 01:50

HORIZONTAL SCROLLING
Despite my having followed all the instructions for setting my scrolling preferences, the horizontal scroll bar only appears in the "full screen view" mode. What's going on? ... 3 Jul 2008 20:44

How do I make Word Art fade from left to right?
... 4 Jul 2008 00:49

READ-ONLY PROBLEMS
There are lots of instructions as to how to set up a read-only file for security. But how do I "unlock" a read-only command that has mysteriously appeared on my worksheet? (I am the only one using my computer.) ... 3 Jul 2008 19:43

Setting margins in page break preview
Old Excel easily allowed the dragging of the blue-line margin border just by holding the mouse over the line, getting the double lines, and then dragging the margin. In Excel 2007, I'm getting the blue line borders, but the mouse on the line only produces a cross, and does not allow me to drag that line to make... 3 Jul 2008 19:43

How do I format part of a text cell, but not the whole thing?
I want to either italic or underline, or superscript part of the textbox, but not the whole thing. How do I do this? For example, I want "this is: an example" to have italics on 'this is' but not on 'an example'. Left clicking does not have format cells as an option when I have selected part of the text in the... 3 Jul 2008 19:43

Conditonal Format
I have one cell which u can choose 3 options out on 1 of them being Done and i want to make another cell respond to done by changing it to done aswell but i want to be able to put a date in thereif the logical question is wrong e.g. =IF($B$23="Done",$C$24="Done") Whats wrong with this? ... 3 Jul 2008 23:48

Protection of a Drop Down List
I've created a spreadsheet with drop down lists reflecting people with certain qualifications. As a supervisor I'd like to give my lower-level supervisors the authority to use the drop down lists but not have the ability to copy and paste certain cells over others. How do I protect drop down lists so they can b... 3 Jul 2008 18:41

Excel is pasting values, not formulas by default
I have a user who is right-clicking the select all button on a worksheet, copying the sheet, starting a new blank workbook, then clicking the paste button. Instead of copying All, it's only copying values. We can't figure out why? When we try to do Copy, Paste Special... the dialogue box is different than ... 3 Jul 2008 21:45