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 RepliesI 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 RelatedI know there are some iOS and OS X home inventory apps which are all about receipts, snapshots, etc. They are great for insurance purposes and I wouldn't mind if that is part of it, but what I am really looking for is something that helps you with organization. As we try to get the basement and garage of our house organized and put a lot of stuff in bins and closets, I want to catalog as much as I can for reference when I want to find something. Obviously many bins will be labeled, etc., but being able to type an item into software to get its location would be key. If anyone can recommend some software, desktop, iOS, doesn't matter to track stuff, focusing more on where it is than how much you paid, snapshots, receipts, that would be great. If it is for insurance that is fine as long as I can easily search it for location.
View 10 Replies View RelatedCan anyone recommend any software that will help me build and maintain a list of home inventory for insurance purposes? Ideally it will sync to multiple computers and the cloud (automatically) for backup. Enable me to group items into different categories and rooms. And generate itemised documents that can easily be converted into PDFs, Emails or Printed Documents for submitting actual insurance claims (hopefully I'll never need to do it). I found Compartments [URL] that gets mixed reviews. I'm going to test it out later, but before I invest too much time in that I wondered if anyone had any better recommendations.
View 3 Replies View RelatedI've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
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 Relatedhow 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?
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 RelatedI 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 RelatedIs 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 RelatedI'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 RelatedI 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 RelatedI'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".
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 RelatedI 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 RelatedDoes anyone know how to make a clickable table of contents in Word 2008?
View 6 Replies View RelatedMy car dealership's inventory page won't load in Safari? We use a 3rd party company that facilitates our inventory page and I find it strange that the only page they facilitate on our website doesn't operate in Safari.
View 4 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
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?
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.
I'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.
View 4 Replies View RelatedThe v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
View 3 Replies View RelatedI just have a quick question about Numbers (iWork '09). I need to graph some supply and demand graphs for school. How would I go about doing this? Whenever I create a graph based on a chart, it just plots each row as it's own line. I can only edit the values in the Y-axis, and obviously I need to be able to work with the X-axis as well.
Update: I played around with it more and figured it out. I guess you have to graph it as a scatter plot and then choose to connect the dots, and remove the dots, rather than choose the line graph, whose icon looks just like a graph of supply and demand.
I'm a recent switcher from Excel to Numbers. For the life of me, I cannot find a way in Numbers to "freeze" headings so that as you scroll down or across the sheet they remain visible.
I'd be grateful for help; the matter is not covered in the video tutorials, nor in my little manual that came with iWorks, nor on the Help Menu.
I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance. This is how it normally looks. However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation. Check this out. I entered 5192 in the credit section and it changed the balance accordingly. However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.
View 2 Replies View RelatedI'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.
I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically
View 2 Replies View RelatedIn Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.
View 1 Replies View RelatedI recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?
View 3 Replies View Related