| Thread | Last Post | Replies |
|
| Execl2002: Editing via F2, cell in light blue, Enter inserts new line | 29 Sep 2007 16:44 GMT | 3 |
suddenly when I edit a cell via F2, the cell is highlighted in a color
like light blue. When I press Enter a new line is inserted, it's not
possible to end editing with Enter. Any hint?
Thanks and greetings
|
| Scheduling workbook | 29 Sep 2007 16:13 GMT | 3 |
I have been asked to help come up with a simple workbook to help with
scheduling my section at work. Here is what I got so far
Sheet One = Schedule
with the following columns
|
| More number pairs for which this bug occurs | 29 Sep 2007 15:53 GMT | 2 |
I have found around 12000 such number pairs were this bug occurs. Here
is a link to my blog where I have posted a few thousand.
http://pranjan.blogspot.com/2007/09/i-found-12000-recurrence-of-excel...
[blogspot.com]
|
| retricting web query results to number of characters... | 29 Sep 2007 15:49 GMT | 1 |
I have a web query that pulls a large string of data.
Is there any way that I can adjust my query to only pull the first 10
characters (left) of the table?
|
| How do I change button images to display text in Excel 2007? | 29 Sep 2007 01:20 GMT | 1 |
Older versions of Excel allow you to assign textual description to button as
well as icon pictures. How do you do this in Excel 2007 i.e. I have a macro
to format minus numbers as red and in brackets. I want the button image to
display (0.00) but Excel 2007 only allows (as far ...
|
| Save as | 29 Sep 2007 01:06 GMT | 1 |
I generated a file in Excel 1997 then worked on it on another computer that
Excel 2007. Now when I go to access the file in the 1997 version the
formulaes in the cells don't incorporate any changes I make.
|
| How get to end of document without scrolling? | 28 Sep 2007 23:54 GMT | 3 |
How get to end of document without scrolling quickly?
|
| Encryption software | 28 Sep 2007 23:04 GMT | 6 |
I am looking for software to encrypt (mainly excel) files. This is to keep
away prying eyes rather than international spies so it doesn't need to be
particularly strong. Something free / Open Source would be particularly
attractive.
|
| Toolbars to ribbon | 28 Sep 2007 22:57 GMT | 1 |
Is there a way, to convert toolbars to a ribbon?
 Signature
Thanks,
DRA
|
| Excel 2007 bug | 28 Sep 2007 22:28 GMT | 3 |
Interesting:
> =77.2*850 65620
> =77.1*850 100000
> =77.0*850 65450 |
| Control a variable from multiple cells | 28 Sep 2007 21:15 GMT | 7 |
I have an excel workbook with multiple worksheets. How do I create a
cell on each of the pages such that if I change it on any one sheet, I
will get that value in the cell I want on each individual worksheet?
If that's not clear, let's say on sheet 1 I want A1 to be tied to A2
|
| Automatic Text Color | 28 Sep 2007 21:09 GMT | 3 |
How can I change the automatic text color in Excel from black?
Excel V2002
|
| Copy and paste versus copy and insert copied cells | 28 Sep 2007 20:58 GMT | 1 |
What is the difference between these commands?
|
| 65536 | 28 Sep 2007 20:48 GMT | 9 |
Anyone notice that there are only 65536 (which is one higher than the
magic 65535) rows allowed in older versions of Excel? Mabe there's
some rogue GOTO statement in the row attributes section of the code...
|
| case select | 28 Sep 2007 20:41 GMT | 2 |
since 2007 the code doesn't work
Sub vakantie_check()
Dim datum As Date
datum = Range("datum_vandaag")
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread