|
|
|
|
1 |
659 |
|
|
MS Query in Excel by
Paul
I am new to SQL and using MS Query in Excel to extract
data from SQL Server.
The query retrives result from a number of tables and the
result is in the...
|
|
5 |
781 |
|
|
Book for Excel Beginner by
Cary Shultz
Looking for a book that will bring me up to speed in
about one month. I am a basic user of Excel and am going
to be in a Support function. Using Excel 2000...
|
|
6 |
444 |
|
|
Cell shading wont print?? Please help by
clindy528
Hi everyone,
I'm using Excel 2000 on Windows ME, and I'm having
trouble with cell shading. When I implement cell shading
it shows on the screen, however, it...
|
May 22nd, 2004 01:21 AM
by CLR
|
3 |
561 |
|
|
Importing by
reno
recd e-mail as a Word.doc with listing of 42 newspapers that from a mailing label template. I want to place this in a Excel workbook. Is it possible without...
|
May 22nd, 2004 01:47 AM
by CLR
|
2 |
355 |
|
|
Sequential Numbering by
John Calder
Hi
I use Excel 2000 with a Windows 2000 operating system.
I would like to have an excel file that when I open it up,
it generates a sequential number in cell...
|
May 22nd, 2004 01:51 PM
by Max
|
4 |
515 |
|
|
Rounding up & down by
cmlm
I have many pages in excel with hundreds of prices. I need a formula to
round the price up or down.
For example: R 1465.55 rounded up to R 1495.00
R 1419.26...
|
May 22nd, 2004 02:18 PM
by CLR
|
6 |
358 |
|
|
Sales spreadsheet with variable conditions by
C'est Possible
Wish to create a spreadsheet that will track the potential lost sales of accessories if Widgets sales goal is not met. Example: Goal is 30 % accessories. Sold...
|
May 22nd, 2004 02:59 PM
by CLR
|
1 |
664 |
|
|
Colouring cells automatically by
Del
Is there a way of making a cell change colour automatically when I type a
certain number in i.e. 1 = red, 2 = green, etc.etc.
|
|
7 |
448 |
|
|
|
|
11 |
969 |
|
|
|
|
1 |
783 |
|
|
Excel - How to mix columns by
GML
I need to mix some columns like this:
Suppose A1:A3 = 1,2,3 and B1:B3 = a,b,c
How can I get C1:C6 = 1,a,2,b,3,c ?
Is it possible just with formulae (no macro)...
|
|
6 |
371 |
|
|
First Excel and VBA by
Gazabou
On A spreadsheet, I would like A4 ( Dates Missed) will show all dates that were entered and A5 would sum the number of days missed from the dates in A4. Can...
|
|
5 |
371 |
|
|
Remove Text Box by
Greg Brown
Ok I put a text box in my spreadsheet, I can move it
around, I can change the content and I can change the
size of the box, but how do I remove it completely...
|
May 24th, 2004 02:20 AM
by CLR
|
2 |
339 |
|
|
share a workbook and limit some users by
kjgarch
I have a excel spread sheet I use to track property I have purchased and
sold. Due to how fast I buy and sell I need people in my office to
have access to...
|
May 24th, 2004 06:54 PM
by Trevor
|
2 |
454 |
|
|
Advanced Filter Case Sensitive by
Joseph S Johnson
Hi, Is there any way to make an advanced filter case
sensitive? For example, I want to type DOG in the criteria
range and run the filter and only pull records...
|
|
4 |
390 |
|
|
Excel Text Box Controls by
Ron Green
Is there any way to allow a user of a spreadsheet to cut and paste text in and out of an Excel Text Box? Is there a setting that I am missing? Also, the...
|
|
4 |
306 |
|
|
Multiple Document Windows by
jerry
I'm a new user to Excel 2000. Unlike Excel 97, 2000 generates a new window every time a new document is open. Is there a macro, as I discovered for Word,...
|
|
4 |
656 |
|
|
macro disabled by
Mo. bannayan
Hi there;
well I got a file from a friend which contains a macro, but when I open it a
message pop in as the macro is disabled and I should change the...
|
|
2 |
303 |
|
|
How to do header row? by
Marianne
How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at...
|
|
3 |
393 |