My question if the same as Jay’s (june 18 2012). I have entered multiple lines of data in a single cell using alt enter. When i copy the contents of this cell to another it appears in several rows. Your answer confirms this happens. Are you also saying there is no shortcut and in every instance i would have the tedious task of merging the copied cells.
To start a new line in Excel cell, you can use the following keyboard shortcut: For Windows – ALT + Enter. For Mac – Control + Option + Enter. Here are the steps to start a new line in Excel Cell using the shortcut ALT + ENTER: Double click on the cell where you want to insert the line break (or press F2 key to get into the edit mode).
I have to do this often and its time consuming. I find all your other tips most helpful.
Some have cut my work time by half. Thank you thank you. The difference may be in the way you’re copying the cell. If you’re copying the contents of the cell — if you’re going into the cell itself (either with F2 or within the formula bar or by double-clicking) and selecting the individual lines/words/characters, then that’s why you’re getting the result you’re seeing.
See the video above (under “Update”) for a demonstration/explanation. If you want to copy just part of the cell into another cell, then do use double-click; just make sure you double-click both just before you copy and just before you paste. If you double-click and copy part of the contents, then single-click a cell to copy to, you’re mixing apples and oranges vis-a-vis copy methods. Use one method or the other as appropriate. I create a multi-column weekly report in Excel where I have one column of cells with multiple line breaks in each cell.
I have to email this to my supervisor in Outlook each week to “edit” and when it comes back and I try and copy it BACK into Excel, I lose the line breaks in the cell. In other words, the separate lines recorded in a single cell in the original output are put back into separate cells when I copy over from Outlook. I have tried copying the Outlook text into a Word table and then copying that back to Excel, but in all cases I lose the line breaks within the cell.
This may sound a little harsh, but can your supervisor not simply edit the file in Excel? Does s/he not have Excel? Or has it but doesn’t know how to use it? What’s the barrier to simply attaching the Excel sheet to the outgoing email, rather than dumping the text into the body of the email? I don’t really get how this copy-and-paste process you describe evolved. How did you two come up with this way of doing things? It sounds to me like your company needs the services of a good IT professional to set up some sort of environment in which your supervisor has direct access to the data that needs editing.
Or your supervisor should get/learn Excel and “edit” your sheet when you turn it in. Or you could let your supervisor write on a hard copy and you type the changes. But the system you describe sounds maddeningly over-engineered to me. Flipping the data back and forth among various file types (copying to Word, over to Outlook, then re-copying back to Excel) is bound to cause formatting issues. Yes, I do attach the Excel spreadsheet, sometimes ONLY the spreadsheet, but the pertinent columns are always copied to Outlook and revised there and then returned to me. The text that comes back appears to have the line breaks in the cells, but when I copy back to Excel, the line breaks don’t carry over.
No worries, we are revising the process anyway, so this was just a shot at a short term fix, but I was just curious if it was even possible. The “over-engineering” is not part of the current process, just my attempt to convert the Outlook text I receive BACK into the format that I sent over with the line breaks intact. Thanks for your help!
If you want each item to go into its own cell, then just copy the item from Word, click into the first cell in Excel, and hit CTRL-V. If there are hard returns (a.k.a. Paragraph breaks) between each item, each item will appear in its own cell. If you want all 200 items to appear in the same cell with the hard returns intact, click into the cell in Excel, then click into the Formula Bar up top (that little white area to the right of the “fx” symbol) and paste it (CTRL-V there). All 200 items will go into the same cell. Sorry for the duplicity – but I asked this question back in August 2012 (it’s seen above) but never have had a reply. I’m hoping for an answer as I run into this often and it is making crazy that I can’t figure it out.
What I can’t figure out is how to decrease the line spacing within a cell. For example, if you look above at your hard break example with the 2 lines of text, I want to reduce the spacing between the lines (to close up the gap between the lines more), anyone know how to do that? I’ve tried setting it as a single spaced, smaller font, etc, but not working for me. The only thing that comes close it seems it to change the font.
Hi, I can able to add tabs in single cell itself and Alt Enter is also working fine. But i have a couple of columns to merge and my merged cells required to come one under one in a single cell. Ex1: Did manually Copied and pasted directly from excel sheet. “Example Checking Testing” Ex2: Tried with merging formula =A1 &” “& B1 &” “& C1 Result is: Example Checking Testing (It not comes one under one in a same cell) How to do this for all cells? We want to do this for all cells automatically, because data is huge.
Legal Office Guru uses a technology known as 'cookies' to provide a better experience as you browse this site. This allows me to see how the site is used and gives me the opportunity to offer you additional content you may be interested in, depending on what tutorials you've viewed. The cookies cannot identify you individually. If you continue to use this site I will assume that you are okay with this. You may, of course, turn this feature off in your web browser if it makes you uncomfortable.
For more information on what cookies are, what they do, and how you can control them, go to.
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! Okay, so I tried (for hours) to find a solution to this and have finally gotten frustrated to the point where i think asking here will be my best bet. Basically I want to export data from excel worksheets to various places on a word document I had.
I have created a word template as well as bookmarks for that template, as that seems to be the recommendation for performing such a task with excel. My problem is. I basically have 1 constant worksheet that contains all my affiliates info (Name, Address etc), which i'd like to use to populate some bookmarks in my word template, and then i have another worksheet for the previous month, indicating sales etc for that affiliate. I intend on adding a new worksheet every month that i would use to create new invoices.
Furthermore, i'd really like to be able to update a new file (or perhaps a new page on the same file) for each company with the use of a button, similar to the one's you'd see in an access form. Can anyone help? Let me know if you need me to clarify. I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons.
Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else. Is there anyway then to open the file or to reduce its size without opening it (through magics.)? I just honestly don't know how to retrieve that info before deleting that file. Thank you very much for your help.
Hi there, I have a spreadsheet with some cells setup with a drop-down list containing Y, N or N/A This is being used on a TabletPC but if I make a mistake or need to change back to a blank field I have to invoke the soft keyboard, activate the cell and hit backspace then close the soft keyboard - quite a long-winded procedure just to change an incorrect choice! What I would like to do is add a blank to the list so if I have to revert back to a blank I can just use the stylus to choose a blank from the chooser list. How do I add the option of inputting a blank from the Data Validation List bearing in mind I am using the Data Validation Source box for entering my choices directly and not specifying a range of cells?
I have tried adding ' and even a space to no avail. Although not a betting man I would wager there is a simple 'fix' for this but things are only simple if you know how in the first instance!;^) - Thanks & regards, -pp. Sorry for the question.
Normally I find answers to my excel questions by going through the help tab or by searching on Google. However, I don't even know what question to ask on this one!?! Basically I have created a spreadsheet with several columns, but I have one column that lists the shirt size (YS, YM, YL, AS, AM, AL, XL, 2X, 3X) of each person.
Is there a formula that I can create that will tabulate the number of sizes (i.e. AS=2, AM=7, etc.)? In previous years I made a column for each size, and simply placed a '1' in the correct column, and had excel just add the 1's from each column. However, that takes more time and space. I was hoping to streamline it this time around.
Thanks for taking the time to read this post. Any help would be appreciated! Thanks, doug.
A previous poster explained what I also need; there were no responses, so I thought I would try again. Does anyone know of an Excel template-or a small stand-alone program-that will calculate the interest/principal breakdown when payments are varied in amount and frequency? Free or low-cost, please.
I need one that will work on my Mac/Office 2004. I will need to print out periodic reports. Here is the way the previous poster described it: 'Excel template: Loan Amortization for random/irregular payments, figures days between payment dates. I have a loan with a variable beginning balance and irregular payments with annual large payment.
(based on collections) Would like to enter payment and date. Then Excel would figure days since last payment, interest amount, principal amount, Ending Principal balance.
And total interest paid, total pricipal paid If I change the starting principal, excel would recalculate all entries.' Thanks very much. 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.
![How to go back to a1 cell in excel for mac free How to go back to a1 cell in excel for mac free](/uploads/1/2/5/3/125373407/575823637.png)
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! Hello, Here is my issue: I have a list of SKUs in Excel and I need to add one same word to 500 cells that have pre-existing text in the cells. See example below: 1) List of SKU's in cells: 34 35 39 55 2) text that needs to be added IN FRONT of every number: DF So the result would be: DF34 DF35 DF39 etc. How do I do that in a formula and not manually?
I found another similar thread and I understand how to do it from the instructions there but the same text goes on the back and the result is: 34DF but I need it to be like: DF34. I am using Office 2007 for mac. Thank you for the help, Chris. 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.
I did a bit of browsing on this problem. Found others suffering the same but haven't found any conclusive answer yet.
Every so often when I attempt to save a file, (including save as), Excel won'r let me. By won't let me I mean: using Save doesn't appear to do anything using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File') if I close the workbook I am prompted to save, close without saving or cancel. Clicking save just invokes the same msgbox again. I can't work out when it goes into this mode. Some days I can work without this problem, other days I encounter this 2 or 3 times. The only thing I could suspect was I think this started around about the time I installed xlDennis' code library.
I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause. Anyone have any idea? Cheers Jon Edit: I have read this: Doesn't seem to cover the issue I describe. How do I get the colors to change automatically when I use a drop down list.
Per say here is what I am trying to do If a certain 'word' is used from the drop down list I want the background of that cell to change its color to 'green.' And if later I change the 'word' to another from the drop down list, it will change it's color to a specified color. The drop down list that I use was created from cells that have the colors already in the 'word', but I do not know how to make the list show the colors so it puts the word & color automatically in the drop down list to the cell with the drop down (if that makes any sense). If there is a way, please spell it out simple enough for me to understand, as I don't know fully the capabilities of formulas or vba. Hello everyone!!!! Here is my situation. I have been trying to learn macros but have not made one yet.
Need your help. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc.COUGH COUGH. ya ok. LMAO We have a 'shared' work book we all work in.
It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a 'refreshed' copy of the workbook before they start writing in cells that already contain information. How to I create a macro button at the top of the page that is literally a SAVE button. Instead of them saving by going to File - Save or cntrl+s??? I just thought that MAYBE having a big button in their face will remind them.
Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins??? I don't mean a save. But a refresh so the screen actually updates in front of you.
(although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) Thanks so much!!!!! Muchly appriciated.
This is probably an easy question for most of you, but it's killing me. I tried searching before I posted this, but the suggestions given didn't seem to work for me. I need to look up data from a cell on one Excel sheet, compare it to a list on a 2nd sheet and when they equal, take a value from a different column on the 2nd sheet and drop it back on the 1st sheet. Since that's a horrible explanation, let me try explaining it this way: Sheet 1 Column A has a long list of code type 1s Column E has a long list of code type 2s Sheet 2 Cell C2 has code 1 Cell E2 needs code 2 I know it should take an index/match function, but nothing I try is working. What I'm trying is the following formula in Cell E2 of sheet 2: =INDEX('Sheet 1'!A:A,MATCH(C2,'Sheet 1'!E:E,0),5) But all I get is no result.
What's driving me bonkers is that if I copy everything over to a single sheet, that formula works fine. Hello everyone, I am new to this forum and have been using excel for about 3 years. I have learned alot but still can not figure out how to make numbers add up in one box like a running total. Meaning, If I have a list and in the list is one cell for each item say like cell a1 is for a can of coke and cell a2 is for a car tire and so on,and i want to keep a running total by adding a number to cell a1 or a2 like say '3 i.e. 3 tires or cans of coke' and later that day i come back and need to add 2 more.so i want to be able to just click on the cell a1 or a2 and enter the number 2 and the cell would add the number in it to the number im adding to it to show a result of 5 tires or whatever. I am sorry If i am not asking the question in an understandable manor but its the best way I can think to ask it.lol anyways, any help would be appreciated, Thanks in advance.