I am writing a simple routine but am a novice at this. I want to 'go to'
various named cells and I always want the cell I go to, to be positioned at
目前分類:title (3013)
- Sep 29 Fri 2006 20:09
place a named cell in the top left corner of the worksheet
- Sep 29 Fri 2006 20:09
View Web Page
Hi,
- Sep 29 Fri 2006 20:09
deleting unused cells / getting rid of inactive cells
I have a workbook and its 34mb; too big. Problem is that while I only use
down to row 250 on most sheets, if I quot;Cntrl Endquot; the curser/active cell
- Sep 29 Fri 2006 20:09
Copying fomula down...
I have the following:
cell G1 = A2
- Sep 29 Fri 2006 20:09
Function to Convert dollar to text?
I am looking for a function to convert a dollar amount (number) to text. For
example, $10.50 would display as quot;Ten Dollarsquot;.
- Sep 29 Fri 2006 20:09
Strange Result using custom number format
I am trying to apply a custom number format that returns the following
results..
- Sep 29 Fri 2006 20:09
Keep Font original size
How do I keep the original size font on a spread sheet. I do not want excel
to shrink the size of the font to fit on one page.
- Sep 29 Fri 2006 20:09
IF formula help
Hi,
- Sep 29 Fri 2006 20:09
How can I lengthen the drop down Fonts list to show more fonts at
My drop down fonts menu only shows about 12 fonts at once and I would like to
make it much longer for easy viewing...
- Sep 29 Fri 2006 20:09
Help needed please..
I have created a holiday planner and nee help with a formula.
- Sep 29 Fri 2006 20:09
Update from TXT-file
- Sep 29 Fri 2006 20:09
Lines and borders are out of alignment with the cell contents
This occurs in some worksheets and not others. The alignment gets worse the
further down the page you go. If I copy and paste to a new worksheet, this
- Sep 29 Fri 2006 20:09
finding the second last date
- Sep 29 Fri 2006 20:09
Summarize employee attendance data on a weekly basis
I need to summarize employee attendance data based on a weekly basis. Right
now my spreadsheets are setup for a monthly basis. The spreadsheets have all
- Sep 29 Fri 2006 20:09
How do I show values of data points in a chart with the mouse poin
I have a 3D surface graph that I would like to show the values of the XYZ
data when I scroll the mouse pointer over that particular data point. Any
- Sep 29 Fri 2006 20:09
excel office V excel viewer, slight problem
- Sep 29 Fri 2006 20:09
Why is Computer Freezing With Excel?
- Sep 29 Fri 2006 20:09
Clear data in row
- Sep 29 Fri 2006 20:09
How to create menu for listed names?
In column A, I get a list of name, which name can be duplicated, such as
John, Mary, John, Peter, Amy, Mary, Amy, Peter
- Sep 29 Fri 2006 20:09
Counting how many different names in a long list