Applications :: Click 10 - 20 Times In New Cell - Excel
Jan 30, 2010
In 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
ADVERTISEMENT
Feb 21, 2010
Is 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.
View 7 Replies
View Related
Feb 3, 2012
In Windows I use <alt><enter>, but that doesn't work on my MacBook.
View 2 Replies
View Related
Jul 6, 2012
Is 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)
View 6 Replies
View Related
Sep 11, 2014
This is my school laptop that I use every year since last year. I had a few problems last year with this laptop but they were enventually fixed. This year my computer was fine until one day I couldn't open my folders on my desktop as easily. I used to just double click very easily and they would open. Now I have to click on each folder 5-6 times before it opens. I restarted my computer about 3 times yesterday and nothing worked.
Info:
MacBook Air
View 1 Replies
View Related
Apr 21, 2010
I'm using my 13" MBP for running Windows 7 right now. I'm in Excel 2007 and I'm unable to right click. When I right click the menu pops up with the options that are usually available once someone right clicks, but it disappears after a tenth of a second. Any idea what's causing this?
View 4 Replies
View Related
Jun 4, 2014
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
View 1 Replies
View Related
Feb 6, 2009
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?
View 6 Replies
View Related
Apr 13, 2010
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...
View 1 Replies
View Related
Oct 21, 2010
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 Related
Oct 21, 2010
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 1 Replies
View Related
Oct 4, 2010
The 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 Related
May 22, 2010
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.
View 4 Replies
View Related
Mar 27, 2010
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 Replies
View Related
Mar 28, 2010
I 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 Related
Oct 31, 2010
I'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.......................
View 10 Replies
View Related
Apr 1, 2009
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 Related
Nov 10, 2009
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.
View 2 Replies
View Related
Jul 3, 2012
I can't seem to find the "Times" key on a macbook pro 13 inch
Info:
MacBook Pro (13-inch Early 2011), Mac OS X (10.6.8)
View 4 Replies
View Related
Jan 8, 2008
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 Related
Apr 16, 2009
get 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 Related
Jul 21, 2006
17 inch Imac
1.83 GHz Intel Core Duo Processor
6 seconds for shut down!
27 seconds for start up!
Is this normal? I had no applications running!
View 10 Replies
View Related
Jan 15, 2009
I'm recently purchased CS4 and when I attempt to install it on my imac, I receive the following error.I've contacted Adobe 4 times without getting any help in resolving the problem...all they do is pass me from person to person.Anyone else had this problem or know how to fix it?
View 3 Replies
View Related
Feb 19, 2010
Is there any way to monitor this and find out which program is causing it? I don't use Limewire or any other type of file sharing software. Every once in a while I'll see a slight spike (between 500-800KB/S) in bandwidth for no real reason, then my IP gets blocked. How do I find out what's going on behind the scenes?
View 1 Replies
View Related
Jun 16, 2012
My iMac turns on but just beeps three times stops beeps more times and won't start up
Info:
iMac
View 3 Replies
View Related
Sep 2, 2010
I need a plug-in/add-on/application that will block certain websites I want at certain times. For example, block Youtube and Facebook from 4-6PM. Preferably these settings would be difficult or impossible to change once in place, haha. I want to be strict and not let myself procrastinate during the upcoming school year and I think this is the only way to actually do it.
View 7 Replies
View Related
Jan 7, 2011
I installed 10.6.6 on my MacBook Pro 2.2 Santa Rosa model. Everything seems to have gone well until I tried to open the new mac app store. It bounces one time then nothing. I have rebooted a couple times and still nothing.
View 24 Replies
View Related
Jul 3, 2007
Any commands or programs that will allow me to automatically refresh any webpage that I am currently viewing? Say for like my emails or forums or mypsace or something.
View 5 Replies
View Related
Mar 23, 2009
i have final cut express 4 and i noticed that there was 2 stickers with serial numbers,can i installl it on 2 computers.and i have not registered yet does that make a difference.
View 1 Replies
View Related
Oct 12, 2004
does anyone know how to keep a window (from a program your not working in) in front at all times? For example if your watching a movie in a window but want to edit a photoshop file in another.
View 9 Replies
View Related
