Let Formula = Worksheets(ActiveSheet.Name).Range(ActiveCell.Address).Formula Excel 2008 without VBA was a disaster from a programmability standpoint. Microsoft's Macintosh Business unit was between a rock and hard place when they were building 2008. From double click on mac excel spreadsheet to available: 59.6 seconds! Launch Parallels 7: 7 seconds. From double click on PC excel spreadsheet to available: 7.1 seconds. So it is quicker for me to launch Parallels then PC excel than use Mac excel. By Geetesh Bajaj, James Gordon. Copying and pasting cells and cell formulas works differently from text and other objects in Excel in Office 2011 for Mac, so they can be a little bit puzzling if you don’t know the secrets about references. Keyboard)Shortcuts:)Excel)for)Mac)2011 KeyboardShortcut Action Source Comment Ctrl(+Shift+0 Unhidecolumn(s) Excel(default Ctrl(+Shift+9 Unhiderow(s) Excel(default.

Here we can see the same options in addition to several others. But let’s get back to the task of pasting our formula. When we select our destination cell (‘D10’), we simply select ‘Formulas’ for our paste method and the cell now contains the formula we copied from our source cell with the cell references in the formula adapted to the new row.

Awesome, right? But what if we had several rows of new data we added in the values column and we wanted to add formulas to the ‘Formula’ column for all those new rows of data? Important note One thing to keep in mind when using copy and paste for both formula and format is that there is no need to copy an entire range of cells to be pasted. We can simply select and copy a single cell with the formula or format we need and then select the range we want to paste either to and then paste formula or format, whichever would apply. However, this does not hold true when using copy and paste for values.

Since this operation actually pastes the literal value that was copied from the source range to the destination, if we were to select a single cell to copy from it will be the only value pasted to the destination range.

By The first thing to consider when copying and pasting content into Excel in Office 2011 for Mac from Excel (or some other application) is to think about the nature of what you’re attempting to copy. Cells, cell ranges, and formulas are treated differently from other kinds of things, such as SmartArt, equations, and charts. If you’re used to copying and pasting, you know that if you select some text and then copy and paste, the default settings paste the text, along with the text format — such as blue (or another font color), bold, or italic. Follow this simple example to copy and paste in Excel: • Select a nonempty cell or any worksheet object to copy. • Use one of the usual copy methods. Click the Copy button on the Standard toolbar, press Command-C, or choose Edit→Copy.