Questions tagged [iwork]

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.

Filter by
Sorted by
Tagged with
1
vote
1answer
15 views

Numbers - continuous line connecting gapped data?

This question over on SuperUser is exactly the same as mine, in the sense that I have a CSV that contains gaps in each column, but I want to plot it as a continuous line. However, I'm using Numbers, ...
2
votes
2answers
1k views

iWork Numbers evaluate string

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?
0
votes
0answers
12 views

Conditional stdev function in Numbers?

If I have a set A of numbers in Numbers (hah), I can use averageifs to calculate the average of the subset of A which satisfies certain conditions. For example: Say I have the following table: If I ...
2
votes
1answer
30 views

Pages: Fit two A5 page on on a single A4 page in landscape mode

I want to print the same content twice on a page and then cut the page into two parts. Basically I want to start with an A4 page in portrait mode, and want to end up with (approximately) two A5 in ...
1
vote
2answers
31 views

Is it possible to export a simple Numbers spreadsheet while being dynamic?

I have a few Numbers Spreadsheet that I use to keep track of my budget over the weeks/months but its only accessible in Numbers, which is fine Until I am at work where we use windows. My only ...
0
votes
1answer
29 views

Evaluate a formula stored in a cell

Is it possible to store an expression in a cell and then refer to it/evaluate it within other cells? I've found myself repeatedly using complex expressions in cell formulas, e.g., the sub-expression ...
0
votes
0answers
34 views

Identify last (or first) non-blank cell in range

Is there a way to identify the last (or first) non-blank cell in a range? Consider a sheet that may have multiple rows with blank cells in a certain column. In a cell, I'd like to use the value of ...
2
votes
1answer
18k views

Get Numbers & Pages et al. on macOS 10.11 El Capitan

I have some old macs which cannot update to OSX 10.12, however this is the minimum requirement for installing those applications from the app store. Please could someone advise how to get an older, ...
3
votes
2answers
2k 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
0answers
6 views

Keep a Numbers chart stationary while scrolling the page?

In Numbers, is there a way to make a chart stay visible at the top of the page while I scroll down through the rest of the page's contents? Similar to how a table's header row can be made to stay ...
6
votes
3answers
2k views

How to adjust the left margin in Pages' Business Resume template

In the screenshot below, can someone tell me please how to shift the main text area to the left? From the ruler, one can see the text begins at about 6.7 cm. Changing Document Margins from the ...
0
votes
1answer
51 views

Is there a way to reverse the order of rows in a chart?

I'd like to change this chart to the following one: So, I'd like to reverse the order of rows. According to an answer on a similar question, you need to create a formula and put it in each cell ...
1
vote
1answer
21 views

Prepending section/subsection numbers to headings in Pages

I would like to make a document where each paragraph of text with a "section" paragraph style is prepended with a level-one number (e.g. 1, 2, 3, etc.) and each paragraph of text with a "subsection" ...
2
votes
0answers
26 views

How do I check if a date is between 2 dates?

In the above example, how would I get the “period” (column C of the Example table) of a certain date (column B of the Example 2 table) using the start and end dates (columns A and B of the Example ...
3
votes
1answer
1k views

How do you change the colour of tags?

In the new update of Pages, Numbers and Keynote for iOS 11 and in Files you can now add tags. Is there a way to change the colour of tags once you’ve added them?
0
votes
1answer
229 views

Keynote - View slide as at end of all animations

I am working on my first Keynote presentation, and my first slide has a series of complex animations which results in a slide which is very different from how it started. I wish to maintain the end ...
0
votes
1answer
69 views

How can I find duplicate adjacent cells in Numbers?

I have a Numbers sheet that is thousands of rows long. As an example in the image, the sheet has two columns with URLs. What I need to do is find the rows that have the same URL in the two adjacent ...
0
votes
1answer
29 views

Numbers - Perform arithmetic on a section of cells

I have a column of cells and I want to do 41 - (value of cell) for each individual cell without having to go through doing it manually. I know this seems simple but I can't think of an easy and quick ...
1
vote
0answers
67 views

Applescript Pages: How to tell thisDocument to make new page with template page

I have created a Pages document with a template, and I want to add a page to the document using one of the pages in the document's template. Something like: tell thisDocument to make new page with ...
0
votes
1answer
2k views

Why is iWork Keynote is suddenly linking images instead of embedding them?

I've been using iWork for a while and have created some pretty elaborate designs in Keynote and Pages, but I haven't come across a problem like this before or even an option to link/embed images. In ...
1
vote
0answers
15 views

Pages: Cannot move some Alignment Guides around

With Pages, I'd love to move some of the alignment guides, as shown in the screenshot below: The first and the third one seem to be fixed and cannot be moved around. I can only move the second, which ...
5
votes
4answers
22k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.
1
vote
1answer
800 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
4
votes
1answer
600 views

App Store on High Sierra suggests Mojave-only updates

I'm currently on macOS High Sierra (10.13.6) and I've just received three update notifications from the Mac App Store: Keynote 8.2 update Numbers 5.2 update, and Pages 7.2 update All of them are ...
6
votes
1answer
466 views

is there a way to disable update notifications in iWork apps (Pages, Keynote, Numbers)?

Even with App Store Automatic Updates set to OFF, all of the iWork apps pop up a modal dialog box on startup to inform you there is an update. Is there a way to disable this behavior (in El Capitan)?
0
votes
1answer
814 views

Getting the First Cell NOT Containing Certain Text in Numbers

I have a table in Numbers, and I'm trying to get the value of the first cell that contains the character …. In order to do so, I wanted to use MATCH(), but had no luck after I realized it could only ...
3
votes
1answer
1k views

How to move “section”/change “section” margin in Pages

I've been a full-time Mac user for 5 or so years now, but sometimes the Apple way still confuses my Microsoft-conditioned mind. This is especially true of iWork. In the screenshot below, can someone ...
1
vote
3answers
2k views

Is there an iOS spreadsheet app that can do data filters?

Google Sheets only does data filters in the browser, their mobile app does not support that feature. Is there another iOS spreadsheet app that does support such a feature? Basically, I want to be able ...
3
votes
4answers
69 views

Find Font used in Numbers

Is there a way to find Font used in Numbers? Opening the spreadsheet on my Mac is fine, but I get this error message when opening the same document on iPad (iOS) The font TIMES-Roman is missing. I ...
0
votes
1answer
1k views

Customizing Pages' outline using paragraph styles

My document in Pages 4.2 for Mac has custom paragraph styles for a couple of levels of headings. I'd like to get a bird's eye view of my document that shows only those headings, not the paragraphs in ...
0
votes
3answers
984 views

How to set up equal height columns with a title on top?

This is what I'm trying to do on Pages '09: two equal height columns with a title on top. Any suggestions?
4
votes
3answers
3k views

How to install old iWork on a MacBook with MacOS High Sierra?

I have a new MacBook Pro running High Sierra (10.13.2) and installed current versions of Pages and Numbers. But I need also the old versions (from iWork 9 I think) with mail merge support. I had those ...
2
votes
1answer
789 views

Apple Numbers IF rules with checkboxes

I have a column A with checkboxes and a column G with Currency can I do a formula to get the total of G only when the checkbox is not tick? in the same idea, I have some dates in column B, and I ...
4
votes
1answer
114 views

Counting the number of cells which contain a specific character

I want to count the number of cells which contain the character “1” in an Apple Numbers table row. When the row of cells include (using a space delimiter between cells), 1234 5671 1 8765 6113 2468 ...
3
votes
1answer
234 views

How can I install template from 3rd party to Keynote?

After downloading a template for my Keynote program, I can't seem to install it correctly so that I can utilize the 200+ slides that are included when I wish to add a new slide in the presentation. I ...
7
votes
3answers
4k views

What are some good sources for Pages and Keynote templates? [closed]

It doesn't matter whether they are for free or for purchase as long as they are compatible.
2
votes
2answers
995 views

Add spacing before and after paragraph in iOS Pages?

I don't see a way to edit this style property in the iOS version of Pages. (I'm using 4.0, March 2018). Am I missing it, or do I need to open the document on my macOS system to set this property?
5
votes
4answers
11k views

Add big green check mark to Keynote presentation

I'm using Keynote '09 for the first time, and I find myself wanting some bits of clip art or additional shapes. At the moment, I just want a big check mark. It's hard to believe that this isn't ...
2
votes
3answers
11k views

Is it possible to get Keynote/Pages/Numbers for El Capitan?

I received an older MacBook Pro 5,1 (MacBook Pro 15” Unibody, Late 2008 / Early 2009), but it came without a hard drive. I installed Mountain Lion from DVD, then updated to El Capitan, which is the ...
0
votes
0answers
133 views

Numbers 3 or 4: how to copy a chart completely?

I have Numbers 4.3, 3.6 and 2.3 installed on different computers. I want to copy charts from Numbers to Keynote but when I do that in 4.3 or 3.6 the title, legend etc are omitted (and yes, I have ...
4
votes
1answer
956 views

Numbers 3 - How to apply custom chart style

Using Numbers 3.0 with Mavericks. I am creating a bunch of scatter plots in numbers. I want to remove the big bubbly data point symbols and simply display the data as connected points. Setting this ...
2
votes
4answers
11k views

Batch convert Apple Pages files to Microsoft Word doc files

How can I convert a large number of Pages and Numbers files into corresponding MS Office format in a quick manner.
1
vote
2answers
2k views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
1
vote
1answer
13 views

Is it possible to have a shortcut to create bookmarks in Pages?

In Apple Safari the command-d creates bookmarks. I would like to have it in Apple Pages. Is it possible to have a shortcut to create bookmarks in Pages? I know command-k but its for linking to ...
2
votes
1answer
17 views

Increase numbers by one in merged cells

My question is very related to this https://discussions.apple.com/thread/3204532. I just want to do the same but in merged cells, as in the picture below. Is it possible? I see no fill handle here.
0
votes
1answer
49 views

Create a table from other table depending on a value NUMBERS

I have a table with a list of items, and I want to create a new table with all the values that contains a certain value. In the first list, are all the profucts that I usually buy and a cell with "...
2
votes
0answers
41 views

Is it possible to change/remove Pages' table row/column size limits?

I want to make a row in a table super thin but Pages has a 0.28in minimum for rows when auto-resize is turned on and a 0.11in minimum for rows when auto-resize is turned off. I searched everywhere ...
2
votes
2answers
64 views

Is there a way to create a small-caps character style in Pages 6?

Cross-post from discussions.apple.com. As the title says: I have a paragraph style for the main body of my document. Within a paragraph, there are some words that need to be in small caps. From my ...
0
votes
1answer
3k views

Safe to Delete Keynote Cache under /Library/Container/com.apple.iWork.Keynote/Data/Library/Caches

While the question "is it safe to delete /Library/Caches" is commonly seen, OSX also has another path for storing caches (not sym link). Keynote has another cache stored at /Library/Container/com....
1
vote
1answer
2k views

Re-download OS X iWork suite (Pages, Numbers, Keynote)

Apple introduced Pages, Numbers, and Keynote as a Mac native platform for documents such as letters, spreadsheets, and presentations. These applications come pre-loaded with OS X, as they did with my ...