Summary: One of our users is having a problem with merging cells in excel 2002. She cannot merge cells, but only in one worksheet. The merge button is even gra...
Summary: I'm not sure why your paste function would have pasted rows of data into single column. Never heard of that before. Are you sure that each row of data...
Summary: Hi, I'm working on a 2 page Excel spreadsheet. The first page is fine, but I want to delete all the remnants of lines and other junk in the second pag...
Summary: Hello, Does anyone know how to make Excel treat a cell as blank if there is a formula in it? I have a formula which puts the contents of one cell int...
Summary: Is there anyway that I can referrence a cell in excel in a word doc much like you referrence cells from sheet to sheet in excel? I have search long a...
Summary: By default, when you protect a worksheet, all the cells on the worksheet are locked. You can however, lock only specific cells and ranges. Enter "Unl...
Summary: I need to input a negative time value into a time formatted cell in excel. I have a cutom cell format: [hh]:mm;[Red] -[hh]:mm This works perfectly for...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variab...
Summary: I would like to convert visible hyperlinks in my Excell Workbook into regualr text, so when I click on it it doesn't act like a link but as a regular ...
Summary: Is it possible to combine one or more functions in a single cell in Excel 2003? I tried today();now() but that didn't work. www.monkonline.tk ...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO ...
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: My newly installed excel 2003 cannot display the changes to cell formatting, i.e.the color of the word and fill of the cell, but it can display normal...
Summary: Within a specific Excel 2002 Spreadsheet that I have, I am unable to change the color/fill of specific cells. I can change the color/fill of cells in...
Summary: hi all if you are using VB with excel what is the function to tell what space you are in a cell; I want to go through a cell and change the data, and ...
Summary: I'd like to know if there's a way of locking a certain cell so that noone can overwrite the formula that's in it. I have Excel 97 and have created a s...
Summary: Hi everyone, I need some help here. I'm running excel MS office 2007. I have a main file that as a hyperlink to an external word doc. I'd like to plac...
Summary: I'm confused, but we'll get to that later. First, about your code: As far as I can tell, your code is supposed to prevent users from editing any cell ...
Summary: I have an excel document with many merged cells. I would like when it prints to automatically make the page breaks between non-merged cells. Right no...
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...
Summary: I need to count cells in an Excel spreadsheet (in a given column) by cell format. (i.e. by color). I believe this would be a variation of the counta(...
Summary: How do I format the cells, in Excel, to remove everything, but the APT in my below example. I have many different cells, in a single column, that are ...
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your...
Summary: Please i need some excel expert to help solve this spreadsheet. I'ved tried solving the problem but I'm not sure if i got it right so need some compar...
Summary: i am trying to use an array formula to select certain cases from an adjacent work sheet and comute percentiles. The problem I am having is that there ...
![[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
