Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
2answers
26 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
0answers
30 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 ...
0
votes
1answer
26 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 ...
1
vote
0answers
4 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 ...
0
votes
1answer
31 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 ...
2
votes
0answers
25 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 ...
0
votes
1answer
137 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
61 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
28 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
54 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 ...
1
vote
0answers
14 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 ...
4
votes
1answer
577 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 ...
3
votes
4answers
62 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 ...
2
votes
1answer
490 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
70 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 ...
0
votes
0answers
113 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 ...
1
vote
1answer
12 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
2answers
926 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?
1
vote
0answers
285 views

Print just selected cells in Numbers

If I remember it correctly, in MS Excel I can print just a selection of cells. This is usefull if there are more cells in a sheet then what can be put in an A4 peace of paper. Is it possible to do ...
2
votes
1answer
16 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
44 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
38 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
63 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 ...
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" ...
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 ...
1
vote
0answers
48 views

Catch-22 for old Pages version on ancient old MBP (late-2008)

after having worked perfectly fine for 9 years, my Pages (iWork '08) keeps crashing lately and, as of today, crashes when I do the simplest actions. I operate on a late-2008 MBP which I've upgraded to ...
3
votes
1answer
407 views

Where is the iWork shape library stored?

I created a Custom Shape Library via iWork and would like to share it within my company. Where is this library located so I can copy/paste it to all other users? I already found where custom ...
3
votes
1answer
3k views

How to export only the selected part of my Numbers file to PDF?

I have a Numbers file which has a lot of elements that when I want to export it to PDF it becomes 12 pages of A4 size. All I want is selecting part of it and exporting only that part to PDF. Is it ...
2
votes
1answer
543 views

set checkbox based on parameters in iWork Numbers

I would like to be able to tick or untick a checkbox in iWork Numbers based on certain parameters. The spreadsheet is a list of projects (Column C), each composed of several tasks (column D). Column ...
3
votes
1answer
930 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?
2
votes
1answer
17k 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, ...
0
votes
0answers
656 views

How to set a custom page size in Numbers?

There seems to be no option for this on Numbers 4.2 There are a bunch of options with fixed sizes, but nothing to set custom values for the document's width and height. The reason is that I want to ...
2
votes
1answer
693 views

How to add background images to front page of Pages doc?

Want to add background images to the front page only of a Pages doc. I can't understand how to do this—reading the Apple doc on this didn't help unfortunately. Can't get background images (Master ...
1
vote
1answer
28 views

Numbers : Conditional Highlighting with decimal

I have a cell, the value is 90.90, I setup a continual highlighting for different value, one is suppose to be greater than or equal to 99.90. however I don't get this one to work as 99.90 is ...
1
vote
1answer
31 views

Sum an entire column in Numbers from a different sheet?

Is there a way to do something like Sheet1::Table1::SUM(A1:AΩ), where Ω returns the last row number on Sheet1? This would enable leaving Sheet1 with values only, no formulas.
7
votes
2answers
391 views

How do I get iWork / iMovie / Garage Band free of charge?

Everything that I have read says that iWorks/ iMovie etc should be free for Mac users after 1 September 2013. I already bought Pages but want Numbers and iMovie. My MacBook Pro with retina is early ...
2
votes
1answer
23 views

Show all x-axis markers for Numbers' bar graphs

With Numbers' bar graph, I'd like to show all x-axis markers of my table, or at least selected few with all the columns present. but only a few is displayed when there are many. The only way to show ...
1
vote
0answers
45 views

Restoring “bundled” apps (iWork/iLife) state on fresh machine

I am currently working on deploying a large number (500+) of MacBooks out to users who will own the devices and sign in with their own personal Apple IDs. Unfortunately whilst building the image we ...
0
votes
1answer
34 views

Redownloading iWork for iPad apps without paying for them

I bought an iPad Air 2 fourteen months ago. Recently I reset my iPad and now Pages, Keynote, and Numbers are not free — they ask for payment. How can I download them again without paying? I tried to ...
2
votes
3answers
10k 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 ...
2
votes
0answers
58 views

Is it possible to reference a cell in Numbers using two column headers?

I am aware that I can reference cells using the name of row/column headers. It looks something like this: Sheet Name::Table Name::Column Name Row Name. However, I'm trying to reference something ...
0
votes
0answers
27 views

Source Control for iWork Files

Bottom Line - Source Control for iWork files in organised folder structure. Background - Our work has moved to iWork as the primary office suite. And one of my irks is that we have way too many ...
1
vote
1answer
49 views

Keynote: How to skip “open presentation” window?

When I launch Keynote on my new MacBook Pro, the window used to open existing presentations is opened: I would like to simply open a new document instead, but cannot find an option for this. Is ...
6
votes
1answer
421 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)?
1
vote
1answer
87 views

In Pages, trying to bold everything that is inside {curly brackets}

I have a source document that I'm trying to clean up, it's essentially plain text. But the author has bold text indicated with { } brackets, and italics indicated with < > brackets. I would like ...
1
vote
0answers
178 views

How can I reinstall iWork applications after I removed them from my Mac?

If I were to say, remove Pages from my Mac, would I be able to reinstall it later from the Mac App Store?
1
vote
1answer
64 views

How to find all iWork documents which are not yet converted to iWork'13?

When opening documents in iWork'13, the documents are converted and may wind up looking different if they were created in iWork'09 (see Apple support article ”Working with iWork'09 files"). Documents ...
2
votes
1answer
87 views

Pages can't open file: error -60005

I have a .pages file I've worked on as recently as May. When I tried to open it the Console.app reported: 9/2/16 7:21:44.392 PM CoreServicesUIAgent[337]: Error -60005 creating authorization The file ...
0
votes
1answer
116 views

How do I search footnotes in a Pages Document?

When I try to search for an existing footnote's number no results come back. Is there some special setting to search for footnotes?
2
votes
1answer
3k views

Numbers: checking if cell with specific text exists

Prerequisites I have some tables with cells like so: Also, I have some more tables like so: Objective Note the YES and NO. in the Included column in the Example Requirements table. You will note ...