Unfortunately, this makes it difficult for others to detect that our spreadsheet contains hidden data. When we need to hide columns or rows most of us right-click and use the Hide command. Once you try this, you’ll find all kinds of uses for it. Choose what you want to Paste from the dialog box.In the menu bar click Edit>Paste Special. The keystroke shortcut is Control Command V.Paste Special lets you choose what part of the data you paste: formulas, formats, values, comments, column widths, or 10 other data types. We’re using Microsoft Excel for Mac 2011, but these tips should work in all other versions.Ĭopy and Paste copies and pastes all the data from one cell to another. Select the check box for Open in 32-bit mode.Over the next few months we’re going to provide basic tips to help you save time, reduce errors, resolve common problems, and create slick looking spreadsheets.Įven if you absolutely hate Excel… we think you’ll get something out of this 🙂.The following workaround will work with Safari or Firefox: May not correctly open the file in the rich client application.Equation editor may not function correctly.Reference tools may have redraw problems and links may not work.You may be unable to import messages from Lion Mail.You may be prompted to save your presentations when switching windows.Switching out of or quitting Slide Show in full-screen mode may result in inconsistent window behavior.Pressing the Command and Tab keys to open another application while in Presenter View may crash PowerPoint.The date format may display the year as 2 digits insead of 4 digits.The date format may display the year as 2 digits instead of 4 digits.Excel 2008: MSQuery will not work on any version of Excel 2008 on Lion.However, it will not work on other language versions of Excel 2011 on Lion. Excel 2011: MSQuery for English will work on Lion.Excel may crash when you move a sheet from one workbook to another workbook.These issues will likely only be encountered in specific situations or configurations: Here is a list of other known issues that Microsoft is currently investigating. Because Lion no longer supports Rosetta, applications that relied on it will no longer function under the new MacOS. Previous MacOS versions supported Rosetta, an Apple Mac OSX bridge technology that enabled applications such as Office for Mac 2004 to run on the latest chip architecture for Mac.

Microsoft excel for apple mac