I 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 RepliesI 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 RelatedWhat is the shortcut for copying cells in Excel using my MacBook Air? On my PC it was control isert.
Info:MacBook Air
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 running Excel 2008 on my MacBook Pro. I'd like to conditionally format some cells in a single column with a condition format like: <COndition 1> AND <Condition 2> AND <Condition 3> However, the (paltry) help seems to suggest that I can only do a logical OR of the conditions. It says "If more than one condition is true for a cell, Excel applies only the formatting of the first true condition to that cell."
Although that is a bit vague, I certainly can't get it to do logical AND through the graphical interface. Google has failed to find me the answer. Sniff.
I have loaded windows 7 and parallels. I want to load MS office so I can send properly formatted excel and doc files to my client. They say the numbers conversion does not translate well to Excel and pages to word. Do I load MS Office in the windows OS? How can i access the numbers file in the Mac OS to use in the Windows OS on Excel? Is this a better option than loading Office for Mac? I need the formatting that I put into the excel file lto hold.
Info:
iMac, Mac OS X (10.7.3)
Whenever I try to manipulate a chart in Excel, my formatting palette will not open all of the way? The formatting palette opens completely in Microsoft Word.
Info:
MacBook Pro, Mac OS X (10.5.8)
I'm doing a paper in Office 2008, and need some charts for better visualization. I want to have some graphs showing the numbers of listeners of ten different radio stations by columns.
To provide good labeling I thought about the names of the radio stations under the chart, but horizontally it's quite a mess, vertically is hard to read. So is it possible to orientate the labels diagonally, maybe sixty degrees or see instead of the pre formatted settings of 270 degrees? I couldn't find definite answers via Excel help or even Google. ("excel chart labels orientation").
I start my Macbook Pro Retina Late-13' Microsoft excel and word always open, I thought this was to do with the login items but when I go to it only chrome helper is ticked and Excel and Word are not there. Is there a option in word/excel to turn this feature off?
View 1 Replies View RelatedMicrosoft word and Excel freezes when we try to save. They had been working fine until now, and just developed this problem. We cannot use the programs.
Info:
iMac, Mac OS X (10.6.8)
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 RelatedIn a previous contact software program I have used for years, the first letter of names, streets, and cities, were automatically capitalized as I typed them in. Unfortunately, that software does not work under Lion and the developer is out of business. Because of that, I am trying to convert to Address Book. I can't find the ability to have that same thing happen in Address Book. Is there something I can turn on in Preferences or some other obscure window? My old contact software also automatically filled in cities, names, or states that I previously entered. Great time saver but doesn't seem to exist in Address Book.
Info:
Macbook Pro, Mac OS X (10.4.10)
I don't know if this is properly autofill or autocomplete - the two overlap too much anyway so I'm not wasting brain cells trying to come up with a distinction that makes sense to non-engineers. ANYWAY. Here's the point.
I'm on my bank website. My login is xtnjohnson -- just like here. Only I mistyped it once, so in autofill/autocomplete (whichever it is), I get a little drop-down showing two options: xtnjohnson or xtnjohson.
I want to delete only the second option. I recall at sometime finding a very simple way that involved highlighting the offending entry and hitting either control-delete, shift-delete, command-delete, or function-delete, only I can't seem to get any of those combinations to work. And of course I can't find the thread anymore.
The solution did *not* involve dealing with the autofill preferences in *any* way -- I've seen that option and it doesn't help (a) because there's no quick way to find the website where the problem is occurring (my list is long), (b) even when I go through my list, I don't see my bank's url, (c) the place for entering my login appears to be in something like JavaScript, so I'm not sure it'd be tracked in one of those lists, and (d) I don't know that this is properly an "autofill" problem anyway.
Info:
Safari 5, Mac OS X (10.7.4)
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
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 RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies View RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
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.
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 do I write a formula to add selected cells?
Info:
iMac
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)
I'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
I 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 recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies View RelatedEvery 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 Related