I want to open multiple worksheets from the same workbook and tile them horizontally. I know you can do it with multiple workbooks, but i can't open worksheets...

When I attempt to copy from one workbook and paste into another, copy appears to work but paste does not. The paste menu item is grayed out in the workbook to...

Note: This is with the Office Clipboard turned OFF! For example, If I write the following in 5 cells in Excel. Then I Copy (CTRL+C) the Cells: and to...

I am really stumped. I have a column of numbers that refer to locations on the body and I need to count how many of these locations are on the face. There are...

Just got Windows XP/Professional and Excel 2003 after being in an Office 2000 environment. In Excel 2000 when multiple worksheets were open and I minimized to...

I have browsed the questions to remove the middle initial from the name cell and see the response if the middle initial is in the middle of the name in one...

I have a spread sheet with data in non-adjacent cells. I would like to average the data in the cells only if the cell does not contain a zero. How would I do...

My pc is running Win XP. In MS Word and MS Excel (office 2000) I can open files over network from win98 machines. I can also make changes and save. However, if...

I created a Pivot chart from Pivot table, however, as the user changes the options (from pivot fields), then the chart type changes back to default one (I want...

Nasser, Gregg's post worked perfectly for me. In the formula box you would simply divide the 2 columns provided you have the appropriate columns and rows...

Hi All, Why a horizontal range, e.g like A1:G1 cannot be used in ComboBox ListFillRange? Is there a workaround for that? Another question: can an OFFSET...

I have a few users that are annoyed that every time they open a specific file I created with links and marcos - they have to click the message box to update...

I'm using Excel 2002 SP3 With cell f1 set to the value xyz, the formula =match(f1,'sheetname'!$a$1:$a$500,0) returns #N/A I change this to

Hi helping guys... I have a rather unusual situation. I have two excel files, the first one has information on incoming products ordered by date and the...

I cannot seem to format cells not to have rounding. I have increased width of columns, increased decimal places. Neither helps, what can I do?

Hi, I have an Excel file of 1 worksheet, containing data in about 20 rows by 20 columns, which is 310 kB ! I noticed copying the range of cells A3:E7...

The Document Recovery task pane (where previous versions of files that have been saved using the auto recovery feature are stored) does not seem to appear each...

In print preview, and on printed pages, all colored font shows up as black. White font stays white. Font colors are displayed correctly in the worksheet. I...

I would like to save a file with multiple sheets while retaining the current values and format, but not the links so I can minimize file storage space and load...

Hi everyone, I've got a small problem. I'd like to send my active sheet with a CDO code. I use .AddAttachment ThisWorkbook.ActiveSheet but it looks...