How To Copy The Whole Excel Sheet For Mac

пятница 18 январяadmin

Don't really know if this is the reason but what range on the worksheet actually contains data? It is probable that only a relatively small percentage of the worksheet contains data but you have formatting applied to the entire worksheet and the memory just cannot handle it. Try going to the far right of your actual data and select the first entire blank column (click the column Id). Hold Ctrl and Shift then press Right arrow.This will select all of the blank cells to the right of your data. Now in the Home ribbon select clear in the far right block and then Clear All. (Clear All is not available in the Right click menu) Now go to the bottom of your data and select the first entire blank row (Click the row id) and repeat the selection holding Ctrl and Shift but press down arrow and then Clear All. Regards, OssieMac. Free antivirus killer for mac os 10.6.8.

To copy the data, go to Excel spreadsheet and select the range that you want to copy. Select Home -> Copy and then go to PowerPoint and click on Paste. In PowerPoint you can use the simple Paste or Paste Special tool depending if you want to paste the data and chart with special format or as an image. Right-click its sheet tab and then click Move or Copy on its shortcut menu. Excel opens up the Move or Copy dialog box (similar to the one shown here) in which you indicate whether you want to move or copy the selected sheet(s) and where to move or copy them.