I have a List in excel that covers 4,000 + rows. There is supposed to be an asterisk in the bottom left corner so you knwo where to enter data. The asterisk...

Here it is... F G H I 12/31 0040 01/01 01/02 12/31 01/01 ...

In Excel 2003, if we set a page to print B&W, graphs and charts would still print in color. It seems that in Excel 2007, if we set a page to print B&W, the...

I'm doing a price comparison on food products from many different companies. Is it possible to have it automatically highlight the cell that contains the...

Hi, I have column D with 24000 rows ( D1 to D24000 ). I need to reduce all the values already entered in that column by 5%. I have 07 Microsoft Office and I...

How i can find the mediam in a group of numbers

hi community i saw one of my colleague laptop that when he execute his xlsx 2007 and click the Create New workbook, it displays the older version of xls 2003...

I'm using this macro to make one column values only: Sub ValuesOnly( ) Dim rRange As Range On Error Resume Next Set rRange =...

Hello, I apologize if this is a duplicate. I posted my question earlier but it doesn't seem to have shown up so I'm going to try again. This is what I...

Hello. I already search some post about this but I didn't understood. I have a sheet with 3 columns: EmployeeNumber; Name; AdmissionDate In another sheet I...

I'm trying to have a cell say that someone is late or on time. I have a cell that has subtracted the actual punch in time from the call time (difference). ...

Hi, I have a spreadsheet that I have to return a specific value based on two criteria, a state and loan amount. My columns are loan amounts while my rows...

Can anyone tell me if there is a way that I can divide the cells on a spreadsheet by 1000 without going to each individual cell and dividing by 1000. --...

is there a limit on how many fields you can have in a pivot table in order to insert a calculated field? i have 10 columns...if i create the pivot with all...

I appear to have set the forward slash ket (/) so that it does not appear in the selected cell but initiates numbers to items on the toolbars. If I do a...

hi community can community assist me in this task, i wanted to fill series, say, I place alphabet letter, "a", in one cell and when I drag downwards or...

I am trying to compare rows of information. If all cells in a row compare to al cells in the look-up table, then I want it to return a value in the usual...

Is there a way - without using PivotTable - to rotate data in an Excel table: rows become columns and columns become rows? I wouldn't mind cutting...

Hi, Recently (I'm not sure why) the pivot tables I create have no lines on them (more technically -- all of the lines are white and you can't see them)? I am...

Hi All I need to insert blank columns after each column of data on several worksheets. Can help? Thanks in advance. vcff