Currently Excel (I'm using 2007) will show multiple buttons on the taskbar for multiple documents which is a useful way to switch between documents despite...

I have a list with a column containing formulas. With some rows hidden/filtered I want to copy the visible cells and copy paste special the values of only...

can i get numbers changed in words(english) in excel sheet?

In the first time, I insert a comment in a cell of excel work sheet. The position and size of comment box is OK (Comment box is in the upper right of the...

Dear Excel Experts, I have the following tables on my sheet 11 Mar 09 SUP1 $30 1 Apr 09 SUP1 $50 2 Apr 09 SUP3 $10 4...

Hi all I set the print area (foolishly) on a particular sheet. Now it's displaying the dotted lines everywhere. I want to present this sheet to 200+...

I'm sure the question I have is covered in Excel Help but I obviously don't know how to ask the question so that it displays the answer so I'm hoping someone...

Hello, Can someone please let me know how I can increase the commetn size on tracked changes so that i can see all my changes. Currently when I make a...

Hi, I've written this bit of basic code to hide some rows for me: Sub hiddenrow() Range("A1").Select For i = 1 To 516 ActiveCell.Offset(1,...

Hi all! I'm busy creating a macro to automatically update certain values, text and cell formats etc. once it is run. The workbook to be updated, as well as...

I had use format cell to change my cell display for a number that round to the nearest thousand. i.e. if i input a number 123,456, i use format cell to make...

I Have a Macro which contains some Costing Related Report... Now i got a problem with the macro that for the next month that the data may vary and the Macro...

Hello, Im new in using excel macro. Im familiar with Visual Basic 6.But not in VBA. Im on my intern right now. My boss ask me to make a program using macro...

I like that Excel puts a negative sign "-" in front of negative numbers but how do I get the positive sign in front?

Hello, I do a lot of work with financial years that run from mid-year to mid-year (eg 1 Jul '08 to 30 Jun '09). I think this is more a feature request but...

I have 2 pivot tables from the same source data. I want to change the selection in the page area of one pivot table and have the second table similarly...

A question about something that is really frustrating me. I am trying to adjust some raw data (for an international finance class) obtained from the Fed...

I have the following code that gives me a #N/A for some cells. I want to change it to "" using an error statement such as =IF(ISNA(.... Can anyone assist me...

Column D = Date closed (1/1/2009 format) Column AF = Day Closed (custom "d" format) Column AG = Week Closed (General Format) Column AF gets the day closed...