Hi, There are 10 columns which are hidden between two columns(A and X). I want to unhide only 1 or 2 columns without enabling(unhiding) remaing How can i do...

Sorry if this offends anyone, but I need an answer and I already submitted this question yesterday. the below formula was close, but not quite. I only want...

Hi I have workbook that contains a number of sheets. On a separate sheet I would like to be able to insert a hyperlink so that I can jump to a specific...

I have 10 cells in column A A1 A2 A3 A4 A5 etc What I require is if cell A1 is blank then blank in all cells, if A1 is one then add one to each cell ie if A1...

I have a date range from month first to end of month. I want to count no of entries from that list which range from 10th to 15th. For eg. a list starting...

I have 2 x files, i.e. "1.xls" & "2.xls". I want cell C3 in the file 1.xls to reflect the data that I have entered in cell C3 of the file 2.xls. How do I do...

Hi, I have to change my e-mail address recently due to relocation. I have registered for a new MS Passport ID then. However I noticed that whenever my post is...

How can I fill in the empty cells in a column like the following : 4525980367 4525980560 4525988472 4526001271 4526005001

Dear Excel experts. I have a Pivot Table (Excel 2007). The table reports monthly expenses, monthly budget numbers and full year approved budget by product...

how do I mak a cell blink Tar very much -- V-D-O

User State Plate User State Plate User State Plate jmolini OK 2MO980 mboulette OK 2MD980 jbradley OK 2MO980 1 jmolini TX 30VVF8 dfoose TX 60VVF8 awright TX 30V...

Appreciate if some sharp individual can assist me with the following issue. In cell A1 I have a date. In cell B1 I have a number between 1 and 100. I need a...

I have a financial statement workbook. I have a dropdown that lists our 3 locations and "all" for a combined Income Statement. I select all, print,select...

Hello, how would I change this formula (=SF_Load!A2) so it shows a nothing if the cell it's refeerencing is blank. It currently shows 0. Thanks

Is there any way to separate Dollar amount to another column (last five digits)? Not all figuers have a $ sign in front of the amount. Thank you USPS...

I have a workbook with several tabs that have been renamed with #s corresponding to what is in each worksheet. Is there a way to sort the worksheet tabs and...

Question: I want every cell in row 2 to have red background if its value is different than the corresponding cell in row 1. I can do this to cell A2 if in the...

I have a template (.xltm file) containing a macro that is assigned to a button on the QAT for that template. The macro is in ThisWorkbook. When I just open...

I would like to insert Word Art into my excel worksheet and manipulate it as you can in Word (make it harched), but I don't know how to do this in excel. ...

I have several column charts displayed on a tab sheet (worksheet) of an Excel 2007 workbook. Some charts have a single series of data, others have more than...