MacBook 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)
How 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)
How can I print cell borders using Numbers 09?
Info:MacBook Pro (13-inch Late 2011), iOS 5.1.1, Numbers
Does anyone know why copying borders from one cell to another in Numbers doesn't work? It's pretty inefficient creating borders for each cell all over the place.
View 3 Replies View RelatedI'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
In 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 RelatedIs there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)
I 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.
I'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).
In 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 RelatedHiThe 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)
Every 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 Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
In 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 RelatedI really like the way Quicktime X looks, with no controls or borders when playing a video.
View 1 Replies View RelatedWhat is the shortcut for copying cells in Excel using my MacBook Air? On my PC it was control isert.
Info:MacBook Air
Is there a way to kill the white border that Snow Leopard puts around new image icons? They show up on the Desktop and in Finder windows. Also, now all new raw icons show as generic icons in the dock pop ups. And don't get me started on dumping prefs in Image Capture to set it to open images after download.
View 11 Replies View RelatedSome of you may have noticed, but when you save an image with PS, there is no white border around the icon, unlike the default OSX. So I was playing around in Photoshop's preferences, and I figured out how change it to match with other images. To do this, go to Photoshop, then go to Photoshop's preferences>File Handling, and Check off "Never Save" in "Image Preview".
View 1 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"
I am trying to print an 11.98x17.97 image on a 13x19 sheet. I specify .51" borders top and bottom, and .52" right and left.
Instead, I am getting a 7.5x10.75" printed image with L 1 1/8" + R 7 1/8" borders and T 1/8" + B 5 3/8" borders. In short, a smaller image, shoved up and left on the sheet. See screen shot below.
Same happened when I tried to print a 4x6 image on an 8.5x11 sheet, until I was told by Kirby to enter the sheet size as a standard 'letter size' sheet instead of entering a custom 8.5x11" size. Is this the same? If so, what's the 'standard' size for 13"x19"?
Info:
MacBook Pro, OS X Mavericks (10.9)
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 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 RelatedHow do I write a formula to add selected cells?
Info:
iMac
When 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 Relateddoes anyone know how to delete duplicate cells in Excel 2008 for mac?
View 3 Replies View RelatedI am just trying to alternate the row colors of excel by selecting all cells and then going to autoformat and selecting "List 1." It then takes forever to load and freezes. I have to command + alt +esc to get out of excel. Does anyone know why this is happening?! I have mac excel 2008.
View 5 Replies View RelatedI am trying to make a chart and I am trying to make the top row of colums with the information postioned on a 45 degree. How do adjust the setting in numbers or pages to accomplish this.
Info:iMac, Mac OS X (10.7.2)
I was just looking for a definitive answer on whether or not it is possible to remove individual keys on a uMBP without opening it up and dissecting the innards. I have one key (delete) that I'd like to pop off to clean.
View 11 Replies View Relatedmy cat ripped off half the keys on my keyboard and some of them I could get back on but 4 of them I am not able to fix myself and I'm wondering if I take it to Apple if they can just replace the keys (obviously they are still working they just need the top back on) and how much it will roughly cost
View 2 Replies View Relatedcan you purchase individual microsoft office programs from the app store. I was told you could when I purchased my macbook pro but can't find them.
View 4 Replies View RelatedCan individual keys be adjusted or tweaked on the keyboard to allow more even backlight to show through. Especially uneven under space bar.
View 1 Replies View Related