|
|
"Watermark" in Excel by
H Chan
In Word, I know how to do a watermark background.
How do I do this in Excel? For example, I would like to see the word
"Draft" as background text. Is...
|
|
1 |
198 |
|
|
Variable File Naming Using Macros by
Kris S
Is there a way to open a file and rename it using cells within the document
itself using a macro? (Variable File Name?)
Also, is there a way to open a file,...
|
|
1 |
145 |
|
|
Losing data when saving as a dBASE file by
JTM
Even though data (the cell in question is a zip field that I have formatted
to display the leading zero) is displayed in cells of my active worksheet,
when I...
|
August 21st, 2004 07:41 AM
by 43N79W
|
1 |
281 |
|
|
Multiple SQL Queries on one sheet by
Kevin
I am editing the last SQL query on a sheet that has 5 queries on it.
I am adding a column. Excel is insisting on shifting columns for the
queries above over,...
|
August 21st, 2004 03:03 AM
by Kevin
|
2 |
609 |
|
|
Matching values in 2 Columns by
Portuga
Hello,
In Column A I have a list of unique case Numbers. (around 3000)
A1 123456
A2 234567
A3 345678
In Colums B I have a list of unique case Numbers...
|
|
2 |
303 |
|
|
|
August 21st, 2004 02:31 AM
by Erin
|
1 |
308 |
|
|
|
|
1 |
174 |
|
|
Moving Columns to Rows by
David Patterson
Is there any easy way I can achieve the following without a very laborious
route of manually copying and pasting loads of data? I have a large
spreadsheet of...
|
|
7 |
259 |
|
|
Sortng Custom Views by
TONYC
I have been saving filtered criteria using 'custom views', icon on the
toolbar, however, as this list grows, I would like to sort the assigned
names in...
|
|
1 |
296 |
|
|
Retaining highlighting when focus changes by
Bill Sutton
I am using Excel 2003. I have a spreadsheet full of data
open; I find and select the cell or row containing the
data I need and that cell or row is...
|
|
1 |
265 |
|
|
|
August 20th, 2004 10:04 PM
by AlfD
|
3 |
386 |
|
|
Date problem by
Gerry
I have a column containing
4/21/2004
10/7/2003
5/5/2004
Which I need to convert to UK dates.
because of the variables(4/, 10/) I am unable to use mid
etc in...
|
|
3 |
158 |
|
|
|
|
4 |
375 |
|
|
Zipping Excel files by
Brian
If I zip up an Excel file of 7,115,716 bytes, the resulting zip file is
1,206,499 bytes, a reduction of 83%.
If I do the same with an Excel file of 25,063,936...
|
|
4 |
243 |
|
|
|
|
3 |
365 |
|
|
protect document by
Neil Greenough
How do I protect a document, so that when I email somebody an invoice for
example, they cannot change any of the information on it?
Also, I have a column of...
|
|
4 |
310 |
|
|
Hiding sheets based on user by
James
Is there a way to create conditional workbook and worksheet views based on
the value of a particular cell?
Below is what I'm trying to accomplish:
I'm...
|
|
3 |
343 |
|
|
|
August 20th, 2004 07:38 PM
by Biff
|
3 |
404 |
|
|
why is this happening, how do I fix it? by
KEL KEl
Everytime I enter "1996" in an excell cell, and it doesn't mater if there are
other characters around it ie. *1996* as soon as I tab out or "enter" the
1996...
|
August 20th, 2004 07:29 PM
by KEL KEl
|
2 |
230 |
|
|
|
August 20th, 2004 07:19 PM
by
|
3 |
364 |