Pages

Search

Microsoft Works - preprinted invitations

Microsoft Works - preprinted invitations

preprinted invitations

Posted: 20 Mar 2005 10:39 AM PST

The invitations are folded. Opened they are 5.25" by about 7.5"

"Michael Santovec" wrote:
 

Spreadsheet Problem for Works

Posted: 20 Mar 2005 07:49 AM PST

Thank you but I am looking for a way to do it without any formula changes
after the initial setup. I just want to insert a new row or rows and the
total will adjust itself.
Example with 5 item running average,

item1
item2
item3
....
item10

average of 1-10
average of 6-10

Now I add item 11

item1
item2
item3
....
item10
item11

average of 1-11
average of 7-11

What I need is a way to dynamically change the range using a formula.

"Kevin James - MSMVP Works" <org> wrote in message
news:O1$phx.gbl... 

Help Required

Posted: 19 Mar 2005 06:19 AM PST

Hi Andy,

Perhaps,

Install WORD word processor separately, then Activate it.

1. Click Start, click Control Panel, and then click Add or Remove Programs.
2. Select Works Suite 2005 from the Currently installed programs list.

You may then select to "CHANGE or REMOVE" the installation.

Choose CHANGE.

Proceed to install WORD and the WORD in Works Add-In.

To re/install the Word in Works Suite Add-in:

1. Place the Works Suite Disc 1 CD-ROM into the CD-ROM drive.
2. Double-click the My Computer icon on the desktop.
3. Right-click the CD-ROM drive icon, and then click Explore.
4. In the left pane, double-click the WordAdd folder.
5. In the right pane, double click Setup.exe.
6. Follow the instructions on the screen to reinstall the Word in Works
Suite Add-in.

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2005
Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Macca" <microsoft.com> wrote in message
news:com...
| Yes it's the works suite version I have.
|
| Andy
|
| "Kevin James - MSMVP Works" wrote:
|
| > Hi Macca,
| >
| > Works 8 does not include the Word word processor.
| >
| > However, the Suite versions of Works do.
| >
http://www.microsoft.com/products/works/choose.aspx?comparison=Works8vsWorksSuite2005
| >
| > HTH,
| > --
| > Kevin James.
| > Tua'r Goleuni
| > Microsoft MVP (Works) 1999-2005
| > Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
| >
| >
| >
| >
| >
| > "Macca" <microsoft.com> wrote in message
| > news:com...
| > | have just purchased works 8 and have just installed it but it won't
install
| > | Word. It gives no reason just tells me it has no been installed but
| > | everything else has. Any ideas why this is happeneing?
| >
| >
| >

Works ver.6 Calendar

Posted: 17 Mar 2005 12:59 AM PST

Thanks Ken,



"Ken" wrote:
 

Works 2004 at Home - Excel at Work

Posted: 16 Mar 2005 10:53 AM PST

1-2-3 refers to the old Lotus 1-2-3 spreadsheet program.


--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.


"MrCordes" <microsoft.com> wrote in
message news:Od$phx.gbl...
|I saw the WKS file format options in Excel, but wasn't sure
what the (1-2-3)
| meant. I'll tell him to try the WKS's if he runs in to
problems, and know
| that CSV is always a safe last resort. But it sounds like
you think there
| shouldn't be a problem in the first place, I'll wait to
see if he has any
| before I get him worried. Thanks!
|
|
| "Jim Macklin" <p51mustang[threeX12]@xxxhotmail.calm> wrote
in message
| news:phx.gbl...
| > Excel can open or save as various wks file formats. You
can
| > always use CSV format.
| >
| > WORKS and Excel should be able to open and save files,
but
| > you need to open the program first and use the file/open
| > menu to select and open the file.
| >
| >
| > --
| > The people think the Constitution protects their rights;
| > But government sees it as an obstacle to be overcome.
| >
| >
| > "MrCordes" <com> wrote in message
| > news:phx.gbl...
| > | My brother just ordered a copy of Works Suite 2004.
He
| > ocasionaly uses
| > | Excel at work for very basic spreadsheets.
| > |
| > | Does anyone know if the spreadsheet portion Works 7.0
| > allows him to easily
| > | save his spreadsheets in a format that Excel will be
able
| > to open (without
| > | having to install any converters in Excel - company
| > security policy doesn't
| > | allow it)?
| > |
| > | On the same note, should Works 7.0 be able to open a
| > simple Excel 2003
| > | document that is saved with default settings? If not,
is
| > there a converter
| > | for Works 7 that he can download, or a special format
he
| > should save with in
| > | Excel?
| > |
| > |
| >
| >
|
|

Resetting Standard Letter Format

Posted: 16 Mar 2005 10:25 AM PST

Glad to help. BTW, the F1 key will open a context sensitive
help. If you're doing something and need help, just press
F1.


--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.


"DAVDOR" <microsoft.com> wrote in message
news:com...
| Thanx, it worked. Sorry for all these dumb questions from
a former Mac user
|
| "Jim Macklin" wrote:
|
| > Create a letter with page setup for margins, fonts, etc
just
| > the way you want it. You can have just dummy entries
| > (perhaps instructions) to over-write. When it looks the
way
| > you want it, use the Save As command and select template
as
| > the file type.
| >
| >
| > --
| > The people think the Constitution protects their rights;
| > But government sees it as an obstacle to be overcome.
| >
| >
| > "DAVDOR" <microsoft.com> wrote in
message
| >
news:com...
| > | Is there a way I can reset the standard format, font
and
| > page set up for all
| > | letters. Each time I generate a new letter I must
reset it
| > to what I want. I
| > | want a spacing and font of my choosing that will be my
| > Works standard. I find
| > | no instructions for this.
| >
| >
| >

Documents

Posted: 15 Mar 2005 06:11 AM PST


I would not agree with the previous response.
(pasting into Database first ?)

Just try pasting the document direct to MSWord

Then navigate to Tools / Sort

you will have the option to sort via paragraphs or list.

Sort, then paste back to MSWorks.


HTH




"Toffeehead" <microsoft.com> wrote in message
news:com...
| I am writing to ask how I go about sorting items in order, ( alphabetical ),
| for example in a document.

OT: Small town...Big Name

Posted: 14 Mar 2005 10:02 PM PST

And I thought
Taumatawhakatangihangakoauauotamateaturipukakapima ungahoronukupokaiwhenuakitanatahu
was long. Place name in New Zealand at 84 letters which means ''place where
Tamatea, the man with the big knees, who slid, climbed and swallowed
mountains, known as land-eater, played his flute to his loved one'.

This name is usually shortened to Taumata.

Allan

"Paul" <freeserve.co.uk> wrote in message
news:com... 

fomulas

Posted: 14 Mar 2005 07:11 PM PST

...from a message in 2000


an explanation.


Works manuals etc here at ( www.cnet.com select TechHelp)
or directly ;


List of Works Books (10).
http://www.help.com/cat/2/69/1*41/152/153/hc/3.html?tag=st.hp*.hc.ont.hc


On-Line Assistance for Works
http://www.help.com/cat/2/69/1*41/152/153/hc/8.html?tag=st.hp*.hc.filte...


Here's assistance on How To do most things in Works, strongly biased
towards the Works Processor and Works Spreadsheet.
http://www.pcshowandtell.com/


There are also tutorials available for downloading.


HTH,
---
Kevin James
Tua'r Goleuni
Millennium MVP - MS Works

Column to keep running total

Posted: 13 Mar 2005 10:25 AM PST

Put your "Total" cell further down the page
allowing say 20-30 blank rows
Fill the total column down as advised

When you add an entry it will auto fill.







| > Hi Jeffc,
| > In cell B2, adjacent to A2= -50, enter the formula = B1+A2
| > Copy this formula / fill down for the B column, so that
| > B3 = B2 + A3
| > B4 = B3 + A4 etc..
|
| Thanks Kevin. But if I have to do that every time I add an entry in column
| A, what's the point? It's easier to just do the addition myself.
|
|

VLookup

Posted: 12 Mar 2005 04:25 PM PST

Thanks Kevin,
I'll print out your response and work through it.

I have been using Excel 97, but because of the problem
exchanging data between works and excel, thought I would try
to stay in works.

The formula works fine in excel (with a few nomenclature changes)

When pasting data from DB to SS in works
there is no option to paste as "Text" as in excel.

The only option one has is "paste as values" exactly what I do <not> want :(

Thanks for your extended reply




"Kevin James - MSMVP Works" <org> wrote in message news:phx.gbl...
| Hi Rodney,
|
| I'll try and capture the essence, but don't quote me. :-)
|
| VLOOKUP and HLOOKUP operate best with (ascendingly)
| ordered lists.
|
| Your formula (algorithm) operates in the following manner:
|
| VLOOKUP value of AB503 in list, range P2 : P300
| IF the first value in the list is greater than value of AB503
| THEN result = 0 (irrespective of other values in list)
| OTHERWISE result = value of 'successful' lookup
| ( successful does not necessitate a matched value for AB503 )
|
| Particularly,
|
| 1. If the first value in the list is greater than AB503 then ERR results
| (irrespespective of further values in colum P )
| This gives ISERR(lookup) is true
| and from IF(ISERR(lookup) is true,0,...)
| we get 0 in the result cell.
|
| 2. IF AB503 value is in (asc.) ordered list THEN result = (offset value)
|
| 3. IF AB503 value is not in (asc.) ordered list AND a/all values
| in the list are less than the value of AB503 THEN result = offset
| value of number less than AND closest to the value of AB503
| (i.e. always the last value in the list).
|
| Further, and why I said "operate best with (ascendingly) ordered list" ;-)
|
| 4. IF the list is unordered, AND the value of AB503 is not in the list
| AND the first value is not greater than AB503 then the result is the
| offset value for the first of the two adjacent numbers whose values
| "intersect" the lookup value ( i.e. always the lower number ).
|
| 5. IF the list is unordered, AND the value of AB503 is in the list
| AND the first value is not greater than AB503 BUT two values before
| the AB503 value "intersect" the value of AB503, then the result is the
| offset value for the lower number).
|
| 6. IF the list is unordered, AND the value of AB503 is in the list
| AND all column P values preceding the matching value are less than
| AB503, (whether ordered or not) then the result is the offset value for
| the matched number AB503 ).
|
| Perhaps, suspect that No.4 above applies in your case.
|
| HTH,
| --
| Kevin James.
| Tua'r Goleuni
| Microsoft MVP (Works) 1999-2005
| Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
|
|
| "Rodney" <com.au> wrote in message
| news:u$phx.gbl...
| |
| | I have this formula in a cell
| |
| | =IF(ISERR(VLOOKUP(AB503,$P$2:$R$300,1)),0,(VLOOKUP (AB503,$P$2:$R$300,1)))
| |
| | In the lookup range (column P) , 15 does not appear.
| | I put 15 in the cell AB503 yet the result cell reads 1 and not zero
| | in fact <all> the cell read 1
| |
| | why is this happening pleae?
| |
| |
| |
| |
|
|
|
|
|