MacBook Air :: Shortcut For Copying Cells In Excel Using It?
Jun 21, 2012What is the shortcut for copying cells in Excel using my MacBook Air? On my PC it was control isert.
Info:MacBook Air
ADVERTISEMENT
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 RelatedSoftware :: Excel Freezes When Auto Formatting Row Of Cells
May 31, 2010I 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 RelatedMacBook Pro :: Word Shortcut To Top Of The Document/ Excel F2?
May 24, 20121. In MS Word on PC you can get to the top of a document using a shortcut ctrl+pgup. How can can this be achieved in Word under Mac?
2. In Excel on PC you get to the contents of a cell pressing F2. What is the method in Excel under Mac?
Info:
MacBook Pro
Applications :: Shortcut To Paste Special In Excel 2011
Oct 28, 2010It's supposedly the shortcut to Paste Special in Excel 2011. It's not working for me. Maybe I'm hitting the keys wrong? You can see it if you go to the Edit menu. thank you.
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 :: 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)
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
Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?
Feb 6, 2009I 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?
Applications :: Turning List Manager In Excel Off / Moving Columns In Excel?
Apr 13, 20101. 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...
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 View RelatedApplications :: Excel: Pulling Weather Into Excel Spreadsheet?
Oct 21, 2010I 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 RelatedApplications :: Excel: Pulling Weather Into Excel Spreadsheet??
Oct 21, 2010I 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 RelatedApplications :: 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.
Intel Mac :: Write A Formula To Add Selected Cells?
Mar 25, 2012How do I write a formula to add selected cells?
Info:
iMac
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 RelatedOS 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)
Intel Mac :: Make Text Cells On A 45 Degree Angle?
Jun 21, 2012I 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)
Applications :: Difference From MAC Excel 08 To PC Excel 2003
May 22, 2010I 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 RelatedOS 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 :: Using Mac Excel To Windows Excel?
Nov 10, 2009When 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 RelatedWindows On Mac :: F2 Key In PC Excel Missing In Excel For Mac?
Mar 24, 2010Recently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac
Or, more specifically , I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell.
I know I can do the same by clicking in the "formula builder toolbar" but I don't wan't to have to reach for the mouse each time... does anyone know if Excel for Mac has a similar feature / keystroke to use
OS X :: Blank Cells Missing In Print / Unable To Print Grids
Nov 24, 2010I'm trying to print an Excel 2004 .xls spreadsheet file where I'm using to record attendance for the class I teach.I have my main Column A with Rows A-X and it shows up fine, I imagine because there is content in the boxes.
But I also have Columns B-L and rows A-X with nothing in their cells, but when I print it, they won't print.I need these blank because I'll check them off if the child in the first column attended the lesson. How do I make it so my many blank cells will print as well?
OS X :: MAC Excel 08 Versus PC Excel 07
May 30, 20101. What are the file extensions for MAC excel? Do they differ from PC excel?
2. What are the differences between MAC excel 08 vs PC excel 07?
I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my MAC environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences but I am not tech/program savvy.
MacBook Pro :: Copying Hard Drive To New
Oct 25, 2010I'm upgrading to a MacBook Pro soon from my current late 2007 Macbook. I just want to know what is the exact procedure on copying the hard drive on my current MacBook to the MacBook Pro I'm getting soon? I want it so it is exactly the way my Mac looks right now. I've got everything backed up on to an external hard drive ready to use.
View 8 Replies View RelatedMacBook Air :: Copying Files From IPhone?
Jun 9, 2008So i copied all my itunes music and photos to my iPhone. Can I hook it to my MBA which is coming soon and transfer everything over. including purchased music?
reason being is I sold my MB and I don't have an external drive.
