I have several columns in a spreadsheet where I would like to use a combo box for data entry into a cell.
I can make the combo box work if I limit the data into a single cell repeatidly, but not when I open a cell in the column and want to use the combo box for the data in that cell.
目前分類:title (3013)
- Aug 14 Mon 2006 20:08
Combo Boxes for data entry
- Aug 14 Mon 2006 20:08
When i highlight cells, I USED to get total in bottom rt corner?
Hello. When I hightlight some cells, I used to get a sum total in bottom
right hand corner. Now, after a change in computer and supposedly same
- Aug 14 Mon 2006 20:08
Breifcase
If I were to use breifcase to transmit spreadsheets from my PC to my laptop ,
and the spreadsheets contain both formulas and links to other spreadsheets.
- Aug 14 Mon 2006 20:08
Linking Files
I have a set of budget files, one which is a consolidation of all the
others, achieved through links.
- Aug 14 Mon 2006 20:08
Message Box
I have created a macro that gives me a message box when it is run.
Sub MyMacro()
- Aug 14 Mon 2006 20:08
picture displays text as webdings
cel 2002 (10.6501.6735) sp3
- Aug 14 Mon 2006 20:08
displaying letters as average instead of numbers
- Aug 14 Mon 2006 20:08
Excel for Blind persons use
Hi Everyone,
- Aug 14 Mon 2006 20:08
constant value in a chart
Hello,
How can I display a constant value as a line in a chart? For example, let's
- Aug 14 Mon 2006 20:08
Shared spreadsheet
Hi,
Can more than one person work in a shared spreadsheet, make changes and save
- Aug 14 Mon 2006 20:08
time sheet that takes out taxes
Anyone have a timesheet that you just plug in the hours and rate and it
deducts the federal withholding?
- Aug 14 Mon 2006 20:08
Template amp; Commercial
May I use template to make book cover, card and web design, and to sell it
commercially?
- Aug 14 Mon 2006 20:08
doubleclick
Hi All,
- Aug 14 Mon 2006 20:08
If..display quot;0quot;, if greater than... display actual
If value in cell a1 = 1 through 149, display quot;0quot; in a2
If vallue in cell a1 = 150 or greater, display actual value of a1, in cell a2
- Aug 14 Mon 2006 20:08
Change data in a single column from quot;last, firstquot; to quot;first lastquot;
I have a column of names that I want to export to a mail merge. It's a single
column with last name separated by comma followed by first name. How do I
- Aug 14 Mon 2006 20:08
how do i have beginning balance take away an amount auto total
I am doing an excell sheet and I am trying to have a beginning balance take
away of an amount to automatically reduce the total for each entry. How do I
- Aug 14 Mon 2006 20:08
Basic formula help
- Aug 14 Mon 2006 20:08
What Does -
I have a formula that looks as follows:
- Aug 14 Mon 2006 20:08
Dimension Update and Pivot table report
I have an Excel (03) Report file which uses Analysis Services (SP4) Cube.
Works fine still using AS 2000 not 2005.
- Aug 14 Mon 2006 20:08
In Excel, I want to convert Eastern time to pacific time
how do I format a cell to subtract 3 hours from another cell?