I just got a new aluminum keyboard for my Mac Pro. Since I started using it I have noticed one peculiar issue. When I use Excel, the arrow keys no longer move from cell to cell. Instead, they shift the whole spreadsheet. It's not a huge deal, but I think I should be able to select cells using the arrow keys.
The keyboard sticks while using Excel in MS office 2004. This is a very odd situation. I have a user that when she is working on her computer, the keyboard will stick when she is working in Excel. The keyboard is working as usual when she is in any other apps on the MacBook. The MacBook is running Leopard 10.5.6(?). I have not come across any other desktops, laptops running Excel or any other OS that have encountered this.
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!!
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
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.
When 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.
Recently 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
1. 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.
Yesterday I had a Leopard software update which included new keyboard firmware. I did the update and the keyboard continued to function normally. This AM I booted my MacBook Pro and discovered the keyboard no longer responds to inputs. However, the MB does responds to an external USB keyboard.
Now I don't know if I have a sudden hardware problem or the MB keyboard is not working as a result of the firmware update. Has anyone else experienced a similar problem? Can I go back to the earlier revision of the keyboard firmware?
Hmmm - while writing this I just realized I have a bootable image of my system made a few week back on an external drive - I'll have to try it.
I just bought a new 2012 aluminum Wireless keyboard and the function keys do not work properly. I am currently running OS 1.5.8. I would expect most keys to match the icons on the keyboard. I do not want to upgrade to Snow Leopard or Lion. I have installed an aluminum keyboard upgrade 2.0 and this did not help. I just want the the keyboard functions to match the icons on the keyboard.. Volume up...volume down...
i am running awin7 in bootcamp. in this bootcamp i am using outlook 2010. i cannot create an "@" in emails. is there any shortcut to create an @? is there any combination to create the windows "alt gr" on the macbook air keyboard?
I used to just closed my Mac instead of pressing the shutdown button; I tried this time but I cannot shut it down anymore, also my keyboard cannot control the volume or turn on the keyboard-light. Also I remember there is like a back-up shortcut (or something like that don't know what is it exactly named) consisting of three keyboard button.
So my friend was using his MacBook and went to do something else. He came back and the screen was black, he hit space and nothing, tried the trackpad and nothing. He restarted by holding the Power button, and it go to the log-in screen, but he can't type anything, or use the trackpad. He has tired restarting several times and no luck. He also tried an external Keyboard/Mouse and that didn't work.
He did plug in a Flash drive and the light turned on, so the USB ports are at least getting power, but nothing is working.
I just got a generic usb keyboard to use with my mbp as schoolwork is taking its toll on the keys and I wouldn't mind preserving it a little better.
This keyboard is the dynex from bbuy that's labeled in windows crap but was cheap and works fine on the mac. Unfortunately, everytime the mbp comes out of sleep, the keyboard is unresponsive and i have to set it up again in settings.
Just hoping there's a simple fix and that it's not terminal
I bought a new i7 iMac about two months ago and love it but the Bluetooth keyboard it came with recently started acting up. It randomly disconnects and when it does it will type whatever letter I last hit on the keyboard repeatly.
I'm a bit of a noob when it comes to this, but does anyone have experience with creating keyboard shortcuts? I would like to edit my o , u , and a keys to create ??d 䠨alt + u = ? + o = ?tc...) Is this possible? It's a bit annoying switching between the different keyboards when I would like to make an umlaut.
My desk configuration for my imac includes a keyboard tray. I am contemplating just not using it, however it really does put the keyboard in a more natural place for me to sit correctly. If I want to use the wired keyboard though, I will obviously need some type of usb extension. I have read these came with the old keyboards, but they don't come with the new ones. Does anyone know where I can find one that is compatible with the aluminum keyboard? Would the extenders that came with the old Mac keyboards work (in case i can find one on ebay or something)?
I've just bought a Mac mini to use as a media centre, and I picked up the Apple wireless keyboard and mouse while I was at it. It wasn't until I got home that I read the "requirements" section on the side of the mouse and keyboard boxes, where it states that an existing keyboard and mouse are needed for setup.
I have a USB mouse, but no keyboard (my other Mac is a MBP), and nowhere to borrow one from (all my friends have laptops).
I'm thinking of buying a MacBook but I have one reservation. I'm moving from a Powerbook 12"...
What's the consensus on the MacBook keyboard in terms of ease & comfort of use? I write for a living so a good keyboard is pretty essential. I've always been mostly satisfied with my powerbook keyboard, it's pretty comfortable although I occasionally mash a neighbouring button with my big clumsy fingers. The MacBook keyboard looks a little... weird. How is it?
I just got a generic usb keyboard to use with my mbp as schoolwork is taking its toll on the keys and I wouldn't mind preserving it a little better. This keyboard is the dynex from bbuy that's labeled in windows crap but was cheap and works fine on the mac. Unfortunately, everytime the mbp comes out of sleep, the keyboard is unresponsive and i have to set it up again in settings.
Just hoping there's a simple fix and that it's not terminal
I alternate between French and English regularly when typing, but every time I have to go to System Preferences (or add an ugly flag that does not match the color-scheme to the status-bar) and change the language. Is there a way to have a keyboard shortcut that switches between two keyboard shortcuts?
Bluetooth says my keyboard is paired, configured, and connected (and it works).Keyboard under System Preferences says "no keyboard found" and it continues to search for the keyboard. I have rebooted and also deleted and added the keyboard. Should I be concerned? Does the iMac need service ?
i need this addon for excel which is regression software or something for excel. I cannot find this addon for the mac version and i do not want to use a stupid pc for excel. Any addon that is like regression? i need it for school.
i believe its called rinlex cause in my syllabus it says
In addition to Microsoft Excel an Excel add in called Rinlex is available on the web page and also in the computer lab.
I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.
There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.