|
After using "= A1" how do you merge info from the 2 spreadsheets?
I am trying to take information already on one spreadsheet and incorporate
some of it into a second spreadsheet used for a different purpose. I have
done the
"in cell A1 of spreadsheet2 type =
then go to spreadsheet1 cell A1 and press return"
that put codes in the colums for me but now how do I get the information to
transfer/merge into the 2nd spreadsheet?
I am new at all ...
|
2 |
16.05.2006 19:09:54 |
|
|
Excel Add-ins setup
Hello
I have installed an Excel Add-in, and it works fine, but every time I close
Excel it dissapears and I have to install it every single time I open Excel.
does some one know what could be wrong?
--
thanks so much
Aggie...
|
4 |
16.05.2006 11:30:06 |
|
|
How do I display the "ampersand" in the header as text
How do I display the "ampersand" as text in the header of my Excel Spreedsheet?...
|
2 |
15.05.2006 15:01:58 |
|
|
How to set the default color for fill in functon?
Does anyone know how to set the default color for fill in function?
Everytime, Excel starts up, the default color for fill in function is
yellow, which is used to fill in the background for the specific cell. I
usually fill in grey color, if I can change the default color, it will help
me a lot.
Does anyone have any suggestion?
Thank you in advance
Eric...
|
4 |
15.05.2006 14:09:02 |
|
|
How to reappear the menu bar (file, edit etc) that disappeared?
I do not know how, but the menu bar (file, edit, view, etc) has disappeared
from my excel 2003. How can I make it reappera without reinstalling office?...
|
3 |
15.05.2006 11:12:01 |
|
|
archive worksheets in workbook
how can i archive worksheets within a workbook without starting a new workbook?
...
|
4 |
15.05.2006 01:07:41 |
|
|
Macros Shortcut keys
Users is on XP SP2 using office 2000 which was recently installed on her pc.
She previously used 2003 through terminal services and the macro shortcuts
ran fine. Now that she is using the 2000 on her local machine the shortcuts
no longer work. The macros run fine going in through the menu and hitting
run. If you go in and look at the macro you can see where the shortcut keys
are save...
|
2 |
14.05.2006 12:47:01 |
|
|
How to setup excel to use lotus note by default for email
Want to know if there is a way in excel that when you go to file, then send,
to send email as attachment that exel uses lotus note by default...
|
1 |
12.05.2006 19:24:01 |
|
|
Turn off automatic toolbar
I have one excel file that every time I open it, the reviewing toolbar
automatically opens. Every day I turn off the toolbar, go about my work, and
save the document. The next day, I open the file, and the reviewing toolbar
pops up. How can I turn this feature off? It's easy enough to turn it off
myself, but if I can stop it all together, I'd be much happier!...
|
2 |
12.05.2006 15:19:16 |
|
|
Using the chart wizard
I was wondering if there was a way in which I can get a chart to display the
actual values on the xaxis, rather than the default numbers. I have
highlighted what I want to appear in a chart, but when I preview it it just
displays the default numbers, not the values that I highlighted....
|
1 |
11.05.2006 18:54:03 |
|
|
How do I change the auto filter tabs from blue to red?
I use the auto filter and have trouble seeing what tabs are active because
the color blue looks the same as the color black and hard to quickly see. How
can I change this color of the tab to red?...
|
1 |
11.05.2006 12:11:01 |
|
|
create option to view worksheet tabs vertically
It would be great if Excel had the option of viewing tabs vertically. I have
a workbook with about 20 sheets and horizontal scrolling is cumbersome to
switch between worsheets.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not...
|
2 |
11.05.2006 10:49:41 |
|
|
Text Import Wizard
I am using the AS/400 function CPYTOIMPF file to download a tab
delimited file to a IFS folder. I want to open the document by double
clicking. One of the fields in the file I am downloading is a part
description. The field can contain several double quotes and if there
are an odd number it will cause problems. I can use the import wizard
and change the text qualifier to {none} on Step 2 of 3 ...
|
1 |
10.05.2006 21:22:30 |
|
|
the toolbar font box is unreadable. How do I change it?
I CAN'T READ THE TOOLBAR FONT. ON THE TOOLBAR NOT IN THE DOCUMENT AREA....
|
1 |
10.05.2006 18:17:02 |
|
|
Columns are numbers, rows letters. How do I change back?
In an excel spreadsheet, the columns are numbers and the rows are letters.
How do I change that back to normal ??...
|
2 |
10.05.2006 16:08:03 |
|
|
Columns are numbers, rows letters. How do I change back?
...
|
1 |
10.05.2006 12:57:01 |
|
|
Up & Down Arrows
In Excel 2003 when I press the up/down arrows on the Keyboard the whole page
is scrolling up and down instead of going through the cells moving. Any
ideas to stop it doing this and working how it should.
Thanks
Johnny
...
|
4 |
09.05.2006 19:08:13 |
|
|
Locking column width - upon refresh of PivotTable
Hello:
I have a PivotTable, which I use for a report. It contains a lot of data and
I'm trying to make it a bit bigger.
Each time I refresh, the column headings force the columns to widen-up
(where I previously wrapped the text to crunch the width of the column).
I'd hate to keep readjusting. Is there a way to set the width of the column
and row to a specific setting - permanently??...
|
1 |
08.05.2006 15:48:02 |
|
|
Lookup cannot be installed...
Hi!
I have Excel 2003 (Norwegian) and I'm trying to install the Add-in Lookup.
It tries to install, but during the process I get a error message:
Microsoft Excel can not run this add-in.
Function not availbale.
[ok]
I've tried this with the installation CD in my CD player, but that doesn't
help.
Any suggestions?
Best regards
Caspar M
...
|
1 |
08.05.2006 12:19:01 |
|
|
bringing G1 value from 50 sheets to another sheet. Indirect comman
I have 50 sheets called run1 ... run50
In G1 of each sheat I have a number (number of rows G4:Gn, in that sheet)
I want to bring the valuse of G1 from all 50 sheets to another sheet
(summary Shheet).
Is it possible to do it by "indirect" command to copy the (run3!G$1$)
reference cell? I couldn't succeed.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan...
|
6 |
06.05.2006 23:50:33 |
|
|
Move to next row??
Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and back
to column #1.
thanks,
L.
...
|
5 |
06.05.2006 02:47:38 |
|
|
sorting column headings
Can Column headings once typed in, be sorted alpha...
|
2 |
05.05.2006 20:40:02 |
|
|
In Excel up sides alphabets change into newmaric
when we started excel it have up to down numaric and at upper side left to
right its
alphabats but in my pc after some time all alphabats of upper side in
changed in to numaric.
please tell me what is the problam...
|
2 |
05.05.2006 17:38:02 |
|
|
look for a pipeID in a column and returns "broken" result
I have a column of pipeID (1400 IDs).
I have a column of Target pipes. (78pipe IDs)
I want a command to look Target pipes in pipeID and writes broken in front
of it if it finds in pipeID column and leave empty if it couldn't find. I
think I have to combine Hlookup and if command but I couldn't recognize how.
Will be happy if there is any help.
--
Rasoul Khoshravan Azar
Civil Engineer
O...
|
5 |
05.05.2006 08:55:18 |
|
|
HDI change paste options default to "Match Destination Formatting
...
|
1 |
04.05.2006 13:51:04 |