I have entered number after using Alt+Enter in to one cell, now i need total of that cell, how I will get total pls help me. 143 550 350 440 all numbers are entered in to one cell using alt+enter now not able to get single cell total. The answer is to use Control+Option+Enter, which will create a line break in the cell. As an alternative, Control+Command+Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015. As pointed out by Shameer in this answer, Alt+Enter now seems to work as well in the new Excel for Mac 2015.
How can a formula perform the equivalent of the keyboard alt enter in a cell? ie Make =A1&A2 where A1 and A2 are cells containing text become a1text a2text in the new cell. Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar TopicsIs there a way I can use conditional formatting or something to change the color of the cell once I enter a value or text into that cell? For example if I currently have the A2 cell color as a gray color, and I enter information into A2 can I have it set to automatically change to no fill or any other color without having to click out of the cell, back into it, and then clicking the button?? Does that make sense??? Can someone help me? I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help? I have a formula in cell C1 (=A1/B1). I want to copy this formula down to row C20, however rows A2 to A20 are empty so C2 to C20 show (#DIVO!). Is there something I can put in the formula to make column C be blank until the data is enter into Columns A & B?
I have an excel worksheet that adds two other worksheets in a data triangle. I copied it to create a new data set and used find & replace to change the worksheet references to the new ones. The cells still contain the result of the old formula referring to the previous worksheets. The only way I can get the formula to return the correct result is to edit (F2) each cell and press enter. Calc now (F9) does nothing. I've seen this before, but this time, I need to calculate many thousands of cells and don't have time for this workaround. Any ideas? Thanks. Don S
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. Anyone? I have a textbox in my userform where anything typed in the box is entered into cell A2 in my worksheet. However, multiple lines of text are not properly displayed in my worksheet. I have enabled MultiLine and EnterKeyBehaviour in the properties window of the textbox so I can type multiple lines in my textbox. The problem is that when I press the button to enter the text from my txtbox to cell A2, the cell doesn't actually display the text in separate lines. It just places a square symbol in the place that enter should have been pressed and the text should have been split into separate lines. How can I get the separate lines of text in my textbox to be properly displayed in a cell? Thanks for your help in advance..
Let's say, if two fields in one column has been filled with numerical increament, i.e. A1 is 2 and A2 is 4. Now I want to fill the whole column with this increament pattern till row A20. One thing we will all do is to left click on the fill handle and drag it down to row A20. But if the task is to fill to row 500, the mouse draging sometime won't be easy to locate the row. I am wondering anyone can help me to find the keyboard shortcut equivalent to that drag fill handle action. Thanks
Ran into a problem I've never seen before. When dragging a cell across that contains a sum equation the result was the following cells with the same value. Inside the cell it showed what would be the correct new equation, but the value was still from the original cell. Any ideas on what's causing this? If I double click the cell and then hit enter it will re-total the area and then give me the correct value, but I'd obviously rather is just work right the first time.
Hi, I am entering lots of family history data into a spreadsheet. At the simplest I have columns (in cells A1 B1 C1) the headings, Surname, Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next row down). What I want to happen is when I have entered the last data in a row and pressed <Enter> I move automatically to the A-column in the next row down. Is this possible? Regards and a Merry Christmas to all Wibs
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. Any ideas? ______________________ 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!
Great tip! But one thing: On my machine (Excel 2008 Mac), the values in the formula cell are not correctly calculated simply by dragging. Instead, the values are equal to the cell above (the first entry formula value). To get the correct value, I need to click in the formula bar and then hit enter. (I only discovered this after an hour of tinkering, figuring I had botched the formula!) Are there any ways around this so that it updates upon dragging the formula? I have cells in a column, some colored yellow, some not. I am trying to use the SUMIF function to sum only the cells in the range that are colored. Can this be done? Can I enter something in the 'criteria' part of the formula that can do this? =SUMIF(D3:D13,'criteria',D3:D13) I also tried to use the CELL function's color feature, but I couldn't get it to work right. I don't know how to get Excel to recognize if a cell is colored in a formula. =CELL('color',cell) It might just be that I don't know what this means in Help: 'color' --> 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero). Can anyone help? I have entered a vlookup formula in a cell and it returns the correct value from the other worksheet. However when I copy the formula down it keeps returning the exact same value as the first cell. If I enter a formula in each individual cell it returns the correct value. Its driving me crazy ! I woyld be glad of any advice Many Thanks Karamazov
In excel, I am trying to find a formula or funtion so that when I enter a date (1/10/05) in cell A1 for example, then B1 automatically changes to 1/11/05, C1 to 1/12/05, etc. Can anyone help? Thanks!!
I am trying to automatically capture and record the date of a cell's last change in value (date stamp). I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell. I realize that after I change cell A1 I could tab to cell B1 and enter Ctrl+; but if I have a hundred new prices to enter I don't want to do that (plus me or the data entry person might forget). For instance, A B 1 $32.17 8/17/08 2 $43.20 9/12/09 If I go in and update cell A1 to $33.98 today I would like cell B1 to read 2/16/10. But I don't want cell B2 to change. Thanks I am creating a data sheet to be completed by other users. I would like to format the text cells (name, etc) to have text entered as uppercase automatically although the user might use title or lower case. UPPER function cannot make cell look at itself and perform the function Excel 2003
Hi everyone, I'm going nuts trying to figure out how to autofill text from one cell to another. For example, everytime I type text into cell A20, I want the exact same thing to cell BL20. The same for B20, BL20, etc. How do I go about that? I already know how to copy formulas from one cell to another by dragging the skinny black line of the cell. I guess I just need the formula for a simple IDENTICAL copying of text. Thanks in advance, Mike
I have set a VLOOKUP formula to match account numbers. How ever I have to click double click on the cell before the formula recognises the account number. I have to do this for each cell. I have tried different formats. It is not saving me that much time.
Hello, I need to know how to auto-fill text based on text in another cell. For example: Every time I enter 'CHS' in Column B, I want Charleston to auto-fill in Column C. And when I enter 'SAN', in Column B, I want San Diego to auto-fill in Column C. How can I set up a list like this? Any ideas? Thanks! Jason
Is there a way to make a cell populate certain text based on conditions of other cells without putting the formula in the cell you want to populate. So that someone could type other text into the cell if the conditions were not met?
Hello, I am new to using Excel and I am not very computer literate. I am looking for some help with a spreadsheet I am making. Here is the problem: I have a column of 14 numbers in cells A1 to A14. If all of these values are less than 2%, I would like a 'Pass' to display in cell B1. If any of these values are greater than 2% I would like a 'Fail' to display in cell B1. I have got a formula that works for a single cell but I can't figure out how to get it to apply to more than one cell. For example, I have entered =IF(A1<2,'Pass','Fail') in cell B1. Now if the value I enter in A1 is less than 2, it shows a 'Pass', and if the value in A1 is greater than 2 it shows a 'Fail' in cell B1. How can I get this to apply to all of the cells from A1 to A14? If somebody could help me out that would be great. Thanks, Randy
Is there a way that will run the code from a button when the enter key is pressed. Currently the enter key moves to the next text box in the user form.
Hi, How do I enter the value in a cell (say B4) into a formula as a constant so it doesn't change when I copy it down the column? For example, B4 = 2.4 (a constant) This is the result I want: F6 =C8 + B4*4.243 F7 =C9 + B4*4.243 F8 =C10 + B4*4.243 B4 remains constant as I copy F6 down. What's the correct formula for F6 so I can copy it down and keep B4 fixed? Thanks.
Is it possible to change the color of text using a formula, such as an IF statement? What I have in mind is something like this (stated simply): If cells B9 or N9 or Z9 or AL9 are blank, do nothing, else color text in cell S4 red. I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format. For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of '04:00' (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells. My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as '04:00 - 12:30'. The times would change based on the Time formated values entered into the Start and Stop time cells. I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated. -Shane |
![How to do alt enter on a mac for excel download How to do alt enter on a mac for excel download](/uploads/1/2/5/3/125309635/593511163.gif)
Using Excel 2003 - Want to break a line of text in a cell so I can create a second line of text within the cell... Alt+Enter used to do the trick (forced line ending) but suddenly it's not working. Not a hardware fault (Alt and Enter keys working separately OK). Has something been changed in a recent batch of MS updates that could stop this shortcut? Are there any other ways to input a forced text line ending while staying within the same cell? Thanks ChrisB Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar Topics
I have a graph with various information in it. One is a line graph that tracks hours used in that department per month. The problem is that when it gets to the last month, and there is not yet data for future months, the line goes down to Zero (leavin this big diagonal line that makes the data look funny). I need this line to stop on the last month there is data for. (I do not manually enter the data, it is a formula that I do not wish to delete.) I know I can manually move the data that the line is pulling to make it stop on the last month, but I have a graph for 36 different departments and that's a pain to have to manually adjust 36 graphs each month. Is there a way to tell the line to stop if there is no data? Thanks!!
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. Any ideas? ______________________ 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 everyone, I'm going nuts trying to figure out how to autofill text from one cell to another. For example, everytime I type text into cell A20, I want the exact same thing to cell BL20. The same for B20, BL20, etc. How do I go about that? I already know how to copy formulas from one cell to another by dragging the skinny black line of the cell. I guess I just need the formula for a simple IDENTICAL copying of text. Thanks in advance, Mike Is there a way I can use conditional formatting or something to change the color of the cell once I enter a value or text into that cell? For example if I currently have the A2 cell color as a gray color, and I enter information into A2 can I have it set to automatically change to no fill or any other color without having to click out of the cell, back into it, and then clicking the button?? Does that make sense??? Can someone help me? I am puzzled by a thin black line (that looks like a border line) on a spreadsheet that I am unable to remove, whatever I do. It starts halfway across column B and stops just at the end of column Z. It is not a border line. It is not a page break. If I delete the rows it appears on it remains visible. It is not an object floating on top of the spreadsheet. Any ideas? Thanks. I have a userform containing a multicolumn listbox (ListBox1) and textbox (txtSelectedJobNumber). When a user clicks on a line in the listbox I want to automatically copy the text in the 3rd column of the selected line to the textbox. If anyone could provide code which would allow me to do this I would be grateful Thanks Colin I have a textbox in my userform where anything typed in the box is entered into cell A2 in my worksheet. However, multiple lines of text are not properly displayed in my worksheet. I have enabled MultiLine and EnterKeyBehaviour in the properties window of the textbox so I can type multiple lines in my textbox. The problem is that when I press the button to enter the text from my txtbox to cell A2, the cell doesn't actually display the text in separate lines. It just places a square symbol in the place that enter should have been pressed and the text should have been split into separate lines. How can I get the separate lines of text in my textbox to be properly displayed in a cell? Thanks for your help in advance..
I'm working on a speadsheet that has thousands of line items with lots of great information, but not in the fields I need them to be in. Is there a formula to move for example cell contents A26 to B25 and D26 to F27? Also I have contents in one cell that I need to break apart is there a formula for that too? I searced the help and the net an came up with nothing. Maybe I'm not wording it correctly, but I'd appreciate the help. I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar. I am extremely confused, can anyone help? I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format. For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of '04:00' (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells. My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as '04:00 - 12:30'. The times would change based on the Time formated values entered into the Start and Stop time cells. I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated. -Shane
Morning all, Say I had a line graph for 4 years and I wanted it to be a solid line for the first three and a dashed line for the last one, is that possible? Many thanks for your help
Hello, I need to know how to auto-fill text based on text in another cell. For example: Every time I enter 'CHS' in Column B, I want Charleston to auto-fill in Column C. And when I enter 'SAN', in Column B, I want San Diego to auto-fill in Column C. How can I set up a list like this? Any ideas? Thanks! Jason
Is there a way that will run the code from a button when the enter key is pressed. Currently the enter key moves to the next text box in the user form. Hey guys, I'm trying to write a macro which prints to PDF and saves the file name as the contents of a cell. I've been looking through all the posts currently on this forum to get something working. I'm using the following code - Sub PrintPDF() Filename = 'C:Documents and SettingssambMy Documents' & ActiveSheet.Range('Z1').Value SendKeys Filename & '{ENTER}', False ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ 'Adobe PDF:', Collate:=True End Sub The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter. Any ideas where I'm going wrong? Any help would be much appreciated!
Great tip! But one thing: On my machine (Excel 2008 Mac), the values in the formula cell are not correctly calculated simply by dragging. Instead, the values are equal to the cell above (the first entry formula value). To get the correct value, I need to click in the formula bar and then hit enter. (I only discovered this after an hour of tinkering, figuring I had botched the formula!) Are there any ways around this so that it updates upon dragging the formula? I have found similar posts on the forum, but nothing without use of a userform. I have the following code: Code: This works, but I want to hide the text as it is entered. Is there a way I can enter this as a property? i.e. inputbox.text.property = ... or something?? I've tried what seems intuitive, but nothing works. Help! I have been using Excel (XP) to make a text chart for several months. Some of my text entries are rather lengthy. The past two weeks these lengthy entries are showing up as pound signs (#########) when I click off the cell. I know the text will fit in the cell, and the problem isn't solved by making the cell bigger or using a little bit less text. I have the cells formatted as 'text' and 'wrap to fit'. I have printed the pages and the printed version also has pound signs. I just want my text to show up!
I would like to copy a small table from Word into one cell in an Excel worksheet. The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work: * Formatting the Excel cells as text before pasting the data. * The various options for 'Paste Special.' The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails: * The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings. I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? Many thanks.
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. Anyone?
I have two columns in my spreadsheet. Column A has no blank fields, Column B has some blank fields. I would like to show the text from Column A in the same row of Column B only when Column B is blank. So, basically I'm after: If column B has text, do nothing. If column B is blank, then list text from Column A. Right now I've created Column C with this formula =IF(ISBLANK(B1), A1. That's working to get the text from A1 when B1 is blank. What can I do/add to get it pull the text from B1 if there is text there? Or...is there a better approach altogether? I am creating a data sheet to be completed by other users. I would like to format the text cells (name, etc) to have text entered as uppercase automatically although the user might use title or lower case. UPPER function cannot make cell look at itself and perform the function Excel 2003
Hi, I am entering lots of family history data into a spreadsheet. At the simplest I have columns (in cells A1 B1 C1) the headings, Surname, Forename, Year. Right now, I enter in cells A2 B2 and C2 say: Smith <Tab> John <Tab> 1555 <Enter, move mouse to the A column in the next row down). What I want to happen is when I have entered the last data in a row and pressed <Enter> I move automatically to the A-column in the next row down. Is this possible? Regards and a Merry Christmas to all Wibs
I have an extensive spreadsheet with several columns and all showing borders where each cell/column begins and ends. However there are a few cells where the break with the next cell does not show the line. I have highlighed the cell in question, gone to format/cell/borders and everything looks fine. Black color + format border shows square with all sides of square showing. Any thoughts on how to fix these few random cells. Thanks
I am trying to automatically capture and record the date of a cell's last change in value (date stamp). I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell. I realize that after I change cell A1 I could tab to cell B1 and enter Ctrl+; but if I have a hundred new prices to enter I don't want to do that (plus me or the data entry person might forget). For instance, A B 1 $32.17 8/17/08 2 $43.20 9/12/09 If I go in and update cell A1 to $33.98 today I would like cell B1 to read 2/16/10. But I don't want cell B2 to change. Thanks
Hi everyone, this is my first post here. I consider myself a more advanced Excel user and can navigate my way around fairly well. I've written a spreadsheet and am wondering if there is a way to permit data entry in a cell, contingent upon another cell being populated. In simple terms, you can't enter data in cell X, until cell 'Y' has been populated with something. Can anyone help with this, because I can't figure it out.... |