I want to be able to protect large chunks of my workbook, so that the cells
can't be written over. However I do need to be able to allow some external
目前分類:title (3013)
- Sep 29 Fri 2006 20:09
Cell but not sheet protection
- Sep 29 Fri 2006 20:09
Excel and Word will not open saved files
I have scanned my computer and dealt with any viruses using MSN software and
, but when I attempt to open a seved spreadsheet or Word document my computer
- Sep 29 Fri 2006 20:09
making a cell zero out after calculation
Let’s say I have 3 columns.
I want to deduct from cell C1 when # is put in cell A1 and zero out A1 after
- Sep 29 Fri 2006 20:09
How do I recover a deleted spread sheet?
I deleted a spread sheet by mistake that I would like to recover.
- Sep 29 Fri 2006 20:09
How do I create a dynamic chart
I have a database on sheet quot;Dquot; with 1000 rows of data 79 columns wide.
- Sep 29 Fri 2006 20:09
formula in one cell or another
When the user enters a number in cell A1, I want cell B1 to divide that
number by 8. If A1 is blank then B1 should be blank.
- Sep 29 Fri 2006 20:09
no data echo in fields
I have two spreadsheets. On both, all of the sudden the data in the
spreadsheet cannot be seen. If I click on a cell box, the data is at the top.
- Sep 29 Fri 2006 20:09
unable to copy ss# format in excel
I imported an Access table into Excel. One column in the table is ss#. It was
not formatted in Access; just 9 numbers. In Excel, I need the hyphens. I
- Sep 29 Fri 2006 20:09
Running Add-In from VBA
How can you call an add-in from VBA? I've tried 'Application.Run' and the
name (with the .xla extention), but it says it can't find it. It is listed
- Sep 29 Fri 2006 20:09
Find which cell is linked to another workbook
I have a workbook (actually a few!) that contain links to other workbooks
that I know it shouldn't. I've tried using 'find' to locate the cells which
- Sep 29 Fri 2006 20:09
Insert some cells by keeping the title block as same
Looking for something special that can make my work easier.
I have an excel file with some Piping MTO typed in it. Now unfortunately
- Sep 29 Fri 2006 20:09
How do I set up XML on Data menue?
how do I set up XML on Data menue ?
- Sep 29 Fri 2006 20:09
MY ATTACHEMENTS WON'T OPEN
can't open my attachment it is an excel file type,excel spreadsheet file
,file extension is.xls, discription is a spreadsheet
- Sep 29 Fri 2006 20:09
count it
- Sep 29 Fri 2006 20:09
Time Display ?
Sorry if this is a crosspost. (Excel 2003)
- Sep 29 Fri 2006 20:09
Matrix to single column
I have an array of data with column headings and changeable row quot;item namesquot;
in the left most column. The intersecting matrix of data contains quantity
- Sep 29 Fri 2006 20:09
Where do I find MegaStat ?
In my Statistics textbook it shows how to create different analysis. For
this particular on e it says to download the MegaStat add-in for boxplot,
- Sep 29 Fri 2006 20:09
Excel Startup Problem
- Sep 29 Fri 2006 20:09
Dynamic source list to auto expand
Hi~
I have been hooked up with a very nice VLookup tool for my companies
- Sep 29 Fri 2006 20:09
VLOOKUP Formula
try this
:assume your employee no and amount in sheet1,In sheet 2 employee no.is in