General

More than selected rows being highlighted
My workbook has sheets with many formulas. Sometimes when I highlight multiple rows or cells, more than what I selected is highlighted (for example = I can't highlight rows 5-10 without 11-15 being highlighted). The problem seems to go away when I delete or edit individual rows or cells, but reoccurs after I ... 17 Mar 2010 03:36

can I have a multiselect option for a list box in excel 2003
I am working with Excel 2003, I created different list boxes for different fields but I wanted to know if I could select more then one answer by using CTRL command? Is that only available for later versions? thanks ... 15 Mar 2010 15:51

Folder/Tabs Newbie Question
When you create a spreadsheet Excel creates 3 tabs at the bottom - is it possible to open one of the tabs and create a set of sub-tabs, ie I could have a main tab for week one, week two etc. and the within the tab Week1 could I have 7 sub tabs for each day of the week. Many Regards Andrew ... 15 Mar 2010 14:39

how to use countif to incorporate filters
I have been looking for a solution to my issue for several hours now but I have had little luck finding an exact answer, so here goes. I used auto filter to filter the data in my spreedsheet I have several columns but to simplify things I am mainly concerned with three; one is regions, the other is dealers, and... 15 Mar 2010 15:51

How can i add a line break into a formula in excel 2000?
"Bretter99" wrote: For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to put the result into a single excel cell like this: I LIKE BEEF BURGERS But i cant see how to manually insert a line break into my statement as in something like: =concatenate(a1,<line br... 15 Mar 2010 13:30

Importing a picture behind worksheet?
Dear simonc, If you solved this problem please teach me how to do it too beacause I need multiple pictures to use it as backround. It will really help me and my co-workers!!! Thks!!! "simonc" wrote: Is there a way you can import a picture into a spreadsheet and still be able to see the spreadsheet c... 15 Mar 2010 13:30

Excel super slow on paste function in 2007
When you copy and paste one cell to another I get the circular waiting bar and after 4-5 seconds it pastes. If I'm doing a bunch of cells, it still takes 4-5 seconds per cell and the cells will appear right to left, 1 every 4-5 seconds until it's complete. If I hit ESC, everything copies and pastes right away.... 15 Mar 2010 13:30

Question regarding link cells in different workbooks
After succesful linking from one workbook to another,, we would get "0" (zero) on the designed cells if there is no data on the resource cells. My question is what should I do if I want to have something instead e.g., "NA". -- Aline ... 15 Mar 2010 13:30

Extremely slow calculation of lookup formula
Excel 2003/SP2, running under Windows XP seems to take forever to calculate a formula when it is copied to a new cell. My computer is a P4/1300 with 768MB memory. Sure, it could use a replacement, but that's not presently in my budget. The problem occurred within the last day or so, and I can not figure out a... 15 Mar 2010 12:21

removing objects..!
hi all.! i have copied a column of data from a website and pasted it into an excel sheet..! the problem is one of the cell is containing an object, something like a text box may be a "radio button" while copying from the website..! i tried my best to remove that object but could not succeed..! any help,... 15 Mar 2010 13:30