Applications :: Numbers - How To Rename Cells
Sep 26, 2009In 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
ADVERTISEMENT
Applications :: Merge Cells IWork 09 Numbers?
Oct 21, 2010Is there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)
Applications :: Numbers 08/09 Counting/not Empty Cells?
Jan 18, 2009I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell.
It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.
Applications :: Numbers - Formula Not Let To Select Cells - Only Whole Column
Oct 17, 2009I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
Applications :: Linking Cells / Columns Between Sheets In Numbers
Nov 21, 2009In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
View 1 Replies View RelatedMacBook Pro :: Borders Around Individual Cells In A Row In Numbers?
Feb 16, 2012How do you put a border around the whole cell in a row of cells, ie Totals of several columns in the Numbers s/s.?
Info:
MacBook Pro, Mac OS X (10.6.8)
OS X Technologies :: Accessing Cells In Numbers With Apple-script?
Mar 1, 2012HiThe usual tale of an Applescript beginner getting lost but, I want to be able to search for a selected membership number within a Numbers spreadsheet, extract that member’s email address and send a message. I have managed to create a script that creates and sends the email but after several attempts I cannot work out how to start searching cells for a particular value and how to extract data from cells in the selected row.
Info:
iMac, Mac OS X (10.7.1)
MacBook Pro :: Merge Multiple Cells Into One Cell In Numbers?
Apr 18, 2012I'm trying to make a mailing list and take information from multiple cells in numbers and put into one cell to print. Anyone know how this is done?
Info:
MacBook Pro
OS X V10.6 Snow Leopard :: Unable To Change The Format In Cells In Numbers?
Jan 31, 2012Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12. It is quite frustrating because I did what it said to do.
View 2 Replies View RelatedApplications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers
Jul 17, 2010I'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"
Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?
Mar 24, 2009See 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.
Applications :: Delete Cells From Excel Sheet
Feb 6, 2005I was updating sheets for the new year. I keep lot of my template the same from year to year, just deleting the items in cells and starting over. It?s easy when using the PowerBook from a keyboard. The Delete key does the trick, but how do I do it from the Powerbook keyboard. The Delete key just does one cell at a time?
View 6 Replies View RelatedApplications :: Cannot Format Cells In Excel Files Sent Via Entourage
Jun 10, 2009When I get sent an excel file (.xls) I open the attachment, however if I choose Open it doesn't let me format the cells but does let me write and save. If I choose Open and Remove Macros it opens in Read Only however it does let me save whatever changes I've made but still won't let me format the cells. Is there a way to format the cells of these files that get sent to me via Entourage. Even if I save them to desktop I get the same results.
View 1 Replies View RelatedApplications :: Delete Duplicate Cells In Excel 2008?
Jul 19, 2010does anyone know how to delete duplicate cells in Excel 2008 for mac?
View 3 Replies View RelatedMac Pro :: Can We Use 12 Cells PRO Battery To Replace 6 Cells Battery
Apr 14, 2010In order to get more run time out of door, the better way is using high capacity battery. Some ask me if we can use 12 cells Mac Pro battery to replace 6 cells battery.
View 1 Replies View RelatedMacBook Pro :: Change India Numbers To Arabic Numbers?
May 22, 2012how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
Applications :: Using ITune Filenames / How To Rename
Sep 7, 2010So I downloaded a bunch of audio in .mp3 format that I drag onto iTunes.
The filenames are like 213.mp3 or 23.mp3
When I plugin my ipod, the filenames are all wacky looking.
Why is that? (note: the .mp3 audio is not in english)
Can I rename them so they show up as 213.mp3 on my ipod also?
Applications :: Need To Rename MP3s (Artist / Album)
Aug 25, 2010I'm not sure why I'm having such a hard time finding an app to do this, because it seems like a common task. I have a bunch of MP3 recordings that are untitled. They will all have the same artist and album name. Rather than import them into iTunes individually and entering the same information over and over again, I'd like to find a program that will allow me to assign an artist and album name (and maybe other info, like genre, etc.) in a batch prior to importing the files into iTunes.
View 7 Replies View RelatedApplications :: Delete / Rename Files From Old Backups?
Sep 1, 2010is there a way to delete some files or rename files from the old backups?
View 5 Replies View RelatedApplications :: Automator - No Option To Rename Completely
May 17, 2009I'm using Automator to rename 200 odd pictures I have taken to the date the photograph was taken.
I have tried renaming them, sorting them then reloading in other applications and trying to save.
I see no option in changing the name to a new name, it just adds to the existing name and the filename is now massive. I did not copy originals. There must be something I can do. I tried a program called file merger (something like that) but same sort of thing happened. I have tried around ten fee downloads.
Applications :: Unable To Rename Email Accounts
Feb 2, 2010It's more of an annoyance than a problem, but it seems in mail, I am unable to rename my email accounts, to something better than the email address. The rename selection is greyed out in the menu.
View 2 Replies View RelatedApplications :: ITunes - How To Rename Files Correctly
Feb 15, 2010Which method / script / program will rename your song's file names so iTunes will still know where they are?
Normally when renaming files you will have to re-locate the files to remove the exclamation marks.
Applications :: Using Automator To Rename Pictures - Files Out Of Order
Aug 26, 2007I'm attempting to use Automator to rename picture files. I select "Make Sequential" and put the name in that I want. However, once everything is completed my pictures are not in the same order they were out of the camera. I like how my camera imports the photos in the order that I took them. Now when I look through my pictures my vacation is completely out of chronological order. How do can I set Automator so that this does not happen in the future?
View 2 Replies View RelatedApplications :: Getting A Percent In Numbers?
Mar 8, 2010I'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 RelatedApplications :: Keep Blank Cell In Numbers?
Oct 4, 2010The 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 RelatedApplications :: Creating Graphs In Numbers?
Oct 19, 2010I 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.
Applications :: IWorks 08 - Numbers Freezing?
Jun 30, 2008I'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.
Applications :: Using Numbers For Accounts Receivable
Feb 13, 2009I 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 RelatedApplications :: Unable To Use Numbers Formula
Mar 14, 2009I'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.
Applications :: Finding Mac Numbers Formula
May 27, 2009I 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 Related