Summary: Select the cells that you want others to be able to edit. Click on Format...Cells...Protection tab. Uncheck the Locked box Click on Tools...Protection...
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, The simple answer is to use conditional formatting. Conditional formatting allows the cell pattern colour, font and font colour, and borders to b...
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: When you have a long value in one cell and the cell(s) to the right has no value, Excel displays the text overlapping the blank cells. You can set the...
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: 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 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: 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: 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: 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: Hello all, I want to know if there is a way to create a bulleted list in an excel cell. Also can you use tab stops in an excel cell. Thanks in advanc...
Summary: I have dat in ONE EXCEL SHEET. for data in cell AA1:AA12 I have created a combo box. Data1 1) English Songs 2) Hindi Songs 3) Poems Data2 there are th...
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: I m facing a problem and I am bounded to work in excel: Hope u all will help me after reading the following situation. Let me discuss it in detail: I ...
Summary: Is there any genius out there that can help me. Is there any way to set an active button with a macro assigned to it as a backgroung in excel. ( sorry...
Summary: I recently did a survey for a grad school project, and my results were rolled up in Excel. For questions where more than 1 answer could be given, the ...
Summary: Hi I'm not sure about other versions but in Excel 2000 the following works. Use arrows to move to the cell then press F2. It will place the cursor at ...
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: When I open a monthly report in excel 2000, make changes to various cells in various worksheets, then save the file to the same name.....then open the...
Summary: in excel xp, i have a list of items spanning 10 rows and 5 columns. the first column contains text, and i can sort by that column easily, however, i h...
Summary: You can write a formula (called "mySum" in my example) with Visual Basic in Excel: 1) Open the VBE by clicking Tools / Macros / Visual Basic Editor ...
Summary: On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a l...
Summary: ok... once again i need some help...darn vba got me again...this time what i am looking for is i track certian stats at work such as how long each emp...
![[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
