Excel 2021 Basic-Excel 2021 Basic

Excel 2021 Basic - Quick Reference

Pdf Summary

This document is a two-page Microsoft Excel 2021 Basic Quick Reference Guide covering the Excel program screen, common tasks, and essential keyboard shortcuts. It introduces how to create, open, save, print, and recover workbooks, use Undo/Redo, and adjust zoom and views. It explains worksheet navigation and selection, including selecting single cells, ranges, entire sheets, and non-adjacent selections, as well as understanding and jumping to a cell address via the Name Box.<br /><br />A large section lists core keyboard shortcuts for general file actions (New, Open, Save, Print, Close), help and calculation, navigation (moving between cells, Home/End behavior, jumping to A1 or the last cell), editing (cut/copy/paste, undo/redo, find/replace, edit a cell, delete contents), and formatting (bold/italic/underline, Format Cells dialog, selecting rows/columns, and hiding rows/columns).<br /><br />The guide also outlines practical editing steps: editing or clearing cell contents, cutting/copying/pasting (including Paste Preview and Paste Special), drag-and-drop move/copy, Find and Replace, spell check, and inserting/deleting/hiding rows and columns. Basic formatting topics include alignment, font and number formatting, wrapping text, merging cells, borders and fill color, using Format Painter, and adjusting column widths/row heights with AutoFit.<br /><br />Finally, it summarizes basic formulas and functions: entering formulas, inserting functions, referencing cells, and using common functions such as SUM, MIN, MAX, and COUNT, plus AutoFill for series. It also covers inserting objects (images, shapes, hyperlinks, alt text) and managing worksheets (insert, delete, hide, rename, tab color, move/copy, switch windows, freeze panes, and setting a print area).

Keywords

Microsoft Excel 2021

Quick Reference Guide

keyboard shortcuts

workbook management

worksheet navigation

cell selection

editing and Find Replace

formatting cells

formulas and functions

printing and print area