iWork is Apple's suite of productivity software for the mac as well as iOS. iWork includes "Pages" for word processing, "Keynote" for presentations, and "Numbers" for spreadsheets.

learn more… | top users | synonyms

1
vote
1answer
9k views

How to get iWork and iLife after upgrading to Yosemite from Mavericks?

I bought a mid-2014 MBP Retina (activated on 30/09/2014) from a friend and did a re-installation of Mavericks, then upgraded to Yosemite right after the re-installation (without associating the mac to ...
3
votes
2answers
41 views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at ...
0
votes
0answers
10 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
1
vote
1answer
29 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
0
votes
2answers
319 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a ...
3
votes
2answers
281 views

Pages 5.1 underlines some words as misspelled, but does not allow me to “Ignore/Learn Spelling”

I am using Pages 5.1. When I misspell words, spellchecker underlines them in red. I am usually able to either "Ignore Spelling" or "Learn Spelling" when I right-click the word: But for some words, ...
3
votes
3answers
8k views

'Show Package Contents' in new iWork (Yosemite) File Formats

After installing both Yosemite and the new iWork suite updates (Pages 5.5 and Keynote 6.5), I've noticed I can't 'Show Package Contents' in order to access/modify the media associated with these ...
0
votes
3answers
4k views

iWorks no longer free after fresh install of El Capitan

I just installed a fresh copy of El Capitan on my MacBook Pro Retina (2013 model), and iWorks are no longer free in the App Store, as has been the case in Yosemite. See the screenshot: What are the ...
0
votes
1answer
60 views

How does one use different languages in Pages headers and footers?

[EDIT] I'm afraid this language feature is gone in Pages 5.* How does one use different languages in Pages headers and footers? I don't need spell checking but language switching (for headers and ...
2
votes
2answers
4k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
0
votes
1answer
55 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
0
votes
1answer
29 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
0
votes
0answers
53 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
3
votes
2answers
819 views

Why are Pages/Numbers/Keynote not free in the App Store on new iPhone 6s?

I got a new iPhone in the US, but am using it abroad (Israel) and with my old Apple ID. In the App Store I see the Apple Pages/Numbers/Keynote with a price tag on them (not free) when they should be ...
2
votes
1answer
291 views

Why is the Page Number menu item greyed out in Pages '09?

I want to insert a page number in my iWork document. I clicked on Insert and the Page Number title is grayed out. How can I get the page number feature to activate? I used to insert it in other ...
1
vote
1answer
138 views

iWork and iLife are not free after reinstall

I recently bought a Macbook Pro 13" Early-2015 from a guy who used it only once and then reinstalled it for selling (already upgraded to the latest El-Capitan). After I set up my Apple ID I couldn't ...
1
vote
1answer
18 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") Hey guys im basically trying to generate a if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 for over 90. I have been trying ...
0
votes
0answers
20 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...
2
votes
3answers
2k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
2
votes
4answers
40k views

How do I convert a pages document to a word document without access to pages?

Suppose I didn't have access to a Mac with pages. How can I convert a pages document to a word document using only a windows environment? Is there a freeware converter available?
1
vote
0answers
19 views

In Numbers.app, Is there any function to identify if another cell is a formula, or contains a specific function?

I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was ...
4
votes
3answers
4k views

iWork '09 Keeps asking to be Registered

I'm a teacher in a classroom with 8, 9 10 and 11 year olds who each have a macbook or a macbook pro. Fun job. We have a standard 10.6.6 image with iWork '09 (4.03). In previous images, iWork would ...
1
vote
2answers
86 views

How to correctly uninstall an App Store application [duplicate]

Recently I installed Pages which I purchased with version of iWork '09. Unfortunately this operation downloaded and installed version Pages 5.5.3 which is not exactly an upgrade of Pages '09. ...
4
votes
1answer
9k views

New version of Keynote won't open old versions

When using a newer version of iWork software such as on Yosemite to open older documents and presentations, Pages reports "This document can’t be opened because it’s too old. To open it, save it with ...
1
vote
2answers
5k views

How can I save a document from Pages in RTF format?

I only found descriptions were you use the export function of Pages. But there is no RTF option anymore. So is it possible to export a Pages file to RTF?
1
vote
1answer
24 views

Pages: line break appears before end of line

For some very strange reason, I cannot seem to fit the text on line 2 inside the empty space of the 1st line. I tried deleting the words and re-writing them, which didn't work. I tried changing font ...
1
vote
1answer
530 views

Which animations will work on Keynote export to PowerPoint?

I have a Keynote (iWork 9) presentation and need to export it as PowerPoint. When doing it using File : Export : PPT the slides work properly, but most of the animations are broken. Is there a ...
0
votes
1answer
46 views

In Numbers, how can I sum only if adjacent cell is certain value? [duplicate]

In excel, as shown here, it is possible to find and sum only cells with have a specific value next to them. Is there a way to do a similar thing in numbers? Specifically, I have a very long table ...
1
vote
1answer
245 views

Pages 4.3 on Mavericks - data loss with filenames beginning with tilde (~)

I had a client report the sudden loss of files after upgrading to Mavericks. It wasn’t difficult to duplicate the problem, on both her Mac and mine. I’m wondering if someone may have seen this ...
0
votes
0answers
2k views

Can I split a cell in a table in the newest version of pages?

I want to split a cell in the newest version of pages. This was very easy in the previous version but now I can't seem to do it. Any help is appreciated.
0
votes
1answer
53 views

Get pages and iMovies free

I got macbook pro late 2013 and normally Pages and iMovies they are free for mac after 2013 but when I got to app store I can't get them for free. Any help here or how to get them free ?
0
votes
1answer
82 views

Link tables for auto new rows - Numbers

Is there a way I can "link" tables in Numbers so that when rows are added to the "master" table that the identical rows and containing data are added in a linked table? I know I can "link" cells using ...
3
votes
1answer
586 views

Where are iWork templates saved?

I'm using iWork (specifically Pages 5.5.3) and I can't find the templates I created for this anywhere on the HD. Library > Application Support > iWork > Pages > Templates > My Templates Only shows ...
0
votes
1answer
12 views

Apple software - Numbers [closed]

How do I identify and add(sum) only specific cells in a row - they are not continuous cells. Ex. I1, O1, U1 total sum and show in BG1
0
votes
1answer
162 views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
1answer
156 views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total ...
2
votes
1answer
142 views

How to change chart colors in Pages 5?

I cannot change the individual colors in my charts. Under "Chart Colors" there is only this list of 12 predefined color swatches called "fill sets". Most of them are ugly. Not being able to change ...
2
votes
2answers
120 views

Launch an older version of an application by default?

There are two sets of applications where I'm running into this issue: iWork, where I only have the new stuff installed because Software Update harasses you to install the new stuff if it detects you ...
3
votes
4answers
4k views

Remove header columns in Page 5.0

In the new iWork Pages, there is by default 3 cells or columns in the header and I cannot remove the column back to its original one column header just like the normal header in Pages 09'. If you see ...
0
votes
1answer
116 views

How can I create a live updating slideshow?

I have a need to create a short slideshow style presentation (doesn't have to be a slideshow particularly if something else is more appropriate) which updates it's contents on the fly. The content is ...
0
votes
0answers
69 views

Apple Numbers … SUM all rows below cell (But NOT the summary row) dynamically

I have the following formula: =SUM(B4:B12) The cell this is in is B3. It works fine with the formula above. The problem happens when I add a row after B12. Then I have to readjust formula. to ...
3
votes
1answer
55 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
3
votes
1answer
209 views

How to get filename of image used as image fill in table cell?

I'm designing a large photo-based book for a client and he came up with the idea to select the images to include and their sequencing by placing them roughly into a Keynote file. This sounded like a ...
1
vote
1answer
363 views

Numbers app: how to change x axis position + change chart's line width

I have a regular linear graph and have y values running from negative to positive, enabling x axis shows the line at the bottom of the graph. How is it possible to set it to show at zero, i.e. running ...
9
votes
5answers
11k views

How do you paste syntax highlighted code into Keynote '13?

I give a lot of code heavy presentations with Keynote. Syntax highlighting makes these readable. In the past I've used web based syntax highlighting tools, and then pasted the easier-to-read code ...
6
votes
2answers
4k views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
1
vote
1answer
3k views

Batch convert Pages files to doc

How can I convert a large number of Pages and Numbers files into the files of office format as quickly as possible?
4
votes
2answers
40k views

How to change color scheme of Keynote slide design/template?

I just made the switch to Mac. In PowerPoint, I used to be able to select a certain slide theme or design but choose a different color of it. How can I do that with Keynote? I've been googling for ...
2
votes
3answers
688 views

What causes all iWork apps to have blank, unusable documents after a reinstall?

After deleting and re-installing the apps, I can't use iWork. Specifically, the document area is always empty, no matter if I create a new document or open an existing one. This applies to Pages, ...
2
votes
3answers
483 views

What’s the best way to view all my iCloud Documents without opening different apps?

I frequently have to copy over documents to and fro iCloud and my Desktop. It’s really tedious to open each iWork app, search through the list, copy my file and repeat. Is it possible to view all my ...