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 Repliesdoes anyone know how to delete duplicate cells in Excel 2008 for mac?
View 3 Replies View RelatedWhen 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 RelatedI'm trying to convert an Excel spreadsheet into a PDF form. The spreadsheet is set up with 6 categories on the top and then numbers on the horizontal axis to represent employees. I need to be able to convert these cells into fillable PDF columns in Adobe Acrobat............
View 3 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
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 Replies View Relatedif you have more than one sheet in a Numbers document, is there a way to EXPORT just one sheet to Excel? There is no option to do that under the Export feature. The alternative is to copy the one sheet into a blank new numbers document then export.
View 5 Replies View RelatedExcel opens up a gigantic size blank document anytime I launch it. I gather there is no way to disable it giving me a (useless) blank document. But is there a way to not make the stupid document take up 90% of my screen?
View 17 Replies View RelatedI want to copy formulas only from a previous worksheet to create a new worksheet. I am using this to do monthly accounts for 2012. Everytime I cut and paste the formula, it links it to where I copied it fror.  I am worrried about saving it as I do not want to make any changes to the previous months. The person who created the worksheet is not available to do this for me.Â
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 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...
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 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 RelatedI 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 RelatedDoes anyone know of a program that can take an audio sample of piano and turn it into sheet music? I don't know if this will help, but here's the peice I'm interested in turning into sheet music: Dave Matthews Band's #41 mp3. This is for myself only, and I don't plan on sharing this. I understand this is the artist's work, and he should own the rights to it.
View 8 Replies View RelatedSo I'm working this job where I need to keep track of my hours. I have rows of 4 columns. A is just the date and other random task info. B is the starting time, C is the ending time and D should be how many hours I worked on that particular day. The only problem is, I can't for the life of me figure out how to get Numbers to add up my hours automatically!! The SUM function just gives me the red triangle of WTF. It's probably something really simple but this is my first attempt at spread sheeting so easy on me.
View 3 Replies View RelatedAs the title says, I just can't get Preview.app to print a 33 page PDF using 2 pages per sheet in the correct order. It will print two pages per sheet of paper, but page 1 will come on the right, 2 on the left, 3 on the right, etc. I tried every possible combination in the "Layout" menu to no avail.
View 5 Replies View RelatedI have an excel file that I can't delete - any suggestions on how to get rid of it? I can't move to trash, can't open, can't do anything to do. The message I get is "the item B4D19F00 can't be moved to trash because it can't be deleted".
Info:MacBook, iOS 5.0.1
I have an excel spreadsheet that I can't delete. It says that it is being used and I can't delete it.
View 7 Replies View Relatedhow do i delete word and excel files i no longer need? i have tried to highlight and press delete and i have tried the drag and drop and that hasn't worked for me either?
Info:
iMac (21.5-inch Mid 2011), iOS 5.1
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 RelatedWhen I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies View RelatedI just upgraded my operating system and added more memory to my imac. Word and Excel cannot be used with Lion. How do I delete these from my computer and is there a way to make sure I am optimizing the space on the hard drive?
Info:
iMac, Mac OS X (10.7.3), added more memory
MS Excel put two files on my desktop that cannot be opened, moved or trashed. They are not files I created, and are identified by a random series of 8 letters/numbers. When I try to open or move them there's simply no response. When I try to trash them I get the message: "The item 'xxxxxxxx' can't be moved to the Trash because it can't be deleted." I had this same problem a couple years ago and I called Apple Care and they walked me through how to delete the files. Now my Apple Care is expired and I'd rather not pay $50 to resolve a rather simple problem. It's just that I can't recall the procedure for deleting these files. how to get these files off the desktop?Â
View 3 Replies View RelatedWhenever I delete an email using iMail, it doesn't delete from my gmail account when I would just use the regular browser to check my mail. Is there a way to delete emails both off of iMail AND from Gmail so it does not appear when using a browser to check my mail or on another computer?
View 1 Replies View Related