MacBook Pro :: Can't Insert Any Exponential Formulas In Excel
Jun 16, 2012I can't insert any exponential formulas in my excel. The ^ symbol (shift 6) does not work.
Info:
MacBook Pro
I can't insert any exponential formulas in my excel. The ^ symbol (shift 6) does not work.
Info:
MacBook Pro
I write reports and I use office for mac because at work I need to read the reports I write at home with macbook. I use tables on microsoft word that are connected to excel. When I click on them the excel opens to may introduce formulas and text. If I close excel the table I modified on excell lays on word with the rest of the text of the report. My doubt is when I add cells to the table on excel....I can't visualize them on word...
Info:
MacBook Air, office for macbook
I'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data.
As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock.
Now I know that I can use an array formula to come up with a way of finding out the number of red products that are �2 and have 2 items in stock - unfortunately I am not sure how to do this!
I am using MS office for mac and I can't figure out how to insert a text box into a chart for Excel.
View 1 Replies View RelatedI have been trying to insert a simple monthly calendar into an excel spreadsheet, but cant find a way to do this on the mac version that im running. Any hints would be great. Idealy i would like to be able to just insert a calendar for that month but if i had to insert the whole calendar each time that would be fine too
View 2 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
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 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 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 RelatedRecently 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
I was trying to watch a dvd through my macbook! But I dont know why I cant insert the CD anymore it couldn't go inside?
View 8 Replies View Relatedi cannot insert any cd in mac whenever i insert cd it returns back
Info:MacBook, Mac OS X (10.1.x)
I have a keyboard key that popped out, could someone help to tell or show me how to put it back on?
Info:
MacBook Pro
i cannot insert a CD into my macbook. last time i burned CDs about a month ago, all was fine. there is no CD currently in the drive.
Info:MacBook, Mac OS X (10.6.8)
When I insert an SD card....nothing happens. Am I doing something wrong? Or do I bring this thing in?
View 4 Replies View RelatedSo, I was using my UB MacBook earlier today. I had a CD in the superdrive. I was shutting down the computer, and all of a sudden, as the screen was going black, the disk in my computer came out half way and the superdrive made a noise. I quickly restarted my computer to see what went wrong. I tried putting the CD back in, it didn't work. You all know how the slot loading superdrives suck in CDs. I now slide the CD in, and it won't get sucked in. In fact, the whole CD won't even go in. A little bit of it still sticks out. So now I'm stuck with a dead superdrive wondering what to do to fix it.
View 12 Replies View RelatedWhat happens if insert disk upside down
View 6 Replies View RelatedWhen i insert a dvd it says not supported disc. I copy the movies on my pc and when i open them again it says : The document could not be opened. The movie is not in a format that QuickTime Player understands.You may need to install additional software to open this type of file. i have other programs such as DVD player but it still doesn't open.
View 4 Replies View Relatedif it is possible to insert a real fraction in Pages 09?
Info:
MacBook Pro (13-inch Late 2011), Mac OS X (10.7.3)
When I insert a CD-R my MacBook ejects it.It never shows up in the finder or on the desktop. I have no problem with a DVD.
Info:
macbook
I've always taken the insert key on my PC at work for granted. I just discovered that there is no insert key on my MacBook Pro. What serves at the insert key?
View 1 Replies View RelatedTrying to figure out why my new 2010 MBP is getting kernel panics. As a Mac newbie i consulted the manual + internet. Apparently if I hold down the 'D' key whilst booting then the machine should start the AHT, but mine doesn't.I need to insert the Applications DVD in order for the AHT to start.Is there any way I can install the AHT? Was it removed when I reinstalled SL?I also wish that Apple added some more information to the startup screen (like most BIOS based computers) - e.g. press 'C' to boot from CD ROM, press 'D' for AHT etc, because right now there's just no feedback or information for the user :-s
View 3 Replies View RelatedI insert a DVD in my mac book pro, the dvd player pops up but i cant get the player to play.
Info:MacBookPro
When I insert my SD card it isn't showing up anymore. How can I fix it?
Info:MacBookPro
just got the computer 2 weeks ago had a problem already went to apple they wipped out my computer it always worked before now it wont work
View 12 Replies View RelatedI have been trying to find online sites that tell how to do this, but have not found any resources.
So how can I insert a timer into an applescript dialog?
I've tried finding Xcode examples of this, but no luck.
When I try to insert a text box on PowerPoint it won't let me type in it or if i try to click on it it just disappears.
Info:
MacBook Pro, Mac OS X (10.6.8)