Search:

Hi Rick:

Welcome to the lounge.

I understand that an .xlr extension indicates a Microsoft Works file. You could try changing the extension to .xls

Failing that, I think Open Office can open...

Catherine:

Many thanks!

It was changing the X-Axis from a Date Axis to a Text Axis that has done the trick - the gaps in the chart have now disappeared.

I thought I knew Excel pretty well,...

Thanks Steve. I am obviously being totally thick, so I have attached the file - 2007 version!

. . . and I used to get on so well with the earlier versions of Excel . . .


and now I can't get...

Thanks for your prompt response, Rory. However (from memory) your instructions apply to 2003, which unfortunately I no longer have, it having been mysteriously deleted from my laptop when I installed...

Hi Christine:

FWIW, since you want grey, you will always get a shade of grey if the RGB values are all the same,

Hi All:

In Col A I have a series of dates, in Col B the score for each date and in Col C the average score so far. The dates are not consecutive!

So far, so good. However, when I come to Chart...

Can I add my thanks too - somewhat belatedly, as I was unaware of replies; my email notifications do not appear to be working.

I actually returned to this thread to say I had found an option in...

When selecting a time-scale in the 'Show Threads from' drop-down, there seems to be no way of saving the option chosen. Every time, it reverts back to '30 days'.

Changed the 'Show threads from...' option to 'The Beginning' and it came up with one thread from March 2009; so I guess 'from the beginning' means from the beginning of the old new lounge and...

Thanks, Hans - at least I'm not as stupid as I thought I was (maybe!).
On another 'New Lounge' topic, I noticed on my profile that my 'watched' and 'Reminder' lists of previous posts/threads have...

The Lounge Help states:
The calendar can be used to post events for other members of the community to see. It also lists each member's birthday.
To access it, click the "Calendar" tab at the top...

An alternative (doing away with the need to apply conditional formatting to each relevant cell) is to change the setting for the whole sheet to not show zero values.

Click the Office Button/Excel...

Hi Gary:

<<It looks like they've taken that option away >>

Not what I was hoping for, but not unexpected either!

Thanks for the response.

Tony

Hi:

In earlier versions of Word, I reversed the order of pages when printing, to avoid the necessity of shuffing the pages, because the paper comes out of my printer 'face up'.

Having recently...

Select the data range:
Edit - Goto - [Special]
Select "Blanks"
[OK]

Now the blank cells will be selected. In the active cell, enter an equal sign(=) and then select the cell above it, putting...

Hi all:

I've seen this before here some time ago, but for the life of me I can't find it through search. I have several thousand rows of the type:

NAME DEPT AREA OPTION
Fred // Dept...

I have some data validation set to allow from list. There are only 4 items in the list and I would like to populate each item by typing the first letter, but this does not happen. Is there a setting...

Hans:

Thanks for that. It provided a solution that had been escaping me for a while!

First, you should make sure you've got Windows Installer 4.5 installed. Get it from:Download details: Windows Installer 4.5. Make sure you download the version for your system. Windows Vista is...

You probably have to install this with administrative privileges. Locate the installation file that you have saved in Windows Explorer, RIGHT click on the file, and select "Run as administrator"....

Hi:

I have recently purchased a new laptop, with Vista Home preinstslled. I have tried to install Open Office, but it only goes as far as the enclosed message then stops (screenshot attached).
...

Thanks for the link, Stuart.

It gives me something to point to, next time someone asks me the question - even if I don't understand it myself!

Thanks Steve (I think <img src=/S/confused.gif border=0 alt=confused width=15 height=20> )

Hans:
<hr>In VBA, True = -1

<hr> As a matter of interest, why is that used in preference to 1 ?

Hi Hans:

Unfortunately, the w/b design has to match design considerations elsewhere (CAD, I think - it's not my w/http://windowssecrets.com/forums/images/smilies/cool.gif.

I'll play with the...