We’re rewarding the question askers & reputations are being recalculated! Read more.

Hot answers tagged

41

I'm not sure why it's included in the export, but this is one of the default "Image Fills":


35

tl;dr: it's the default shape fill, strictly unnecessary if there are no shapes. XLSX, DOCX and other formats use OPC (the open packaging conventions), which mandates the zip container and describes how files should be laid out. If there is a file that you do not recognize, look in the various relationship files (they end in .rels). In this case, the ...


31

Keynote files exported to PowerPoint do things like this too. That PNG is a background fill from Keynote, and is made available to PowerPoint to be used as the default shape fill for shapes created in the exported document. Keynote not only exports your document, but also the template style elements it was created with - even if some of those style elements (...


30

With the table selected, simply choose Table > Transpose Rows and Columns.


22

(⌥OptionEnter↩). Or just return if you've unchecked Return key moves to next cell in the inspector:


20

By default, no, there's no shortcut. You can create one yourself though: Open System Preferences → Keyboard → Shortcuts → App Shortcuts. Click the + button to add a new shortcut. Set the Application to Numbers.app, and the Menu Title to Delete Row. Set your keyboard shortcut and press Add.


18

You can also replace the delimiters with tabs: Copy the cells and paste them to a new TextEdit document. Replace ", " with tab. You can insert a tab by pressing option-tab. Copy and paste the text back to Numbers.


18

Found a way. Select the column Deselect the header row (Cmd click on the header row cell) Table Menu > Autofill Cells > Autofill Down This will ​not​ infer a pattern. (ex 1,2,3 it will just copy down 1,1,1) If you’re expect it to interpolate, you have to click-drag. It will fill down formulas and they will be correct.


17

If it doesn't have to be updated dynamically, you might also copy the cells and run something like pbpaste | sort | uniq | wc -l.


15

Yes, Numbers can export CSV files. Go to File » Export and click the CSV tab.


14

You can do this directly in Numbers. First, add two empty columns after the column with the data you want to split. If the first piece of data you want to split is in cell B2 and is separated by a space, then use this formula in the empty cell C2: =LEFT(B2, FIND(" ",B2)) If the data is separated by a comma, then replace " " with ",". In the empty cell D2, ...


14

I recommend you just delete Numbers and Keynote using Finder. The Mac App Store will detect the missing apps and allow you to reinstall them in the future if you ever need them. Alternatively, you can use AppCleaner to delete them. This will remove all associated preference/cache files. This is usually superfluous unless you have an actual need to delete ...


12

Here is a clever solution posted in an apple discussions thread. You basically create another column, and use the formula =IF(COUNTIF(A$1:A1, A2)=0,1,""). This will display a one for the first occurrence of each unique item. You then simply sum the whole column and you get your count.


12

Was having the same problem – apparently the options to swap axes moved to the bottom left when Editing Data References: Answer found here.


10

If you want a line graph with 2 y-axes. You to insert->Chart-> 2-Axis. Put in your data. One of the sets will be a line the others a bar. The way to fix that is: Select the one that is a bar then to go to the Inspector-> Chart-> Series. It will say series type-> select that and change it from bar to line. Right below that it says plot on: There you can ...


10

In Numbers you can use any separator when importing csv tables. On the format sidebar, in the table tab, look for adjust Import settings. Inside it you have delimited options where you can even use custom delimiters


9

You can do this using header and footer rows. These automatically adjust the formulas contained within them based on the number of rows above. Make sure you have the footer row enabled: In the footer cell, enter =SUM↩︎. Select the column by clicking the relevant header cell or column reference. The formula will automatically adjust from now on. An ...


8

In Finder, choose File > Get Info (or ⌘ Command+I, or right-click on the file) to change the default application for a particular file: And you can also change the association for all files of the same type:


8

Just rename the file in question to end in ".csv" Then ("File" > "Open…") and Numbers.app did the right thing with the data for me.


8

In experiencing this problem, Numbers always treated all of my bars as one series (not sure what planet that makes sense on, but whatever). You need your data treated as separate series so that you can apply a color to each series. With the chart selected, click the Edit Data References button that appears over the chart. Then, look in the lower, right-...


8

Select the columns with the data that you want to preserve. Choose Copy from the Edit menu (or hit Command ⌘+C). Choose Paste Formula Results from the Edit menu (or hit Shift ⇧+Command ⌘+V). You should end up with just the results of the formula.


7

There are two ways to change the content of a cell using the keyboard: Navigate to the desired cell with the arrow keys and then simply start typing. The previous content of the cell (if there was any) will be replaced. Navigate to the desired cell with the arrow keys and the press ALT+Return. The content of the cell will not be replaced and the cursor ...


7

If a field in a CSV file begins with an apostrophe ('), both Excel and Numbers will treat the field as text, and not render it with any numerical formatting. Your CSV files appear to try to force text rendering through enclosing number fields in double quotes, but Numbers and Excel don't seem to take the hint that double quote numbers should be treated as ...


7

As often happens, a couple of minutes after posting the question, I found a way to do this. In the Inspector, (opt-cmd-i), in the Table Inspector tab click on the middle button of Headers and Footers. Select the option Freeze Header Rows and the first row will stick to the top.


7

Unfortunately, Apple removed that option in the menu bar. However, you can still get the today's date by manually typing it (obviously) or by selecting the cell and typing "=Today", followed by the return key. You can also type "=Date", followed by the return key. You can then manually select the date there.


7

Another way to do this without clicking in each cell would be to use the =HYPERLINK() function. Here are some steps: Add a second column (Let's call it B) In the adjacent cell, add a formula like this: =HYPERLINK(A1) Drag the formula down Provided that the original URL's are valid, this will convert them. You can even add your own text in place of the ...


7

It works by dereferencing the value of a cell directly to the condition Example: SUMIFS(Daily Log::Income,Daily Log::A,">=2014-07-01",Daily Log::A,"<2014-08-01") Referencing the cell could also be made possible with the same construct; by adding ampersand followed by the cell name outside the double quotes. Example: SUMIFS(Daily Log::Income,Daily ...


7

The short answer is, no, however you can lock a table. To lock a Table, select it and then, from the Menu bar, click: Arrange > Lock The longer answer is, if you want to protect* a cell or concurrent group of cells, do the following: Overlay the target cell or concurrent group of cells with a rectangular shape. Open the Inspector, click the Graphic tab, ...


7

Just to make an official answer: Use the SUMIFS() function to use 2 or more conditions. From the documentation: The SUMIFS function returns the sum of the cells in a collection where the test values meet the given conditions. SUMIFS(sum-values, test-values, condition, test-values…, condition…)


6

RCDefaultApp A preference pane that allows a user to set the default application used for various URL schemes, file extensions, MIME types, and more. Easy to use, free, works on Lion and you can do all your file type associations from a single window.


Only top voted, non community-wiki answers of a minimum length are eligible