By In Excel 2011 for Mac, you can move or copy one sheet at a time, or select multiple worksheets and move or copy them all at once. You can move or copy sheets within a workbook or from one workbook to another. Click a sheet tab to select the sheet you want to copy.
Jan 3, 2018 - Click Home > Format > Move or Copy Sheet. Workbooks by using the Browse button, otherwise known as Select in the Mac version of Excel. Learn 200+ Excel shortcuts (Mac and PC) with this easily searchable list. This App is not compatible with Smartphones and Tablets. Copy, Cut, and Paste Shortcuts. Move To Last Used Cell In Worksheet.
Hold Command while clicking sheet tabs to select multiple worksheets. Choose Edit→Move or Copy Sheet. Alternatively, carefully right-click over the selected tabs (so that they don’t get deselected) and choose Move or Copy. In the To Book pop-up menu, choose the destination for the worksheet(s) you plan to move or copy.
You can choose these destinations:. Within the Currently Active Workbook. To Any Other Open Workbook. To a Brand New Workbook The Before Sheet section lists all the sheets currently in the workbook. The sheets you move or copy are inserted in front of the sheet that you select. (Optional) To make a copy (instead of moving the entire sheet), select the Create a Copy check box. If you don’t select this check box, Excel uses the default move behavior instead.
The Move option deletes the worksheets from the source workbook. Consider the cell references and hyperlinks on the sheets you’re moving or copying. If you have references to other sheets, you may be creating links. When you’re done with the Move or Copy tool, choose Edit→Links in the destination workbook. The Edit Links dialog appears.
You can break unwanted links in the Edit Links dialog. Did you want to move worksheets within the same workbook, as in reordering the worksheet tabs? You can just click a worksheet tab to select it and then drag and reorder them within a workbook.
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?
Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears.
Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. I recently moved into a new office and I am using a brand new computer on our network. When trying to edit an existing file, I'm not able to select a single cell and type. After clicking on a cell, if I move the mouse at all (even without pressing the left button) it just continues highlighting cells no matter where I move the mouse.
I am also not able to click on the tool bars at all. I have to actually Ctrl-Altdel to get out of the program. I'm sure this is something simple, but I don't know that much about this program.
Any help would be greatly appreciated. Hello, what I would like to do is take a portion of a sheet. So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the 'proposal creation' sheet I want it to mirror only a specific cells to another sheet that is 'salesman copy' that we will print to clients.
So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the 'salesman copy' which is what we will print for clients. Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns, one of which is a date which may be repeated.
I then want to use another sheet with two cells where two dates can be entered and a button which allows you to copy the rows of data from the data sheet which have dates between the two specified originally. The list in the data sheet may not be in date order although I could update a macro to do this for me if needed. I would also like to do it so that if 'ALL' is typed in the date fields, it pulls over ALL the data. (Or something similar) Any help you can give would be much appreciated. Cheers, Kevin. Hi there, longtime user firsttime poster.
Looking for some help as I am a non-expert with macros. Here's what I'm trying to do: We have to submit things to a certain regulatory body and we usually enter tasks in as soon as they come, do the submission, and then keep a record of that submission. So, I have a workbook with two sheets, one is 'TO DO', the other is 'ARCHIVE'. Both sheets have the same columns and everything. I am looking for a macro that will automatically cut a (row) from the TO DO sheet and paste it in into the ARCHIVE sheet once it is done, then delete the cut row from the TO DO list so it stays topped up.
The trigger for archiving is the columns M and N which are titled 'Complete?' And each has a validation drop down that says 'YES'. When both cells in columns M and N have the YES in them, I would like the macro to make the above mentioned actions. I ran a search on the forums and found something similar, but not quite what I was looking for. 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 just worked with a data set where I needed to create a unique key based on existing information where no unique key was set up as a field. I accomplished it by concatenating (using the & concatenation operator) several fields based on what I hypothesized and observed about their content. I'm thinking there has to be a more automated way to discover the best unique key of existing fields and their data. I thought I'd post this as a challenge because I don't know the 'right' (or better) answer. Anyone have any ideas?
I have a VBMacro Excel file loaded on a Server that numerous people access. A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop. How do I find out what the current User's desktop folder path is each time the Marco is run by a different User? Example User's path: 'C: Documents and Settings jfarc Desktop' Where 'jfarc' is the name of the current User which, will of course change with every different User that runs the Macro. Also, is there a way to pull out of Excel what is the current User's 'Options General Default File Location' entry? Which may differ from the above directory.
I am familiar with and use the following coding for Opening/Saving files to the current directory of the opened workbook, but it only gives the path of the existing Excel workbook and not the current User's Directory Path: Dim wbThis As Workbook Set wbThis = ThisWorkbook ChDir wbThis.Path. I have a problem sometimes. I will click on a cell to add information. The cell turns blue and then wherever I move, it highlights those to.
No matter where I go on the page. If I Alt-Tab and work in another program on my computer, that excel page keeps highlighting wherever I move even in those other programs (I know this sounds confusing). When I return to excel thousands and thousands of cells are blue. The biggest problem is that the highlighting won't turn off, no matter what. I can't select anything from the tool bars, do any work on the sheet or close the program. I can close it only with the task manager but when I open it again, the cursor is still stuck in the highlighting mode and won't perform any other functions.
Do you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. Is there some shortcut to turn off this highlight feature other than restarting my computer. Which is the only current way I can get rid of it. Thanks for any advice. 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. 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.