Excel Mac Basic-Excel Mac Basic - Quick Reference Guide

Excel Mac Basic - Quick Reference Guide

Pdf Summary

This document is a two-page Microsoft Excel for Mac Basic Quick Reference Guide focused on working with columns, cells, worksheets, and common tasks. It introduces the Excel for Mac program screen, identifying key interface elements such as the Quick Access Toolbar, Ribbon, Formula Bar, Name Box, worksheet tabs, scroll bars, zoom slider, and view controls.<br /><br />It covers essential “Getting Started” actions: creating, opening, saving, printing, and closing workbooks; using Undo/Redo/Repeat; changing views; using zoom; and configuring AutoRecover settings through Excel Preferences. It explains cell selection techniques (single cell, ranges, entire worksheet, and non-adjacent selections), cell addressing (e.g., A1), and how to jump to a specific cell using the Name Box.<br /><br />A large section lists keyboard shortcuts for general commands (New, Open, Save, Print), navigation (moving between cells, jumping to A1 or the last cell), editing (cut/copy/paste, find/replace, clear contents), and formatting (bold/italic/underline, Format Cells dialog, selecting rows/columns, hiding rows/columns).<br /><br />The guide then explains core editing operations: editing cell contents via the Formula Bar or double-click, clearing contents, cut/copy/paste, Paste Special (including transpose), drag-and-drop move/copy (Option to copy), find and replace, and inserting/deleting/hiding rows and columns.<br /><br />Basic formatting topics include text and number formats, alignment, wrap text, merging cells, borders and fill color, Format Painter, and adjusting/AutoFitting column widths and row heights.<br /><br />It also summarizes basic formulas and functions: entering formulas, inserting functions, referencing cells, and using common functions like SUM, MIN, MAX, and COUNT, plus AutoFill for completing series. Finally, it covers inserting objects (images, shapes, hyperlinks), setting object properties and alt text, and managing worksheets (insert/delete/hide/rename/tab color/move/copy), freezing panes, setting print areas, and adjusting page layout settings for printing.

Keywords

Excel for Mac

Quick Reference Guide

keyboard shortcuts

cell selection

worksheet management

rows and columns

formatting cells

formulas and functions

AutoFill

printing and page layout