MacBook Pro :: In Excel How To Enter Multiple Paragraphs In One Cell
Feb 3, 2012In Windows I use <alt><enter>, but that doesn't work on my MacBook.
View 2 Replies
ADVERTISEMENT
Applications :: Notify If Forget To Enter Date In Specific Cell
Apr 1, 2009I am trying to figure a way to notify me when I forget to enter data in specific cells, that need to be filled in. I included a screen shot. What I want it to show is basically fill in the whole row in red or another color. When I forgot to input data. Is there a formula?
View 2 Replies View RelatedMacBook 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 :: Click 10 - 20 Times In New Cell - Excel
Jan 30, 2010In excel, whenever I try to type in a cell, I must press the first key 10-20 times before it shows up. It doesn't show up delayed, as in it shows up with 20 a's, it just shows one. Once the first key shows I can type anything else in that cell, but when i hit an arrow key or click to go to another cell, I have to hit the first letter 10-20 times again. I have to click 10-20 times to click into a new cell as well. This just started today. I've tried restarting excel a few times, but It didn't help.
View 5 Replies View RelatedOS X V10.7 Lion :: Border Color Of Active Cell In Excel
Jul 6, 2012Is there a wayof changing the color of the border of the active cell in excecl?
I have a very difficult time seeing the pale green. I waste a fair amount of time modifying formulae because I'm in the wrong cell. Making it a different color or making it more vivid, or bold, would be great.
Tried going into Apple preferences and Excel preferences, but did not have any luck. Maybe I just didn't do the right thing once there.
Info:
iMac, Mac OS X (10.7.4)
Applications :: Excel - Number Hidden Beneath Cell's Displayed Text ... Possible?
Feb 21, 2010Is there a way to have a cell display text, but behind the text is actually a number figure that I can ask Excel to use in calculations? I'll explain what I mean to give you a visual so you'll understand what I'm trying to do. I want to create a monthly budget in an Excel spreadsheet. I'll have one row for each day of the month, and maybe 3 or 4 columns for in which to put expenditures for each day.
Let's say on the 4th of the month I have a Visa bill due, I usually put gas in my car and I pick up some Dry Cleaning. I'd like to be able to type Visa, Gas and Dry Cleaning within the row of cells for the 4th, and have the dollar amounts for those expenditures hidden beneath the text. Then I'd do a summation formula in the last column to tabulate all of the hidden dollar amounts to give me a total for that day. This way, I can see a total expenditure figures for that day (in the summation column) and what the money went to, without having to do the spreadsheet the old-fashioned way of putting the Text in one cell and the dollar figures in an adjoining cell (which in this case wouldn't work in a columnar sense since the text cell would have to be either above the dollar cell, thus making the text cell in the previous day's row...or, putting the text in say, cell B2, and the dollars in row B3, and doing the same for multiple charges per day, which would make for a very wide spreadsheet.
OS X Yosemite :: Having To Enter Apple ID And Password Multiple Times Since Upgrade
Dec 10, 2014Since upgrading to Yosemite I am being asked by Apple apps to enter my password much more often than before, to the point that it's annoying. The reason for this usually is not apparent, and happens even though I'm using only my home computers, from which I've signed in many times previously and which should be recognized by Apple, and on which I have elected to stay signed in. Worse, oftentimes when I sign in, the dialog box refreshes, with the PW field empty, giving no indication why my entry was not accepted.
Sometimes I'll have to enter my PW two or three times before it's accepted, all with no alert that the ID was not recognized or the PW was incorrect. It's like the system is trying to call my bluff or having me say it three times before it'll believe me! This happens so regularly that now when iTunes or Mail, for example, asks for my PW, I enter it very slowly and deliberately, so I know I'm not making a typo. Besides, I never experienced this behavior with any prior OS X version.
Is this a new security step—the owner of the Apple ID will continue to enter repeatedly what he knows to be the correct PW even when it's not initially accepted, whereas a hacker will move on to a new guess after a first attempt with the correct PW is rejected?
Info:
MacBook Pro (Retina, 13-inch, Late 2012)
Applications :: Excel 08 Formula Builder With Multiple Worksheets
Apr 3, 2009I am currently using excel 08 and have made a workbook with multiple worksheets in it. Each worksheet contains information on multiple products, such as description, UPC, cost, retail, sale cost, sale retail, how many items sold during sale, etc. Sales are two weeks, so every two weeks, I add a new worksheet with new information for sales I will be running a few weeks down the road. I would like to see if there is a way that I can have excel look through the past worksheets so when I enter a UPC into the new worksheet, there would be a column at the end that would take the average items sold during past sales.
For example, if I want to put UPC 1234500000 on sale in the new worksheet, that excel would look at past times I had 1234500000 on sale and take the average of how many sold during past sales and enter that number in a cell on the new worksheet. I don't know if this is relevant or not, but Column D is where I enter UPC info, Column P is where I put how many sold, and Column Q is where I want this average sold to appear (no matter what worksheet).
Applications :: How To Attach Multiple Excel Attachments When Sending Email?
Mar 21, 2009My first posting. Please forgive my simplistic question, but I need some help.I use aol. When sending an email on my MAC, I'm trying to attach multiple excel (or word) files - let's say 10 excels in a row.So I click on "attach files", and a box opens up, showing all of the files on my MAC.On a non-MAC computer, I'd select the first file, then press "shift", and then use my down arrow to select the next 9 files. That doesn't work on my MAC.How do I attach 10 consecutive excel files when sending an email?
View 2 Replies View RelatedOS X V10.7 Lion :: Create A Multiple Find And Replace For Excel In AppleScript?
Apr 15, 2012I have a large dataset in Excel that I have to do a multiple find/replace in (changing USPS state abbreviations to their full names). In searching the Microsoft boards--I was directed to use Applescript, and even the documented help with Excel was recommeding this. Unfortunately, there wasn't much help potinting me in the specific direction I needed.
View 2 Replies View RelatedOS X V10.7 Lion :: Microsoft Office Excel And Word Opens Multiple Documents?
Mar 28, 2012When i try to open a specific file in excel or word, very often a number of other recently used documents open up too!All documents were saved prior to closing at last use. Does anyone know how i stop multiple documents from opening up?iMac mid 2011,Office:mac 2011 "WPX" Home and Student all have up to date software?
Info:
iMac (21.5-inch Mid 2011), Mac OS X (10.7.3)
OS X V10.7 Lion :: Microsoft Office Excel And Word, Opens Multiple Documents
Jun 5, 2012When i try to open a specific file in excel or word, very often a number of other recently used documents open up too!
All documents were saved prior to closing at last use. Does anyone know how i stop multiple documents from opening up?
iMac mid 2011 Office:mac 2011 "WPX" Home and Student all have up to date software
Info:
iMac (21.5-inch Mid 2011), Mac OS X (10.7.3)
Final Cut Pro X :: Importing One Hundred Paragraphs Of Text
Sep 9, 2014we have a one hour audio file and we need to place text on the screen.
is there anyway to import a .word doc or text doc and have each paragraph appear as a separate text block in fcp?
we are trying to make a slideshow- sort of like keynote or powerpoint.
but we cant use those packages because we have lots of text....
anyway long story short, what are the options for importing paragraphs of text into fcp or motion?
Info:
Final Cut Pro X, Mac OS X (10.4.6)
Applications :: IWork - Change Spacing (single - Double) Between Lines In Paragraphs?
Sep 12, 2010I need to know how to change the spacing (single, double, etc.)between lines in paragraphs. I just bought a mac and am new to this stuff
View 3 Replies View RelatedApplications :: Adding An Extra Line Between Paragraphs In A Double Spaced Paper?
Feb 24, 2009MS Word is adding an extra line between paragraphs in a double spaced paper. How did I get rid of it?
View 5 Replies View RelatedMacBook Pro :: Can't Access Pictures From Cell Phone
May 27, 2012I can't access my pics from my cell phone... Firewall?
Info:
MacBook Pro
MacBook Pro :: Print Cell Borders Using Numbers 09?
May 30, 2012How can I print cell borders using Numbers 09?
Info:MacBook Pro (13-inch Late 2011), iOS 5.1.1, Numbers
MacBook :: Can't Connect To Internet With Tethered Cell Phone
Dec 29, 2009I am in India with a cell phone that has an unlimited data plan and legally allows tethering and has blue tooth. I am trying to connect to the Internet through the cell phone using blue tooth to my Macbook. I can "pair" with the cell phone but cannot connect. My new Macbook is running Snow Leopard
I can see the Nokia 7210 by clicking on the bluetooth icon upper right on the Mac. I can see the Macbook in the cellphone and click on connect in the cell phone.
Then the cell phone says "connecting to Macbook" followed by "service not supported by other device".
I have clicked on every combination I can find in blue tooth preferences on the Mac but can't get it to connect. Under blue tooth in the Mac it says paired but not connected.
Sometimes the Mac asks for a user name and pass code for the cell phone and it also asks for APN whatever that is. The owner of this cell phone tells me there isn't any username or passcode necessary and he has successfully connected through Windows notebooks without so using.
MacBook Pro :: Cell Phone Icon Has Disappeared From Desktop Screen?
May 20, 2012I have a mytouch 4g cell phone with adapter cable, that use to be working just fine with my macbook pro. The cell phone icon would show up on my screen, and I could transfer pictures from there. Out of the blue, the icon for my phone is no longer showing up on the screen , therefore, I can no longer access pictures and tranfer them to my computer anymore.
Info:
MacBook Pro, Mac OS X (10.6.8)
OS X :: Bizarre Occurrence - Cell Phone Ringtone Coming Through Macbook Speakers
Apr 17, 2010I'm using a Macbook pro OSX 10.4 Tiger, and have been experiencing a very bizarre, spooky, specter-like occurrence happening as of late when I watch streaming videos off common site such as Hulu. I'm using the newest version of Firefox and my roommates and I have wireless internet with various routers rigged sort of haphazardly throughout the apartment. Sometimes whenever my cellphone alarm goes off, or an incoming call comes in, the ringtone will come through the speakers of my computer! This takes place even if I'm on a different floor or in another room. It has even happened when my cellphone is put to silent! Can anyone explain or speculate why this is happening? It always freaks me out, and won't go away unless I close the video or browser.
View 1 Replies View RelatedMacBook Pro :: Syncing The Contact Information From Samsung Evergreen A667 Cell Phone
Nov 11, 2010My previous phone literally broke and I didn't back up my contacts. So I'm retyping them. I don't want to make that mistake twice.
I plugged in the phone to my MBP but I have no idea what to do.
My phone prompts me to choose Media Player, PC Studio, or Mass Storage. I don't have Media Player. So which do I pick and then what to do on the MBP?
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 :: 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 RelatedMacBook Pro :: Merge Multiple Files And Multiple File Types Into A Single PDF?
Jun 20, 2012Can I merge multiple files, and multiple file types, into a single PDF with my MacBook Pro?, Can I merger multiple files, and multiple file types, into a single PDF with my MacBook Pro?
I need to combine word docs, .jpgs, .PDFs, .pptx files from multiple sources into a single PDF. In the past I've used software such as Nuance but I'm wondering if there's something in the MacBook Pro OS or applications that support this function.
Info:
Mac Pro, iOS 5.1.1
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 RelatedApplications :: Keep Blank Cell In Numbers?
Oct 4, 2010The v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
View 3 Replies View RelatedIntel Mac :: Connect The Cell Phone?
May 9, 2012I have a Samsung Evergreen cell phone and I accidentally erased a picture I need for work. The picture was on the phone's memory, not an SD card. I am trying to connect the phone to my iMac via a usb by mini usb connection........it does not appear anywhere in Finder. I am trying to connect it so that I can search for software that will scan deleted files on the phone.
Info:
iMac, Mac OS X (10.6.8)
Applications :: 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 Related