Summary: I'm running across the same issue as a previous poster ( http://www.computing.net/answers/of... ) in Excel 2007. Namely, that often when I click on a...
Summary: I was having this problem, and found a locked thread on here (due to age). However, I believe I have new information that sheds more light on the prob...
Summary: I have an ongoing issue...various spreadsheets (none in particular...could be one or two or all of them) will start taking on this behavior for no app...
Summary: You can use a “defined name” On Sheet 2, Column B, Cells 1 thru 10 input any character into each cell. Highlight Column B, Cells 1 thru 10 On the ...
Summary: For years I have happily used EXCEL 3.1 for some simple jobs. It does everything I need. At the weekend my HP deskjet 400 went kapput and I replaced i...
Summary: Yes, I really like the way this works but need to know how to do if the columns and rows are different between the sheets. For instance sheet 1 date ...
Summary: I need to know how to do if the columns and rows are different between the sheets. For instance sheet 1 date at A1 and need to have copy on sheet 2 at...
Summary: I am assuming that you are getting a dialog box telling you that the workbook contains macros. If you "tried" to write the macro, then you probably ha...
Summary: First, let me state that I have tested my code in Excel 2003 only, but I don't believe that it should act any differently in any other version. re: "C...
Summary: Hey - It works perfectly! The only problem is that I need to be able to select multiple cells in column A. Right now it only works for the first cel...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: Hi guys, I have a worksheet in excel. It basically has a bunch of columns and shows. What I want to be able to do is select rows which match certain t...
Summary: Thanks everyone for all your help! I really appreciate everyone looking into this. I found another solution that was posted by Anonymous user on ano...
Summary: When I click on a Cell (eg. 10, "A" in Sheet 1) in MS Excel. I am trying to Hyperlink to another worksheet (eg. Sheet 2) but also sort this informatio...
Summary: From: http://www.computing.net/office/www... Quoting Response Number 23 Name: Bryco Date: June 03, 2004 at 13:14:58 Pacific Subject: Excel list valid...
Summary: Hi, Not sure if this is what you are after and I am working in Exl 2003 but, You can copy the value in the cell in excel and paste it into word, you c...
Summary: Is the Excel file already open when you use the hyperlink from Word and/or Outlook? Here's why I ask... I did some testing and found that the link in ...
Summary: What did you try as far as troubleshooting the code to see why it was giving you the error? If you clicked Debug in the error window it would have hi...
Summary: how can i select multiple non adjacent cells that are the same number of rows apart and paste them adjacent to each other in MS excel? I cant use Ctr...
Summary: re: .She is wanting me to "research" the capabilities of excel and macros Let's put it this way... Macros are extremely powerful and it makes sense to...
Summary: Mike's method will indeed work, but there a couple of subtleties to keep in mind. 1 - I believe that using =0 will cause Excel to recalculate the cell...
Summary: Well, that's a bit clearer! I don't have 2007, but the concept is the same as in 2003. You need to base your formatting on the results of an IF statem...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a lo...
Summary: Hi, The simple answer is to use conditional formatting. Conditional formatting allows the cell pattern colour, font and font colour, and borders to b...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
