|
|
displaying comments by
tjtjjtjt
Is there a way to make Excel display a comment when a cell is selected (as opposed to moving the cursor over the cell)? And, is it possible to make the comment...
|
|
9 |
297 |
|
|
current time on excel by
pikapika13
Right now I am using =Now() to display the current time. However, this
isn't perfect bc it only gives the time when there was last activity on
the workbook. ...
|
|
3 |
411 |
|
|
Excel Edit - Copying problem! by
ttask
Looking for an idea of how to copy parts of a spreadsheet, ignoring
hidden cells.
I just want to paste exactly what I see!
Thanks in advance!
---
Message...
|
June 24th, 2004 01:04 PM
by Andy B
|
1 |
165 |
|
|
Data-Filter on Multiple Entries in Cell by
XLML
Hi, I am new to the board and using XL2002.
There are instances when I enter more than 1 entry in a cell. For
instance, cell A2 can have the 12 months of...
|
June 24th, 2004 01:38 PM
by XLML
|
2 |
174 |
|
|
access denied by
dlb
cannot open completed worksheet from folder that is in My
documents. Cannot do anything with it.
|
June 24th, 2004 01:55 PM
by dlb
|
0 |
175 |
|
|
Disabling Save Button by
Andrew
Is there a feature of Excel or a macro that I could write
to disable 'save' (both the icon and the drop down
option)?
|
|
1 |
619 |
|
|
how to completely remove hyperlink by
leasaac
I was keying in some information in excel and all of them begins with
http://www.... It kind of irritates me when I am always clicking onto
the information and...
|
|
2 |
410 |
|
|
Truly null value by
Mike D.
Hi. Is there a way to enter a TRULY null value in a
cell? I intend for the formula below to leave the cell
blank if the criteria is met. My problem is that...
|
|
1 |
156 |
|
|
Excel's Advanced Filter unreliable? by
EddyT
I've just come across something which is concerning me a little. I have
a large table of data, comparable to a list of customer orders. The
first column...
|
June 24th, 2004 03:34 PM
by AlfD
|
2 |
254 |
|
|
Freeze Column Width? by
Emma
Hi. I have a pivot table that combines data from many
workbooks. One column contains varying lengths of text,
so automatically resizes to much wider than...
|
June 24th, 2004 04:24 PM
by Andy B
|
5 |
218 |
|
|
formula reqd. by
Kirandeep Singh
Hi,
I am wanting to get a formula where if I type
1 - 99 I should get A
=100 or 199 I should get B
=200 or 299 I should get C
=300 or 399 I should get...
|
June 24th, 2004 04:43 PM
by JulieD
|
4 |
175 |
|
|
AccessLinks by
JimmyC
In Office XP I used the Access Links add in for Excel to export spreadsheet information into a database. I could not do this by importing into Access...
|
June 24th, 2004 04:58 PM
by JimmyC
|
0 |
155 |
|
|
|
|
0 |
528 |
|
|
|
|
4 |
189 |
|
|
AccessLinks in Excel 2003 by
JimmyC
Excel XP had an add-in "AccessLinks", which allowed the export of worksheet information to an Access table. This does not appear to be available in 2003.
Is...
|
June 24th, 2004 05:04 PM
by JimmyC
|
0 |
155 |
|
|
How to merge databases by
I have multiple databases in Excel with similar data that
I need to pull into one large database.
The only way I know to combine the information is cut...
|
|
1 |
204 |
|
|
Filter macro / code builder help? by
StargateFan
Does someone know of VBA code that will bring up a "find" type of
dialogue box that when the user types in the data, the data is
searched for and if found, the...
|
|
5 |
477 |
|
|
Naming ranges by
daniel bonallack
I have 30 sheets in a workbook, and I want cell V43 in
each worksheet to have the named range Page_Num.
If I had one sheet with this range name, then copied...
|
|
3 |
230 |
|
|
AutoFilter and Frequency Function by
Jack
I am trying to see if I can create a frequency function that will
change as I autofilter different criteria.
I have a file with over 15,000 rows returning...
|
June 24th, 2004 06:02 PM
by AlfD
|
1 |
266 |
|
|
HELP - Data Analysis by
Steve
I have created an questionnaire in Excel, where the
respondents fill in the amounts to questions and select
different options.
This questionniare is going to...
|
June 24th, 2004 06:27 PM
by Anson
|
1 |
138 |