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 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: What version of Excel do you have? If you have 2003, there is a "Merge Cells Wizard" add in available. Or, you could use the "Concatenate" function. ...
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 am working with a spreadsheet on which there is a list of departments who are participating in a certain program. Several departments team up for t...
Summary: Hi, I have a couple of questions: 1. What steps are you doing to merge the Excel data into Word. If I have 4159.68000000003 in a cell in Excel, but ...
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: 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 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 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 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: Use the Excel Help File: Enter data in a cell from a list you specify You can create a dropdown list that gets its choices from cells elsewhere on t...
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: When entering an AlphaNumeric in COL A, I would like to check contents of all previous cells in COL A for IDENTICAL entry, and warn or prevent continu...