|
|
Hiding graphics elements? by
Blue Max
How can we hide pre-selected groups of graphics elements with the touch of a
cell or control?
We have two distinct groups of rectangles with gradient fills. ...
|
|
3 |
766 |
|
|
deleted worksheet by
EXCEL 2003 NEWBY
By accident I deleted a ledger which was originated on Excel 2003. I don't
know what to do to retrieve it. HELP PLEASE
|
|
2 |
694 |
|
|
|
|
2 |
673 |
|
|
QuickBooks export to Excel by
SecurityGuy
Suddenly, my QuickBooks program no longer allows me to export to Excel.
Worked fine a week ago. I can log onto QB from every other pc in the office,
and...
|
|
1 |
646 |
|
|
Selection after enter by
Jeanette Caldwell
After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at...
|
April 30th, 2010 03:43 PM
by JLatham
|
4 |
797 |
|
|
Comparing, Matching, and Sum formula by
ma
Hello.
Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.
Column B has numbers
Please, provide me the formula IF:...
|
|
6 |
755 |
|
|
|
|
1 |
820 |
|
|
|
|
1 |
957 |
|
|
|
|
1 |
828 |
|
|
|
April 29th, 2010 08:18 PM
by ma
|
2 |
676 |
|
|
|
|
3 |
771 |
|
|
Sorting tables on protected worksheets by
Blue Max
How do we configure our worksheet so that we can turn protection ON, but
still enable the table filter buttons in order to sort columns in a table?
No matter...
|
|
4 |
866 |
|
|
Changing fonts with a formula by
Blue Max
Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?
It appears that conditional formats cannot...
|
|
4 |
828 |
|
|
converting line-delimited text into cells by
Wowbagger
I have a text file with approximately 1000 lines of data, each line is 100
chars or less.
The first 15 lines are column headers (some columns are unused),...
|
|
2 |
623 |
|
|
|
|
1 |
636 |
|
|
|
|
0 |
645 |
|
|
Tab referenced to a cell by
Charles Eaves[_3_]
I am using Excel 2007. I would like to use the content of a cell (A1) to
also be the name of my tab at the bottom of the sheet.
Example: In cell A1, it...
|
|
2 |
621 |
|
|
use current month in ad If satament by
gls858
I have a cell A1 with a drop down to select month. In another cell on
another sheet I want to compare the current month to the value in A1.
If (current month...
|
April 28th, 2010 10:09 PM
by gls858
|
3 |
685 |
|
|
|
April 28th, 2010 09:40 PM
by TimW
|
8 |
930 |
|
|
how to unrestrict access to a cell by
rayado
i have preset option to put on a cell .. and i need to put more options to
choose from .... its tell inme that is invalid .. how can i bypass that or
edit...
|
|
1 |
622 |