Applications :: Pages - SUM Function In Table Always Returns 0?
Jul 13, 2010
I'm using the SUM() function in a Pages table to sum the numbers of a column. For example "=SUM(C1:C14)".
Unfortunately, it always returns 0 no matter what arguments I give it.
Manually adding cells works fine i.e. "=C1+C2+...+C14".
View 4 Replies
ADVERTISEMENT
Sep 17, 2008
When copying a table from say a webpage or even a RTF file, Pages does not retain its table formatting. Instead it separates the rows and columns and puts them on separate lines.
See it for yourself, try copying one of the tables on this page into Pages [URL]
The only way I can get the table into Pages is to paste into NeoOffice (which retains the correct formating), save the file with the .doc extension then open in Pages.
View 1 Replies
View Related
Nov 24, 2009
I'm working on something in pages and need to put in a table of contents, I've looked under sections but I can only see the option for a blank page, can anyone tell me how I insert a table of contents?
View 4 Replies
View Related
Nov 30, 2009
how to create a Table of Authorities in it.
IF not, which program are you using for ToA, and is it compatible with the stuff you write in Pages?
View 4 Replies
View Related
Oct 27, 2009
Is it possible that I can make it look like PDF file. When you open a pdf file on the right part for example it says chapter 15 and when you click it it opens chapter 15. Our instructor told us today that if you use table of contents you can do this. So, when you are writing long reports if you add a table or kind of thing to one part of your report nothing shifts.
View 1 Replies
View Related
Jun 7, 2010
I have been working on a Pages document with a automatically generated TOC, and I would like to have hyperlinks between the contents and the document. I know that clicking on the page number will work, but I would like to click on the actual Titles on the TOC... is this possible?
View 3 Replies
View Related
Jul 29, 2010
I've been working hard on this document in Pages which had 3 tables in. I have been saving it as I have gone on and just now I have scrolled up to realise one of the tables is missing.
View 1 Replies
View Related
Sep 8, 2008
I created a table with three columns and lots of info in the first column. I need it to continue to page 2, but it won't. Instead, all of the info that should continue to page 2 simply disappears. How do I make the table extend to page 2?
View 8 Replies
View Related
Mar 28, 2010
I made a table of contents in Pages the other day and decided to change the colours (for example, one line orange next brown next orange next brown and so on.) but the 6th one down reverts to black every time i either click on the contents or reopen the document.
View 2 Replies
View Related
Jan 15, 2011
I'm creating a song set list in a table Pages (showing song titles and composers, etc), which I want to change the order of the songs and play with the order. Is it possible to grab rows and move them around? Or are you stuck with the order that you created?
View 3 Replies
View Related
May 22, 2012
How do you create a table of contents on pages?
View 1 Replies
View Related
Aug 4, 2009
I'm still trying to figure out Pages, after having recently switched from MS Word. But ... I really, really miss the Backspace, Home, and End functions that you have on the keyboard of most Windows based PC's. Any ideas of how I can configure keyboard shortcuts, etc to make up for the lack of these functions on the Macbook Pro (13") keyboard?
View 4 Replies
View Related
Apr 7, 2012
Using a Macbook Pro and Lion, suddenly unable to save Pages files. Tried verifying and repairing permissions, restarting program and laptop,tested various kinds of files, all say permission denied. unable to save changes also. Useless unless I can save my work.
Info:
MacBook Pro (13-inch Mid 2010), Mac OS X (10.7.3), Pages worked fine for two years
View 3 Replies
View Related
Oct 17, 2010
Every time I search for a song in iTunes, then close the search by hitting the "x" in the search bar, iTunes returns me to the top of my iTunes library (the A's), instead of staying on the song I've searched for and selected. It's incredibly annoying, and has been happening to my iTunes for a few years (but didn't in early versions of the software). Does anyone else have this problem? Is it a bug, or just a bad design? If so, is there a way to stop it?
View 4 Replies
View Related
Feb 17, 2009
Ok so I am making a presentation using Keynote '09. I have one slide that has a huge table of different appliances and their cost. Here is what I would like to do: the first row is entitled "refrigerator". I would like there to be one slide that just has the table title and this first row. Then I would like to show the next slide, which has pictures and descriptions of the specific refrigerator on it. Then, the next slide would be the table again, except this time another row would appear, in this case entitled "heating", then I could show the next slide which has info about the heating system, etc., etc. I have used Magic Move (and love it btw), but that can only be used on the slide right after the target slide, so that would not work for this since they have a slide in between them. I have no idea if this is possible, and maybe the only way to do this is to make a different slide every time, but if there is an easy way to do this that would be awesome!!
View 1 Replies
View Related
Oct 13, 2009
I have a list in ascii/text format, where columns are separated by "|"'s. I'd like to read this into Numbers but by default it doesn't know what to do with those "|"'s of course. I've heard (though am unable to verify) that Excel has this ability to recognize separator symbols and put it in separate columns. Is there a way to do this with Numbers or any other Apple program?
View 1 Replies
View Related
Jan 9, 2010
I'm building a presentation in Keynote 09 and cannot seem to add a shadow to text inside a table. I've selected the table, the individual cells and the text itself and the shadow checkbox on the menu is no where to be found.
View 1 Replies
View Related
Apr 12, 2010
I'm trying to set up a table for our pharmacy's inventory. I want to develop monitoring parameters for certain drugs, but numbers isn't letting me merge cells together the way I'd like to. For example, say I have a drug, Lisinopril. I have Lisinopril in 1 column with 3 monitoring parameters in another column in 3 rows. How do I get those to all be associated with Lisinopril?
View 11 Replies
View Related
Oct 23, 2008
Does anyone know how to make a clickable table of contents in Word 2008?
View 6 Replies
View Related
Mar 24, 2010
I need to open a few Pages files but I don't have Pages installed on this computer. I understand you can convert Pages files to .doc or .pdf within the application, but unfortunately I won't have access to the computer with the program installed for a while.
Is there some sort of (free) converter that can convert .pages files to .doc or .pdf or even .rtf?
Or even better, a document creator/viewer than can open .pages files?
View 5 Replies
View Related
Mar 31, 2010
I'm wondering if there's a way to eliminate the visual break in-between pages in Pages '09 (see screenshot). I'd prefer maybe a subtle dotted line indicating a different page, not a 5-inch gap.
View 1 Replies
View Related
May 12, 2010
I'm trying to create pages that have all black backgrounds. I've been doing this by using the Shapes tool, choosing a rectangle, filling in the entire white space for the page, which is 8x11, and then filling in with black.
The problem is that when I do this, Pages seems to think that I want this page and the following page to be connected, in some way. When I look at the two pages in the thumnail view, the yellow outline is around both pages, rather than each individually.
Anybody know how to keep this from happening. Or the right way to create full black backgrounds for pages in Pages?
View 1 Replies
View Related
Mar 6, 2009
How do i disable the dashboard function from the middle mouse function. It's hard to use blender with the dashboard constantly comming up.
View 8 Replies
View Related
Mar 22, 2010
I have been working on a template where I have placed a two column table on the front page, left side being for a graphic for a letterhead, and right side column for text.
My problem is that on the second page, I would like the document to continue on without any table. I would like for the text to flow from the table into regular margin document on the second page. Is there a way to do this?
View 7 Replies
View Related
Nov 17, 2009
There have been a couple of discussions about third party retailer returns on bto iMacs and I was wanting to clear it up. I would like to get an i7 at macmall and use the $150 discount. I believe I still have to pay tax in il though. Anyways, if I get it and tere are a couple dead pixels next to each other in the center, I just have to send it into apple and have them repair it under the one year warranty right? The bad part about macmall is that I can't just exchange it out for a new one
View 13 Replies
View Related
Apr 16, 2012
When I awaken my G5 in the morning (when its chilly) it goes back to sleep almost immediately. This may repeat twice before it finally stays on. I initially thought it was my HD, a new purchase at the time. However, I have switched to another internal drive and have been experiencing identical results. I've run TechTool Pro, Onyx, Applejack, and Disk Utility, thinking it was a HD issue, but having switched drives, I'm thinking it must be a hardware issue of some sort.
[url]...
Info:G5 tower, Mac OS X (10.5.8), 160GB HD + 1 TB HD internal
View 5 Replies
View Related
Jun 30, 2012
When I return back from a page most of the time install of the original page, Safari returns to a very old page.
This seems to happen on Ars Technica's site the most. Of course on that site I do a lot of jumping atround to view all of their articles.
I have cleaned Safari cache, also history and remove all web perveiw images plus restarting Safari and reboot all without having any effect.
View 1 Replies
View Related
Dec 1, 2014
In Settings->Keyboard->Text it is possible to add/delete replacement texts; e.g. 'omw' comes as a default to replace 'on my way'. A Swedish language default is replacing 'mvh' with 'med vänlig hälsning'. I prefer not using these and have thus deleted both of them. Repeatedly deleted them that is since these defaults keep returning a day or so after I have deleted them.
I'm using Mac OS X Yosemite 10.10.1 on a MacBook Air 13'' that was purchased in Oct 2014.
Info:
MacBook Air, OS X Yosemite (10.10.1)
View 4 Replies
View Related
Jan 18, 2009
I'm new to mac and using imovie and I've got a problem which I can't find an answer to when searching. I'm using the titles function and I've noticed that when you apply one they either are placed in the bottom of the screen or in the middle. There isn't a title that is placed at the top.
Is there any way to move the title to the top of the image or alternatively is there a way to add text to an image in imovie. I can't believe that made the titles so limited in function and adaptability.
View 1 Replies
View Related
Jul 8, 2010
I recently became an owner of a Mac Pro but I am having a small problem. I'm not certain how to set up the browsing so when I return to a site it recognizes who I am and does not require inputing the blanks each and every time. I believe it's a browser setup function but it must be looking me straight in the eyes.
View 4 Replies
View Related