how to place non printable watermark in excel sheet

Using office 2003. I have created a pivot table from data in excel with many columns. The data in the comments column cuts off after 254 characters (with...

Hi All, I don't know if this is the best place to start but if I can achieve this then I'm in major brownie points. At work were using Business Objects...

When I do a paste link of cells that are formatted as a Date field the paste link cells display 1/0/1900 as the data. I want the "to" cells to be blank until...

i need to hightlight a cell when i have one birthday in my list

Hello: The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a...

Been racking my brain on this one and I don't know why it hasn't worked. I'm using the Find method in my VBA query to find cells that contain the value...

My worksheet that was created by someone not here anymore has over 2500 pages. At the end of the worksheet in a cell is a little blue symbol in the bottom...

I have a worksheet in Excel there is a column titled Grade, and and another column titled car allowance, I want to give the employee with grade D only BD 100,...

Hello, Does anyone know why the "$" command will not work in formulas when running VISTA? Does anyone have a solution? A simple version of my problem...

I am using this CF to find my duplicates =COUNTIF(A1:A$10000,A1)1. The next part I need is to count the number of duplicates (gray shaded & strikethough). I...

I posted this in this group on saturday. The first half is my question. The 2nd half is the response. My question today... What do I do with it. I think...

Hi Frank, Thanks for input. I've used this Formula referencing the cells with the A1-Style and works ok. Can you explain the use of =1 in this...

OK, so I started the experiment and soon got pulled up. I'm saving my .xls file as a binary .xlsb, and the darned thing wants to put an underscore in front...

I have two worksheets that list, among other information, product codes. These product codes are all 10 characters long, but some are entirely numeric (i.e....

I have an Excel workbook with several worksheets. I want to email just one of these worksheets to a friend. It would be great to be able to right-click the...

I'm getting #DIV/0! with the following formula, the cell is format as a percent. Thanks =(E34-D34)/E34 E34 = 0 D34 = 0 Result should be 0%

Hello everyone, I am trying to sort a list of temperatures to analyze a chillers operation. The chiller turns on when the outside air temperature is 80, and...

Hi, i need a macro to copy from one cell the text below and to paste only the contenet of the parenthesis. Invoice currency (USD): I need to paste only USD....