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: 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: When you have the cells selected that you want protected, select Protect Worksheet, a menu appears and the first item that is checked is to allow the ...
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, 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: 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: I have an invoice created in Excel 2000 that automatically fills in today's date when I create the invoice. However, everytime I open that invoice at ...
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: 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: As of yesterday, for some reason my tab and arrow keys don't work anymore in excel. When I use the arrow keys it navigates around the screen but the c...
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 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 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: Is it possible to have it so that Excel cells/rows/sheets can be edited only once on shared workbook ? That is, information can be entered, then th...
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(...
![[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
