I would like to fill some cells in numbers conditionally with blank. These cells are in a table which is used to fill one chart. So I dont want the cells to have a value of zero. Alternatively, is there a function which returns the value in a cell?
View 2 RepliesI am working with a spreadsheet. I need to conditionally format a cell (a different color), if that cell is referenced in any other cell. I use iwork08.
View 1 Replies View RelatedThe 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 RelatedIn 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 RelatedI'm looking for a program/app that will allow me to primarily send SMS from my Mac using my current phone number. Does anyone know if anything like this exists? I can only think of something like this working in one of two ways: Sending an SMS composed on my Mac through my mobile/cell, via Bluetooth or some other method? OR Using software that emulates my mobile number to compose and send SMS?
I remember back in the day you could actually email an SMS to a phone by using their mobile number as a username and their network as the domain - e.g. 07123456789@orange.net. Unfortunately, because pretty much all the networks now provide email services too, doing that nowadays means they will actually receive an email at their online account instead of their SMS inbox.......................
I 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 RelatedIs 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.
In iWork 08's Pages application, I need a keyboard shortcut to edit the cell contents. Example: current cell contains the text "new client" -- I decide I want it to read "new clients" without typing it all over again. In Excel for Windows, I would hit F2, that would give me a cursor at the end of the word "client" and I was good to go.
View 1 Replies View Relatedget video recorded from my cell phone (motoroala Hint) imported into imovie so I can edit the video and merge clips. The file extension of the video file is .3g2 . Quicktime will play this video, but imovie apparently does not support it. I have found a number of different video apps by searching forums (iskysoft imedia converter, handbreak, mpeg streamclip, applemacsoft video converter) of which only iskysoft imedia converter does what I want to do. The only problem is the trial version does not convert audio and has "evaluation copy" imprinted into the video. The full version costs $50
View 3 Replies View RelatedMy Safari homepage is blank. Bookmarks and toolbar are there but my Earthlink page and address bar are blank. The Safari version is 3.1.2 and the OSX is 10.4.11 My Internet Explorer (which I rarely use) and Firefox are working fine.
View 1 Replies View Relatedmy Dad has to fill out some forms and they are available online in PDF format. He can edit them in Safari, but once we save the forms we are unable to edit them. The weird thing is when I first save it I could edit it, but once I saved it again it wouldn't let me change anything. This is very strange, I've tried Preview and Adobe Reader.
View 3 Replies View RelatedAm I the only one, or does the SSD fill up faster than a standard HD? Right now I of course keep my iTunes library on an external drive, and soon I will do the same for my iPhoto library as well. That said, it seems that I loose space faster than I would expect, is that how these drives behave? All I can say is thank goodness I got the 256 GB model!
View 11 Replies View RelatedI downloaded the latest tax forms from the IRS in pdf form, and filled out all my tax information using preview. When I finished, I saved the form, but all the data I entered was lost. Can you not fill out pdf forms in preview? I did find a workaround. I filled in some data, then "printed" to a pdf file, and that saved all the entered data. Any insight into this issue?
View 7 Replies View RelatedThis weekend I upgraded to 10.7.3 on my Quad-Core Intel Xeon. Add updates installed.When I open a new e-mail message window in Mail and start typing an address, the address does not auto-fill from either previous recipients or my address book. I get a spinning pinwheel that never goes away. If I drag a contact from my address book, it fills the appropriate address.How do I get e-mail address to fill?
Info:
PowerMac, Mac OS X (10.7.3), MacPro4,1 Quad-Core Intel Xeon, 2.6
I noticed that under storage details of my mac there is 25GBs of storage under "backups", what are these and how can i get rid of them? Given that this system is only 2 days old and i am using an external time machine for backups !!
View 3 Replies View RelatedAll week I have been getting a message saying my disk is almost full and to make space. I noticed that my 200gb hdd had only 92mb of available space so I decided to delete 6GB worth of stuff I didn't need that was in my download section.
The following day, I got another message saying my disk was almost full and again it showed less that 100mb available.. again I went in and deleted a bunch of stuff giving myself several GBs of wiggle room.
Two more days passed bringing me to this morning and again my HD shows less than 100MB available and this message just popped up again.
For a long time my mac had around 10 GB of space left. Then, two nights ago, I got a notice that said my startup disk was full. I deleted some stuff, a bunch of movies that I didn't know existed, and I had 30 GB of space yesterday. But now, this morning, there is only 10 MB of space left! I think it may have something to do with a file called hfamily1.dmg, which took up 10 GB of space and I couldn't delete it, but I just left it there. But even that wouldn't take up all that room! I've always been connected to the internet, and I've always had an external drive plugged in. I'm running DiskInventoryX right now, but if this problem keeps happening.
View 5 Replies View RelatedI have an Intel imac with a 2 TB SATA drive used for media  and a 251 GB drive used for applications etc . Trouble is when assessing storage on "About This Mac" it looks like 141GB of the flash drive is full of movies . Can I find a way to see what those movies are in order to safely delete duplicates or move them onto the SATA hard drive. I use apple tv to get media content from itunes but do not really know how itunes or where itunes stores the files . I'm assuming its from the SATA disk as Ihave 1.5 TB of files on there all available in i tunes
View 2 Replies View RelatedJust want to know if I can shutdown my imac without having to write everytime my admin name and password?
View 2 Replies View RelatedI 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)
The free space on my MacBook is disappearing fast but I don't know why. I am hoping someone can tell me where to start solving this problem. It must be invisible files but what can I do about it? This started after I restored from a Time Machine backup to a new hard disk after the hard disk failed (another story). The Time Machine backup was about a week old (isn't it always the case?) so I don't think it is likely that I could have restored anything that might have had anything to do with the hard disk failure. Everything seemed to be working fine, having spent hours resorting emails and trying to reconstruct files I had lost from the week I didn't back up. During that week I had bought an iPhone. When I connected it to the restored computer it deleted all the apps I had installed. Not a big problem, as I was able to track them down from an iTunes receipt and reinstall them. I then attached my iPod and the computer had to replace all the files with new ones. As there were a lot of songs and photos I left it to do this and went to bed. Next day the iPod now had newly replaced files and seems fine. But there is a warning that the startup disk is full. No new files had been put on the computer, which had about 9.5 Gb free space. I deleted some files so I could do some things with the computer to find out what was happening. The space thus freed soon disappeared. I then deleted Parallels Desktop so that I could free up more space. I now had 29.67 Gb free space. I tried searching for large files but nothing suspicious seems to detectable. By the end of the day the free space had gone down to 24.39 Gb. It now stands at 23.22.
View 2 Replies View RelatedWhen I open Mail it syncs all the messages like it should and then I go thrrough and delete all the junk emails and inbox emails that arent important. They go to the Trash folder and when I click "erase them permanently" they disappear, but then the Trash folder starts filling up with more emails and adds up to 400 every 10 seconds until around 2000. No matter how many times I select them all and click delete it just fills up again.
View 2 Replies View RelatedI'm getting messages stating "Your Mac OS X startup disk has no more space available for application memory." I've determined that my system memory is rapidly reducing after the MacBook Air is left on with only the Activity Monitor and Terminal open.
MacBook Air Stats:
11-Inch, Mid 2011
Processor: 1.8 Ghz Intel Core i7
Memory: 4GB 1333 Mhz DDR3
Graphics: Intel HD Graphics 3000 384MB
Software: Mac OS X Lion 10.7.3
My SSD drive space is rapidly reduced after the "free memory" is almost completed used - the MacBook then starts using the SSD drive as virtual memory and almost uses that space (I have a 250GB drive with 60GB available when I start the mac).Everything works great for the first 5-10 minutes, then I see the "free memory" decrese until it's down to about 30MB or so and then the SWAP used increases until my hard drive is almost totally out of space and gives me the error above. During this time the MacBook Airs little fan turns on.I can only use my Mac for about 30 minutes or so until I have to restart due to the HD being filled up by the virtual memory SWAP. The Mac is also very slow during this time as you can imagine.
Info:
MacBook Air, Mac OS X (10.7.3)
I have waited quite some time until a first update to Yosemite was available.
I have installed Yosemite on both my IMAC and my MBP.Â
Since then, both computers behave similarly.
Even when no actions are performed, the memory fills up hour after hour, this takes a few hours.
Eventually the memory is so full that any operation takes 10 mn to complete, and it becomes impossible to perform any work.
In practice it is best to restart the computers every 4 hours.Â
The problem tasks are:
- Folder Actions Dispatcher
- and to a lower extend "kernel_task".Â
Info:
iMac (27-inch Late 2009), OS X Yosemite (10.10.1), I7, 2.8 GHz (model 2010), 8 Gb RAM
I just noticed that even when I clear my history, there are certain sites that the address bar is autofilling.Â
View 1 Replies View RelatedDoes anyone know why copying borders from one cell to another in Numbers doesn't work? It's pretty inefficient creating borders for each cell all over the place.
View 3 Replies View RelatedSend a text from my iMac to a cell phone?
Info:iMac, Mac OS X (10.7.3)
I can't access my pics from my cell phone... Firewall?
Info:
MacBook Pro
How can I print cell borders using Numbers 09?
Info:MacBook Pro (13-inch Late 2011), iOS 5.1.1, Numbers
Do cell phones have a mac address?What do the letters mac in mac address stand for?
View 2 Replies View Related