Mac Excel Compatibility Critical Keyboard Shortcuts – Excel for Mac (2008 & 2011) Wall St. Training recommends Excel for Windows due to keyboard shortcut compatibility issues. If working on a Mac, we highly recommend installing Windows as a virtual machine (WST recommends VMware) and installing Excel for Windows.
I have a spreadsheet with simple (addition/subtraction) formulas. The file is quite large and the formulas are too. All of a sudden, the formulas stopped working except when I double click in the cell containing the actual formula. For example, if I enter '2' in each cell, A2 and B2, cell B3 should reflect '4' because there is a formula in cell B3 which totals cells A2 and B2.
Only by double clicking on cell B3 will the program actually calculate. I'm totally perplexed and so is my IT contact. I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. Excel will not let me copy and paste a formula and will only paste the value into to workbook. For instance, if I make a very simple spreadsheet such as: A1 type in 10, A2 type in =A1 (calculated A2 to be 10) B1 type in 5 And then click the copy on B1, and then click paste special on cell B2, the only options it gives me are text and unicode text and so no matter how I paste, cell b2 will always be populated with a value of 5. I cannot imagine a simpler copy and paste and no matter what I do I can't make this work. All cells are formatted as general.
It seems that all copy and pasting of formulas in my excel has been disabled. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem. Is it possible to put two formulasinto one cell? On the attached timesheet there are columns IN, OUT, IN,OUT The lunch time is worked out by deducting 'C8 from C9' and this works fine when all 'IN, OUT' cells are filled in but for some reason when just the first two cells are filled in it gives a -12 hour answer. Looking at cell 'C11 ' in the attached worksheet, I currently have the formula =IF(C13=0,','SUM(C9-C8)) The reason for this is to make it look tidy by having blank cells until a calculation is needed, My problem is, If someone just comes in for the morning one day for instance 8am to 12 noon then they won't have lunch, but C11 will show -12:00 Can I put another formula into C11 to tell it not to deduct C8 from C9 until a time is put into C9.
The following is the sort of thing (many variations) I have been trying but because I'm hopeless at formulas I'm not having any success Thanks =IF(C13=0,','SUM(C9-C8))OR,IF(C9,ISBLANK,',SUM(C9-C8). I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a.csv file in order to upload to an application that parses out the.csv data as transactions. The system requires.csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly.
That is all good. But I have to save as a.csv. So if I do that, close the Excel window, and then open again (as the.csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as.csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file?
Thanks so much for your help! I have a co-worker's file that he is having trouble with. He is using Excel 2000 SP3. When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'.
Example: A1: 50 A2: 10 B1: 60 B2: 20 A3: Formula: =A1+A2 Displays: 60 Right click A3, Copy, right click B3, paste A3 displays 60 When I click save, it will change the display value to 80. I am trying this on his workstation and mine. Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this?
Hello from sunny Madrid I have created a complex formula to help me calculating Golf handicaps for players. The formula is in the first cell and I want to drag the formula across to the right to cover the 18 holes. But ALL the values change and I want some to change and some to stay constant. How do I tell excel to drag the formula across but keep certain parts of the formula the same.ie.=D11. In the formula when dragged across doesn't go D12,D13;D14 in each cells formula and should stay as D11 for all. Many thanks for your help Ole. Today I ran into an odd problem.
I typed in values for column A rows 1 through 10 then values for column B rows 1 through 10. Then in column C, I made the formula C1=A1/B1.
The math was correct it showed 542 in the C1 cell. So I dragged that formula down and it showed 542 in all column C cells which is not correct. And when I went to check to see if the formula was correctly dragged it was.
For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value. But it gets even more weird. When I click on the Column C cells and then it shows the formula up top in the formula bar and if I put my cursor anywhere in the formula bar and hit Return the formula does not change however the correct value then appears in the Column C cell. It is like the act of putting the cursor in the formula activates it to work properly but until it is activated that C cell shows the value of the cell which it was dragged down from. This is quite bizarre.
Has anyone ever seen this before? I have no idea what is going on. I ran a scan for viruses and none were found. I tried it on several new/different spreadsheets but it keeps happening. Thanks for any tips on this. Hi guys, Looking for some help and would appreciate your help. I want to prevent people cutting/copy/pasting on a spreadsheet I have developed.
A couple of users keep doing so which in turn knackers my formulas. There will be occasions where I will need to be able to use these functions for maintenance and updates.
Ideally I would like have a private marcro which I can run to enable these features as and when needed. I've been at this all morning and feel like I'm going round in circles. I've tried various bits of code (sourced via google etc) & have ended up with a whole manner of outcomes but not the one I want. To summaraise what I am looking for is some vba code which will do the following Disable cut,copy and paste when sheet is opened Enable cut,copy and paste when closed Have a macro which when run will allow me to cut/copy paste so as to implement updates when necessary. Can anyone help?
Thanks in advance. I have a couple of worksheets that have goal seek already performed on 20 target cells (for each worksheet). I did this manually, without a macro (since I'm absolutely horrible at all of this). Now from what I can tell, I need a code to add to the worksheet module in order to make sure that the goal seek updates itself whenever I change a value in the formula of the target cell. What IS that code?! I can't understand the codes some people have put up, so I have no idea what to do.
Target Cell: M21:M42 Changing Cells: N21: N42. Posted this on the Ozgrid forums, but haven't gotten any help yet, so I thought I'd try here too!
I've been having a strange problem lately. I have a fairly lengthy macro that works perfectly most of the time.
Occasionally it will run as expected but as soon as the macro ends, excel becomes unresponsive to mouse-clicks. When I click anywhere (trying to select a cell, or an excel menu item.clicking anywhere in excel) I'll get the a 'ding' system sound and nothing will happen. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. Then it gets really strange - when I have a cell highlighted and press any key to input text, it gets duplicated. So if I press 's' it will input 'ss' into the cell, and then when I press enter it will auto-move to the next cell down, but nothing ends up getting saved into the previous cell. I don't understand what's going on at all. I can't think of anything in my macro that would have these kinds of effects.
I've made sure that screenupdating is turned back on at the end of every procedure. If I go into the VBE, I can manually run procedures and they all work fine. The only way I've been able to get back to normal is by force closing excel altogether and re-opening. Still having trouble, and the same thing is happening with this workbook on two different computers, so I don't think it's a hardware, or OS specific issue. When it gets locked up like this, I can still do anything in the VBE (edits cells, run macros, etc.) with no problems.
If I'm in the excel window, I can click alt on the keyboard and the shortcut keys for the menu come up, but I can't go deeper than that by clicking the letter shortcuts, they do nothing. If I use the delete key to delete the contents of a cell, then it gets deleted. But if I type anything else (numbers, letters, or symbols) then it types 2 instances of the key every time, yet when I hit enter, nothing changes in the cell. I also can't really bring focus to the excel window if something else (ie. The VBE) is on top of it, clicking into the excel window just gives the little system 'ding' sound and nothing happens.
If I hit the save button in the VBE (since I can't click anything in the excel window), then it seems to snap out of it and go back to normal. I tried searching for anything simmilar to this and can't find anything. Any help would be much appreciated.
This is driving me nuts! Hi there, I'm very new to Excel, and I'm having trouble figuring a few things out. Hopefully this will be very easy for you guys! In Sheet 1, I have a column of cells that I would like to also appear in Sheet 2.
If I add a new row to the column in Sheet 1, I would also like it to be updated automatically in Sheet 2. Currently, I can get it to show the contents of individual cells from Sheet 1 in Sheet 2 by using this formula in the formula bar for each cell in Sheet 2: =Sheet1!A3 (or whichever cell it is) That's fine, but I'd like to just have a formula that will reproduce the entire column (ie.
Without a fixed range, as new rows are going to be added to the column). If anyone could point me in the right direction, I'd be very very grateful. From limited experience I know that excel calculates dates via serial numbers. I have formulas to add a number of days to a cell containing an entered date and display the resulting new date (ie. (c34)+11 = ) I am seeking to leave resulting formula cell blank until a date is entered in the input cell. Currently when the input cell is empty the formula cell obviously displays 1/11/1900 using the above example. What conditional format would achieve leaving the formula cell blank until date data in entered into the source cell?
Hopefully a simpler question for your experience level than mine. Hi guys, would really appreciate anyones help with this. I have a column full of text-formatted fractions. 4/5 6/4 3/1 2/5 4/5 etc, etc.the column is very long!! I need to convert these to actual fractions.ones I can add to equations, allowing me to multiply and add. If I highlight the column and goto 'format Cells' and change to fraction, the values still stay in the left of the cell.its only when I manually click on each individual cell, then tick the little green tick, does the cell validate, and the value in the cell moves to the right (and is therefore a proper value).problem is I have to keep doing this for each individual cell.and I have 70000+ cells in this column! Any suggestions on how I could speed this up?
The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Pastecommand, which is driving me crazy so I decided to do something about it.
Default Excel F4 Keyboard Assignment in Excel for Mac There are four keyboard shortcuts assigned to the Paste command in Excel for Mac — Shift+Del, Control+V, F4, and Command+V. Overkill, don’t you think? So I’m thinking the F4 button can be reassigned with no problems, unless, of course, you’re in the habit of using the F4 key for the Paste command. Reassign the F4 button in Excel for Mac.
Select the Tools menu, and click Customize Keyboard. In the Categories: box select Edit. In the Edit box, select Redo.
Select the Press new shortcut key: box. Press the keyboard combination fn+F4 key (or just F4 key if you’ve ). Click Add.
Click OK to reassign the Paste command to the Redo command.