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
0
votes
1answer
12 views

Numbers : sum if tick-box on next column is true

I have 3 column in a numbers sheet (A) Text | (B) Currency | (C) Tickbox At the end of (B) Currency, I have a very basic formula SUM(B) What I'm trying to do is to have the same SUM(B) at the footer ...
0
votes
1answer
27 views

How to enter Unicode (or other) symbols in LaTeX within Keynote (iWork)

In Keynote and other iWork apps, it is possible to enter formulas (and text) in LaTeX. This is an immensely valuable feature. But... How can I enter an astronomical (or other) symbol, via Unicode or ...
0
votes
1answer
18 views

Import text from webpage directly into Numbers cells

In a numbers file I am using, whenever I open it I need to manually import a specific value from a webpage. Specifically, from this webpage I want to import the USD to EUR ratio. Any other similar ...
0
votes
0answers
9 views

Using Mouse scroll plus Control for iWork suite?

I would like to use zoom function in Pages / Keynote using Mouse scroll + Control while I work most of the time using an external monitor without trackpad. Such feature works in .pdf viewer or ...
0
votes
0answers
7 views

Apply conditional highlighting to a cell range based on a single cell in Numbers

In Google Sheets, I was able to conditional highlight a cell range based on a single cell. The rows in this image are colored based only on the value of cells in Column A. Is there any way to do this ...
1
vote
0answers
39 views

How can I downgrade from keynote 10.1 to 10.0?

Well, I updated to Keynote 10.1 and it hangs when starting the slideshow of the presentation. All of them went well on v10.0, but they don´t in v10.1. Any advice or suggestion. (Running in macOS 10.15....
1
vote
2answers
41 views

Is there a way to automatically save Pages documents copies as PDF on every save?

Is there a way to enable Pages (version 10.1 (6913)) to automatically save a copy of the current document as PDF every time I save it to avoid a manual export?
0
votes
2answers
19 views

In Numbers make Y axes show smaller values

I have a table making a line graph with very small numbers that vary from 0,000149 to 40, and when I make a line graph out of this table of numbers the very small numbers are crunched in a horizontal ...
2
votes
3answers
28 views

Numbers not creating a line graph

I'm quite new to Numbers (and spreadsheets programs in general) but I need to create a simple line graph based of a spreadsheet but for some reason Numbers is not making the lines of the graph even ...
0
votes
2answers
32 views

iWork Numbers How To Calculate - In Once Cell Function - The Elapsed Time In Hours Between Two Date/Times?

Let's say I have two date/times. The start date/time is 29th May 2020 at 20:30 and the end date/time is 30th May at 02:30. This link shows how to calculate using two cell references. How to ...
0
votes
1answer
31 views

Is it possible to define a custom numbering style in Pages?

I would like to cite some articles, books. The standard form is to use square brackets, but Pages these are not within Pages numbering styles. I want to achieve: [1] 1st source [2] 2nd source . ....
0
votes
2answers
65 views

How to add hyperlinks to local files in Numbers?

How do I add a hyperlink to a local file? I know how to add a hyperlink to a website, so I tried something like file:///Users/MyUser/Documents/Invoices/Some%20Stuff.pdf However, adding this path to ...
0
votes
1answer
18 views

Is it possible to set opening certain apps such as Safari, iWork, MS Office in the full Window mode by default like Mail App (macOS Catalina)?

The only App I can set opening in the full window is Apple's Mail App - it can be set in the App setting. I suppose other application could be set via terminal commands, but I'm not that handy with ...
1
vote
1answer
80 views

Numbers - INDIRECT Call Error

I have a spreadsheet in Apple Numbers which I use to track debts and amortize payments. To do this, I use calls to INDIRECT on the Amortization table to load relevant data from the Debts table. ...
0
votes
0answers
7 views

Path to file listed in Recent documents?

I have the same "recent document" in both Numbers' Recent documents as well as in the system wide Recent documents (in the Apple-menu) but the document is gone. I would like to see the path where ...
0
votes
0answers
10 views

Numbers: Sum the same cell across multiple sheets

I'm making a tracker for my HSA expenses. I have it organized by year, one sheet per year. Within each year I have a "Purchases" table for individual expenditures and a "Totals" table for ...
0
votes
0answers
15 views

iWorks Numbers convert forumla output to a URL [duplicate]

I wrote the following formula in numbers ="http://www.google.com?id="&$A1 It shows me the resulting string correctly. like http://www.google.com?id=1 However this is just a string and I cannot ...
0
votes
0answers
11 views

Automatically have line numbers when writing a document in pages

When using pages to write a document, is it possible to have pages generate the line numbers for every line?
2
votes
1answer
637 views

Heatmap in Numbers (colouring cells by their numeric value)

In Excel, it's possible to display a "heatmap", i.e. colouring a group of cells depending on each cell's numeric value: I'm looking to do the exact same thing in Numbers, but surprisingly I couldn't ...
0
votes
0answers
7 views

Are there any iCloud or iWork compatibility issues between macOS Sierra, iOS 9, and iOS 13?

I currently use macOS Sierra, an iPad 2 with iOS 9, and an iPhone SE with iOS 10. I'm planning to upgrade my iPhone SE to iOS 13. One thing I wanted to check before doing this is if there is any ...
0
votes
2answers
46 views

Pages - new paragraph in the same list item?

I create a numbered list: 1. Point 1 2. Point 2 and so on. Now I realised that the content of 2 requires two paragraphs 1. Point 1 2. Point 2, paragraph 1 Point 2, paragraph 2 but pressing ...
1
vote
1answer
31 views

Opening any of the iWork suite brings up over 80 dialogs in a row

Upon opening Pages, Keynote or Numbers I'm informed that it "needs to download the font X" with a skip or a download button via a dialog (great choice, something that remains in the centre of the ...
2
votes
1answer
21 views

How can I autofill a formula in Numbers, but keep some referenced values the same?

So I have a chart in Numbers (iOS version, but I can use the macOS version, if needed,) which has formula that references some values from the chart, as well as some values from a different chart. I ...
2
votes
0answers
42 views

Pages exact same font, looks sharper when using template

I have been using the default fonts in the 'Business Resume' template and I wanted to use them in my handcrafted version due to this bug. The fonts are pretty simple and nothing extraordinary, for ...
1
vote
1answer
524 views

Help with AppleScript to automate Numbers Cell Formatting

I do several mundane repetitive tasks using Numbers App on a Mac, and wish I could just automate the same with the help of AppleScript. I got Numbers Spreadsheet with several tables, on the selected ...
2
votes
1answer
21 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, ...
3
votes
1answer
47 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
98 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
114 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
70 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
67 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 ...
1
vote
1answer
1k 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
33 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 ...
1
vote
1answer
900 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
149 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
35 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
118 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
19 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
1k 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
149 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
4k 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
520 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
198 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
20 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
2k 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?
2
votes
1answer
26 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
114 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
50 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
73 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
33 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" ...

1
2 3 4 5 6