When you create a table in Microsoft Excel for Mac and copy it into a new email message in Microsoft Outlook for Mac, the table is pasted into the email without any borders. Cause This is a known issue in Office 2011 for Mac and Office 2016 for Mac.
Hey guys, I've spent last two hours trying to figure out how to paste a selection into visible cells only (some rows are hidden) but no luck. Before I decide to trow my computer out of the window, I want to see if you maybe someone knows what the problem is. Searching the internet did not give any answers. I want to copy a whole column from one sheet, to another with hidden cells. So what I did is copy as normal, than select where I want to paste, click the visible cells only and then CTRL+V.
This does nothing, and I mean nothing. Its like it gets locked when I click the visible cells only option. It doesn't even respond to the paste command. So I don't know what to do. The same happens when I do the right click on the selected cells and then paste.
Quick note - I use excel 2011 on a mac, so no macros posible I added the worksheet as well so you can take a look. I want the paste the values for 'average #' from sheet2 to the sheet1 with hidden rows. Thank you in advance.
Hello - I am using Excel 2007. In prior versions of excel, when copying data, if I wanted to copy visible cells only, I would select 'Go To, Special, Visible Cells Only' and then copy a range a cells. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only. In 2007, the default is somehow set to always copy only visible cells.
Sometimes, I want to be able to copy all cells including those hidden but cannot seem to figure out how to swith this default option. I looked under Excel Options and did not see an option there. I don't want to have to unhide and rehide everything each time i copy. I know i could do the hiding and unhiding via VBA but would prefer not to have to. Thanks for your suggestions. 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. We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets.
When you highlight the section to copy and then go to the new workbook both the paste and paste special are 'grayed out'. This is true whether you right-click the mouse, go to the edit menu, or use control keys. This occurs with any data type and the most simple workbooks. I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the.xlb files and neither helps. You can open the clipboard and the paste will work, but there is no paste special option. Any help would be greatly appreciated.
I did a search in here but didn't find an answer so here goes nothing. I have a spreadsheet with data from A1 to H1 down to A275 to H275. I select all of it, Copy, go into the Sheet2 tab and select A1, Paste Special - Transpose and it give me the following error message: Quote: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste. Select a rectangle that's the same size and shape, and then paste. For the life of me, I can't figure out why it's not working!
I have done this many times with other spreadsheets. Has anyone ever experienced this? If so, were you able to resolve it and how? Many Thanks, Mike. Hi, I use filters a lot at my work. One thing I've noticed is that if I have something filtered and want to copy and paste only what I see from one column to another column right next to it, it will copy what is filtered, but then paste into the unfiltered portion.
Is there some way to copy only what I see when it's filtered, THEN paste only onto the adjancent cells which is also filtered? For example let's say i have each of the number below in a cell (Fig 1).
And then I hide rows 2 -3, so only 1 and 4 is showingI only see 1 & 4 in column A. I want to copy and paste 1 and 4 to the next column over one row so it looks like Fig. 2 when unhidden. Not like Fig. 1 1 2 3 4 Fig. 2 1 1 2 3 4 4 Fig.
3 1 1 2 4 3 4. I'm using Excel 2007 and often use filters to find inconsistent data (mis-spellings, etc.) and then clean up the data using the fill handle to fill in correctly formatted values.
I'm finding that, with a simple filter on, dragging over cells hidden by the filter changes the values in the hidden cells too. This is something I don't remember from my last version of Excel. I'm wondering if I've mis-remembered how this control works, or if there is a setting I can't find. My goal is to drag and fill (or paste) in a colum with a range of rows wiht some hidden (filtered out) rows, and have the filtered out data be unaffected, if that makes sense.
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? 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. Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum!
I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals. While scanning the photographs, I have saved them serially i.e.
1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. Problem: I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed: Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards::: Jack. We have a workbook that does not allow us to use the Move or Copy command.
When we right click on the worksheet and select Move or Copy, we are able to check the box to make a copy, but when we click OK nothing happens. We have checked to make sure that the workbook and worksheet: 1. Are not protected 2. That there are no hidden worksheets 3. That there are not worksheets that exist with the same name 4. That not all the worksheets are selected There are only two worksheets in this workbook. Any ideas of why we are unable to make a copy of this worksheet within the same workbook or to another workbook?
I saw two threads in this forum that asked this question, with no good answer. I am posting this solution for anybody still struggling with this. The question: How can you prevent a cell's contents from overflowing into the next cell?
Of course, you can make the column wider or turn on text wrapping, but you might not want to. Each of those solutions can mess up the layout of your sheet. You may just want to truncate the value. Some people have suggested putting a space in the next cell. This is unnecessary, a pain in the but, and will mess up any ISBLANK type formulas, among other things. The solution: Select the cells in question and turn on text wrapping (FormatCellsAlignmentWrap Text).
Now select the row(s) in question and manually set the row height, by right clicking the row number and selecting 'Row Height'. Check the height of an adjacent row for a good value. Your cells will now not spill over either horizontally or vertically. They will simply truncate anything that doesn't fit. Be careful now, because parts of your data may be hidden.
This can cause its own set of problems if one or two digits are neatly hidden away. Think ahead if other people might be using this sheet, and not be expecting to have some data hidden. Tested in Excel 2002. I am looking for the code to select the visible data after applying a data filter. Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!! I am using below code to Select the Visible rows in the target range: Code: Range('A:p').SpecialCells(xlCellTypeVisible).Select Problems in this code a 1) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook.
I need this to select the the data only till the last used row in the given range. 2) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6 3) The Code is also selecting the 1st row which is a header row. How can we exclude it from selection.
Some one please revert with the solution. Thanks in advance. 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? 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!