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: How can you set Excel 2003 to highlight whichever cell is currently chosen? The way it is set now, I have a white highlight around the current cell,...
Summary: in previous versions of excel I just highlighted a number of cells, hit delete and everything went away. Now my newest version only deletes the top le...
Summary: Hi, I'm having some trouble with conditional formatting in Excel (i'm using windows vista). I want Excel to highlight a cell if the value of that cell...
Summary: =CELL("filename") will return the sheet name at the end of the file's path. In my example: C:\My Documents\[PhoneNumbers.xls]Phone In the above exampl...
Summary: ALSO.. is there a way to format paint more than one cell at a time? (i.e.) say i want to format something in cells b5, b10, and b15, a certain way (de...
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: Well 3 or 5 or 10 would be possible values for difference between the start date or end date. I know that the difference between two dates that are f...
Summary: First, just a terminology point: You are not renaming cells or entries, you are editing them. "Naming a cell" is what you do when you give a cell a Na...
Summary: Hi, I have a MS Excel spreadsheet and sometimes, and it's random, when I try to select ONE cell, there's either 3, 4 or 6 or maybe 10 or at worse 13 r...
Summary: Hi all, This seems like something that should be built into Excel, but isn't, and I've always wanted to tackle it... Assume I'm in Cell A1 in TAB 1....
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: Or, in using Krystyna's example; Click on or make cell A101 active. Then click on the Auto Sum button and hit Enter. It will input Krystyna's formula ...
Summary: Hi there I'm having a bit of trouble with links between one Excel doc and another. They work perfectly as long as both docs are open, but if, for exam...
Summary: Yes. Highlight/Select the range of cells containing the blank cells. Go to Edit, Go To, Special, Blanks, click OK. Type x (or Shift X for a capital X)...
Summary: It is not exactly just the second half of the sheet that the cell's are not working properly on. Basically the first 45 or so row's allow me to chang...
Summary: Hi all I’ve already posted this message, so apologies for repeating myself, but I don’t think I explained myself clearly enough the first time! I ...
Summary: In MS Excel (Office XP) I want to use a web link that includes the value of a cell. Can this be done, perhaps using concatenation? The link: http://ww...
Summary: Some time ago, I saw an e-mail requesting how to highlight an active cell in Excel 2003. I hope this will help. one way to highlight current cell is ...
Summary: You can use visual basic: Private Sub Worksheet_SelectionChange(ByVal Target _ As Excel.Range) 'colors active cell yellow with blue outline Cell...
Summary: Hi everyone, I'm working on a large worksheet on Excel 2003, with over 1000 rows. Each row consists of one movie, and each column provides information...
Summary: Dear All, I have a small query on excel and conditional formatting. Here goes: I have a column that has all dates in them displayed as 02.08.2008 or 1...
Summary: Recording macros is a great way to learn how to write code, but typically results in bloated and inefficient code. Once you record a macro, use F8 in ...
Summary: Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence ...
Summary: Hi I have an excel spreadsheet with two columns of data. The first column is all descriptors. The second column is data that pertains to the descri...
![[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
