I am trying to set up a spreadsheet so that in particular cells the option is
available to pick from a list or enter freeform text. I thought I had found
目前分類:title (4957)
- Oct 18 Sat 2008 20:46
Pick list or freeform text
- Oct 18 Sat 2008 20:46
Associating a Radio Button to a Value
I am having a problem tallying a series of radio buttons. I have created the
radio buttons on a form and need to tally the results on a summary sheet in
- Oct 18 Sat 2008 20:46
Currency formula/formatting problem
I need help with the table below:
- Oct 18 Sat 2008 20:46
pivot tables using two mdb data sources
I want to display pivot tables using some information from one mdb dabase,
and some info from another mdb database; but they are linked by a common
- Oct 18 Sat 2008 20:46
How do I open a workbook in a specific sheet
I want to open an excel- workbook and start directly in a specified sheet in
a workbook with 200 sheets. Is there a way to name the file so I know which
- Oct 18 Sat 2008 20:46
Adding columns w/new formulas BUT keeping subtotals
I have a spreadsheet with values with multiple columns and about 800 rows.
The columns contain a rather complex array of 50 totals, subtotals, and grand
- Oct 18 Sat 2008 20:46
Copy amp; Paste from Webpage with IE
When using IE, if I copy a certain table from a webpage then paste it into a
worksheet,
- Oct 18 Sat 2008 20:46
Using the highest 2 out of 3 values in a formula
- Oct 18 Sat 2008 20:46
I want any date 90 days or older from current date change color
I am trying to set up a worksheet for work. I would like to have some
conditional formatting. In the date worked column will be dates going back
- Oct 18 Sat 2008 20:46
date formats
I have a cell that works out how many days someone has worked in my company
for. However, I'm trying to change the format of that cell so rather than it
- Oct 18 Sat 2008 20:46
how to link worksheets
I have several woksheets in a workbook that have differing data - Words
letter and numbers. I would like to create a summary sheet. I have worked out
- Oct 18 Sat 2008 20:46
add a ruler to use on spreadsheets
add a tool where a ruler can be used to keep place on spreadsheets. The
highlighter is only ok until you have to go else where on the spreadsheet and
- Oct 18 Sat 2008 20:46
Finding unique data between 2 columns
I have a spread sheet as such:
- Oct 18 Sat 2008 20:46
prevent converting numbers with hyphens to dates
I have a csv file that includes a column that contains text in the format
1-2-14. These are not dates, they are text and must remain in that format. I
- Oct 18 Sat 2008 20:46
I want a mesage sent when a change is made to an excel file
I have created a spreadsheet in excel for keeping track of stock we hold.
When a customer request a call off from stock the customer contact will enter
- Oct 18 Sat 2008 20:46
Data Filters
I have a long list in my data filter in my Excel file, and I really need to
print it
- Oct 18 Sat 2008 20:46
Need keystrokes equivalent to dragging one column heading onto ano
I do in fact have one more question. In my PivotTable, as a last step to make
it a little easier on the eye, I normally drag one column head (Data) to the
- Oct 18 Sat 2008 20:46
sales journal and inventory management
I have a small service business with a parts inventory of approximately 180
items. A typical business day involves the sale of 3 or 4 inventory items
- Oct 18 Sat 2008 20:46
cannot get color in cells and words
I click on a cell and want to fill the cell with a color so I click on the
little paint bucket on the top right but it does not fill the cell with the