PS/1 - Microsoft Works spreadsheet questions and answers

4.882 bytes

Service Hints & Tips

Document ID: MCGN-3G2MUH

PS/1 - Microsoft Works spreadsheet questions and answers

Applicable to: United States

Question:
When I type a person's name in a cell or field, why does Works automatically change it to the name of a month?

Answer:
If you type data that resembles the name of a month into a cell or field, Works assumes that it is the name of a month and modifies the data accordingly. This can happen with some people's names. For example, Works may abbreviate the names April, March, and June to Apr, Mar, and Jun. Names like Marc and Jan may be automatically expanded to March and January.

To increase its speed and ease of use, Works is programmed to make some assumptions. Sometimes its assumptions may be incorrect. To avoid this problem, enter the names as text, by starting each entry with a quotation mark.

Question:
When I print my spreadsheet, only some cells print, or nothing prints at all. Why?

Answer:
To troubleshoot printing problems in a spreadsheet, check the following areas:

Is the print area set correctly? If only a few cells are set as the print area, only some cells will print.
Are columns and rows hidden? If so, they will not print.
Does the document display correctly in print preview?
Are you using the correct printer driver, and is it set up correctly? Can you print correctly from other Windows applications? If not, you will probably not be able to print from Works.

Question:
I'm still a bit confused about print areas. How do I reset the print area in the Works Spreadsheet?

Answer:
To reset the print area in Works 2.0 use the following two-step procedure:

1. From the Select menu, choose All.

2. From the File menu, choose Set Print Area.

NOTE: If you reset the print area in Works 2.0a, Works warns you that the print area is being changed. Works 2.0 does not.

Question:
How do I un-hide rows and columns in the Works 2.0 Spreadsheet?

Answer:
Use this three step procedure:

1. From the Select menu, choose ALL.

2. From the Format menu, choose Column Width.

3. In the Column Width dialogue box either accept the default column width of 10, or greater than zero. Chose OK.

Question:
How many fonts can I have in my spreadsheet?

Answer:
Works 2.0 will only allow you to use one font in your spreadsheet.

Search Keywords

Hint Category

Productivity Software

Date Created

11-04-97

Last Updated

25-03-99

Revision Date

25-03-2000

Brand

IBM Aptiva

Product Family

PS/1

Machine Type

2011, 2144, 2168, 2121, 2123, 2133, 2155

Model

C01; C34; M01; NEA; T35; U35; A62; A82; A94; B82; C42; C92; G42; M82; S92; 081; 087; 131; 137; K37; N31; N81; 11E; 13T; 14C; 16E; 17A; 18A; 18T; 19C; 21C; 23C; 28A; 46M; 51D; D50; G11; G13; G43; G46; G46; G49; G49; G50; G53; M40; M40; M46; M46; P11; P13; P43; P50; P53; R04; R05; R06; R09; R38; R42; R43; R44; R84; R86; R87; RO3; S11; S13; S43; S45; S45; S47; S47; S48; S48; S50; S53; W11; W13; W42; W42; W43; W45; W45; W50; W53; 20E; 22T; 24C; 24M; 28V; 39E; 41T; 43C; 45V; 48E; 50T; 52C; 55V; 72E; 74T; 76C; 78C; 79C; 81A; 82E; 84T; 86C; 87C; CC1; D53; G14; G44; G52; G54; G72; G76; G78; G82; NM1; P14; P44; P57; P71; P74; P76; P78; P84; R14; R15; R16; R17; R18; R51; R52; R57; R58; R62; R63; R67; R71; R89; R93; R96; R97; S14; S44; S50; S54; S70; S75; S76; S78; S80; W14; W44; W48; W54; W67; W76; W77; W78; Z33; 28V; 31E; 33T; 37C; 38C; 51E; 54T; 56C; 57C; 88V; BB1; G57; G87; OR1; OR3; OR4; OR5; P89; R28; R29; R31; R74; R78; R82; R98; S55; S85; SR1; US1; W52; W82

TypeModel

2011C01

Retain Tip (if applicable)

Reverse Doclinks
and Admin Purposes

	Search Keywords
	Hint Category	Productivity Software
	Date Created	11-04-97
	Last Updated	25-03-99
	Revision Date	25-03-2000
	Brand	IBM Aptiva
	Product Family	PS/1
	Machine Type	2011, 2144, 2168, 2121, 2123, 2133, 2155
	Model	C01; C34; M01; NEA; T35; U35; A62; A82; A94; B82; C42; C92; G42; M82; S92; 081; 087; 131; 137; K37; N31; N81; 11E; 13T; 14C; 16E; 17A; 18A; 18T; 19C; 21C; 23C; 28A; 46M; 51D; D50; G11; G13; G43; G46; G46; G49; G49; G50; G53; M40; M40; M46; M46; P11; P13; P43; P50; P53; R04; R05; R06; R09; R38; R42; R43; R44; R84; R86; R87; RO3; S11; S13; S43; S45; S45; S47; S47; S48; S48; S50; S53; W11; W13; W42; W42; W43; W45; W45; W50; W53; 20E; 22T; 24C; 24M; 28V; 39E; 41T; 43C; 45V; 48E; 50T; 52C; 55V; 72E; 74T; 76C; 78C; 79C; 81A; 82E; 84T; 86C; 87C; CC1; D53; G14; G44; G52; G54; G72; G76; G78; G82; NM1; P14; P44; P57; P71; P74; P76; P78; P84; R14; R15; R16; R17; R18; R51; R52; R57; R58; R62; R63; R67; R71; R89; R93; R96; R97; S14; S44; S50; S54; S70; S75; S76; S78; S80; W14; W44; W48; W54; W67; W76; W77; W78; Z33; 28V; 31E; 33T; 37C; 38C; 51E; 54T; 56C; 57C; 88V; BB1; G57; G87; OR1; OR3; OR4; OR5; P89; R28; R29; R31; R74; R78; R82; R98; S55; S85; SR1; US1; W52; W82
	TypeModel	2011C01
	Retain Tip (if applicable)
	Reverse Doclinks and Admin Purposes