Microsoft Office for Mac 2011 tutorial: Excel basics 14 Before you move on Make sure that you can do the following: • Copy and paste formatting and data into to a range of cells. Edit data If you enter data incorrectly, or if you just want to change something, Excel makes it easy to edit data at any time. Mac Excel Compatibility Critical Keyboard Shortcuts – Excel for Mac (2008 & 2011) Wall St. Training recommends Excel for Windows due to keyboard shortcut compatibility issues. By Geetesh Bajaj, James Gordon. Formatting cells and cell ranges in Excel 2011 for Mac is like formatting tables. In the Font group of the Ribbon’s Home tab, clicking Borders button displays a drop-down gallery of border styles.

• Select the file or folder, tap or click Share, and then tap or click Zip in the Ribbon toolbar. • Double click on the zip file. Free mac zip utility for windows. To zip (compress) a file or folder • Click on File Explorer icon on the taskbar or press Windows key + E together, to open file explorer. (System might take some time to compress the folder) To unzip (extract) files or folders from a compressed folder • Click on File Explorer icon on the taskbar or press Windows key + E together, to open file explorer.

To find the same fill color cells and replace them with another color you like, the Find and Replace feature in Excel may help you to finish this job. Please do as follows: 1. Select the range cells that you want to find and replace the fill color. Press Ctrl + H to open the Find and Replace dialog box, see screenshot: 3. Then click Options >> button to expand the Find and Replace dialog box, in the expanded dialog box, click Format besides the Find what section, and select Choose Format From Cell from the drop down list see screenshot: 4.

The Excel 2010 Home Tab The Excel 2010 Home Tab has the following Groups: Clipboard, Font, Alignment, Number, Styles, Cells, and Editing. The Excel 2011 Home Tab The Excel 2011 Home Tab has the following Groups: Edit, Font, Alignment, Number, Format, Cells, Themes. Similar Items on Both Home Tabs The Font and Number Groups have the same items so there’s no need to review them. The Alignment and Cells Groups have the same items, and although there is some variation in the underlying drop-down options I won’t cover them in this post. Items You Have to Hunt For in Excel 2011 I’ll review each item on the Excel 2010 Clipboard and Editing Groups, which have items located on the Edit Group and elsewhere in Excel 2011, and finish up with the Styles Group that relates to the Format Group. Note: The Themes Group in Excel 2011 doesn’t exist on the Home Tab in Excel 2010, but can be found on the Page Layout Tab.

Ok figured out how to add a module. Alt - F11 opens the VBA side.

Reinstall microsoft office onenote for mac. You can cancel online without penalty before your trial ends, by visiting and turning off auto-renew in the payment and billing area. • Once your payment method is confirmed, you'll be transferred to to install Office.

The Excel 2010 Home Tab The Excel 2010 Home Tab has the following Groups: Clipboard, Font, Alignment, Number, Styles, Cells, and Editing. The Excel 2011 Home Tab The Excel 2011 Home Tab has the following Groups: Edit, Font, Alignment, Number, Format, Cells, Themes. Similar Items on Both Home Tabs The Font and Number Groups have the same items so there’s no need to review them. The Alignment and Cells Groups have the same items, and although there is some variation in the underlying drop-down options I won’t cover them in this post. Items You Have to Hunt For in Excel 2011 I’ll review each item on the Excel 2010 Clipboard and Editing Groups, which have items located on the Edit Group and elsewhere in Excel 2011, and finish up with the Styles Group that relates to the Format Group. Note: The Themes Group in Excel 2011 doesn’t exist on the Home Tab in Excel 2010, but can be found on the Page Layout Tab.