|
|
data collection by
driller
Hi again,
thanks in advance..
In Sheet1 (A2 ~ A1000) i have a master list of names.
In 6 other sheets (with varying sheet name) i have a list of concatenated...
|
|
1 |
106 |
|
|
Copying cell formulas by
D.Robison
Excel 2003 ...
I have a cell formula for sheet 2 of an excel spreadsheet that is for row 1
"=Cu!A1+Cu!A2+Cu!B1+Cu!B2", where A1, A2, B1 & B2 are numbers from...
|
|
0 |
169 |
|
|
Formatting question by
Texas10
When linking to other workbooks, is there a way to link the formatting of a
cell with it?? For example, I have linked cells that are shaded on a sheet
in a...
|
October 13th, 2009 12:12 AM
by Texas10
|
3 |
162 |
|
|
|
|
1 |
141 |
|
|
Default version of Excel by
clr
Hi All........
I have several versions of Excel on my computer at work and each time I get
a new higher version number....it seems to automatically become...
|
October 12th, 2009 10:36 PM
by clr
|
6 |
186 |
|
|
Create a shortcut for repetitive text by
Deej Hernandez[_2_]
I have Office 2007 Home Edition running on a laptop with Vista Home Premium.
I run a football pool every season and would like to know if there is any way...
|
|
3 |
144 |
|
|
emailed spreadsheets requiring a password by
2007User
I'm a professor using the software from our campus agreement. 2007
spreadsheets are coming in as needing a password to open. Tried saving and
opeing from...
|
October 12th, 2009 09:25 PM
by Joel
|
1 |
154 |
|
|
|
October 12th, 2009 09:17 PM
by MJH
|
11 |
270 |
|
|
How to cut off characters in a text column by
abc[_9_]
Hello
In my Excel file there is a column with text data
where the data consist of lots of characters.
Only n characters in the column for each record
are...
|
|
3 |
120 |
|
|
Parameter Query by
Lee
I seem to be hitting a limit in the number of parameters Excel takes in
getting data. The query in MS Query does return records alright with four
parameters,...
|
October 12th, 2009 07:38 PM
by Lee
|
4 |
146 |
|
|
Excel 2007 and "owner files" by
Marc
Hi all,
I understand Excel 2007 now creates "owner files" (starting with ~$) for
xslx files and not for xls files. My problem is that it seems impossible to...
|
|
1 |
138 |
|
|
|
|
5 |
283 |
|
|
parameters by
DavidC
When I edit a query and insert parameters, I cannot save teh query because I
get the message: "Parameters are not allowed in queries that cannot be
displayed...
|
October 12th, 2009 06:48 PM
by Joel
|
3 |
142 |
|
|
|
|
2 |
120 |
|
|
2007 Excel and Dreamweaver Web pages by
jmsvbit
When I upload an Excel workbook to a site created with Dreamweaver, it loads
without problems. When I click the link to the workbook, Excel opens...
|
October 12th, 2009 06:00 PM
by jmsvbit
|
0 |
135 |
|
|
|
|
7 |
142 |
|
|
PIVOT - value defaults - for Excel 2007 by
mgville
FYI-
Excel 2007 users-
If you're like me and use pivots with tons of values that need calculations
other than the default, I found that you can change your...
|
October 12th, 2009 04:44 PM
by mgville
|
0 |
125 |
|
|
Can't re-size worksheet by
basils57
For some reason when I open one particular Excel workbook it opens at about 50% size and without the Excel logo to the left of the heading and without the...
|
|
2 |
237 |
|
|
Ghost in my VLOOKUP by
WildWill
Wow, I have setup a VLOOKUP to search through a tabel of 7 columns x about 15
rows, and to match a string of Alpha-Numeric values, e.g. "BXZ678GP" - but I
am...
|
|
1 |
118 |
|
|
Cannot save macro buttons in QAT by
OssieMac
When xl2007 was introduced, one could add buttons to the QAT to run macros
and save them with the workbook. Now when that is done, the buttons only
remain...
|
|
1 |
203 |