Excel Shortcuts: Time, Rows, Cells, and Formatting

• These notes cover various keyboard shortcuts and their functions within Microsoft Excel.

Inserting Current Time

• Ctrl + Shift + : to insert the current Time.

Unhiding Rows

• Ctrl + Shift + ( or Ctrl + 9 unhides rows in Excel.

Jumping to the First Cell (A1)

• Ctrl + Home takes you to cell A1.

Formatting Number in Date Format

• Ctrl + Shift + # formats a number as a date.

Creating a New Workbook

• Ctrl + N creates a new workbook.

Inserting a Row or Column

• Ctrl + + OR Ctrl + Shift + + inserts a row or column.

Accessing the Dialog Box

• F5 or Ctrl + G opens the "Go To" dialog box.

Applying Italics

• Ctrl + 3 applies or removes italics.

Copying Formula from Above Cell

• Ctrl + ' copies the formula from the cell above.

Selecting Multiple Worksheets

• Shift, while clicking on a sheet tab, selects multiple worksheets.

Formatting Number in Time Format

• Ctrl + Shift + @ formats a number as time.

Creating a Chart from Current Range

• Alt + F1 creates a chart of the data in the current range.

Closing Workbook

• Alt + F4 closes the current workbook.

Moving Cursor to Beginning (A1)

• Ctrl + Home moves the cursor to the beginning of the sheet (A1).

Accessing Save As

• F12 opens the "Save As" dialog.

Inserting a New Worksheet

• Shift + f3 inserts a new worksheet.

Formatting Cells

• Ctrl + Shift + = formats cells' appearance.

Print Preview

• Ctrl + F2 shows print preview.

Inserting Hyperlink

• Ctrl + K inserts a hyperlink.

Filling Right

• Ctrl + R fills the selected cells to the right.

Inserting Function/Formula

• Shift + F3 inserts a function or formula.

Selecting Entire Row

• Shift + Spacebar selects the entire row.

Showing/Hiding Objects

• Ctrl + 6 shows or hides objects (images & shapes).

Moving to First Cell in Current Row

• Ctrl + Home moves to the first cell in the current row.

Wrapping Text

• Alt + Enter wraps text within a cell.

Save as Dialog Box

• F12 opens the "Save As" dialog box.

Formatting Number in Comma Format

• Ctrl + Shift + ! formats a number in comma format.

Adding a Border

• Alt + H + B adds a border to the cell(s).

Going to Next Cell to the Right

• Tab moves to the next cell on the right.

Opening Visual Basic Editor

• Alt + F11 opens the Microsoft Visual Basic for Application Editor.

Closing Excel

• Alt + F4 closes the Excel application.

Opening Dialog Box

• Ctrl + O OR Ctrl + F12 opens a dialog box.

Switching Workbooks Easily

• Ctrl + Tab easily switches between open workbooks.

Enabling Extend Mode

• F8 enables or disables "Extend Mode" for cell selection.

Pasting Named Range/List

• F3 pastes a named range or named list.

Opening Right-Click Option

• Shift + F10 opens the right-click context menu.

Inserting Current Date

• Ctrl + ; inserts the current date (MM/DD/YY).

Selecting Fill Color

• Alt + H + H allows you to select a fill color.

Flash Fill

• Ctrl + E uses Flash Fill to automatically populate data.

Formatting in Percent Format

• Ctrl + Shift + % formats a number in percent format.

Jumping to Other Sheet

• Ctrl + Page Up/Down jumps to the previous/next sheet.

Filling Down

• Ctrl + D fills the selected cells down.

Switching Panes or Help Task Pane

• F6 switches between the panes of a split Excel window or the Help task pane.

Unhiding Column

• Ctrl + Shift + ) OR 0 unhides a column.

Opening Paste Special Dialog

• Ctrl + Alt + V opens the "Paste Special" dialog box.

Navigating to the Review Tab

• Alt + R navigates to the Review tab on the ribbon.

Summing Automatically

• Alt + = performs an Auto Sum.

Underlining Text

• Ctrl + shift + 4 underlines text.

Repeating Last Action/Toggling Cell References

• F4 repeats the last action or toggles between absolute, relative, and mixed cell references.

Displaying Keyboard Shortcuts for Ribbon

• F10 displays the keyboard shortcuts for the Excel Ribbon (when the Menu Bar is active).

Opening Spelling Dialog Box

• F7 opens the spelling dialog box to check spelling.

Selecting Direction of Cells

• Alt + h + d + c allows selecting Left, Right, Down, or Up cells.

Opening Format Cell Dialog

• Ctrl + shift + 1 opens the Format Cells dialog box.

Applying Strikethrough

• Ctrl + shift + 5 applies strikethrough formatting.

Accessing Insert Tab

• Alt + N goes to the Insert tab on the ribbon.

Navigating to the Data Tab

• Alt + X navigates to the Data tab on the ribbon.

Moving to the Help Tab

• Alt + F goes to the Help tab on the ribbon.

Applying Outline Border

• Alt + w applies an outline border to selected cells.

Replacing Text

• Ctrl + H opens the Replace dialog box.

Opening the File Tab Menu

• Ctrl + Tab opens the File tab menu.

Creating a Table

• Ctrl + L creates a table from the selected data.

Jumping to End of Data

• Ctrl + End jumps to the end of the data region.

Formatting in Currency Format

• Ctrl + Shift + $ formats a number in currency format.

Opening Name Manager

• Alt + F3 opens the Name Manager.

Hiding Columns

• Ctrl + 0 hides the selected columns.

Selecting All Sheets

• Ctrl + Shift + Space selects all sheets in the workbook.

Accessing Page Layout Tab

• Alt + P goes to the Page Layout tab on the ribbon.

Applying Bold Formatting

• Ctrl + 2 applies or removes bold formatting.

Switching Between Excel Workbooks

• Ctrl + F6 switches to the previous Excel workbook.

Editing Cell Contents

• F2 allows editing of cell contents directly.

Minimizing Current Workbook

• Ctrl + F9 minimizes the current workbook window.

Selecting Entire Column

• Shift + Spacebar selects the entire column in the current sheet.

Hiding/Showing Ribbon (Full Screen)

• Ctrl + F1 hides or shows the ribbon for full-screen view.

Navigating to the View Tab

• Alt + W goes to the View tab on the ribbon.

Opening Find/Search Box

• Ctrl + F5 opens the Find/Search box to locate data.

Moving to Previous Cell (Left)

• Shift + Tab moves to the previous cell on the left

Inserting Comments

• Alt + F2 inserts a comment into a cell.

Hiding Rows

• Ctrl + 9 hides the selected rows.

Navigating to Formulas Tab

• Alt + H goes to the Formulas tab on the ribbon.

Finding Data

• Ctrl + F opens the Find dialog to search for data.

Adding/Making a Chart

• F11 Adds/Make a chart to your excel

Navigating to the Add-ins Tab

• Alt + X goes to the Add-ins tab.

Recalculating Formulas

• F9 recalculates all formulas in the workbook

Help

• F1 opens the Help Menu

Inserting the Value from Above Cell

• Ctrl + Alt + " inserts the value from the cell above.

Opening GoTo Dialog Box

• Shift + F4 Opens the GoTo Dialog Box

Inserting a Function

• Alt + F3 Inserts a Function

Creating, Running, Editing or Deleting a Marco

• Ctrl + F8 Create, Run, Edit OR Delete a Macro

Creating a New Worksheet

• Alt + F11 New Worksheet

Deleting a Column

• Alt + e + d Deletes a Column

Removing Outline Border

• Ctrl + spacebar Removes Outline Border

Maximizing the Current Selected Window

• Ctrl + F10 Maximizing the Currently Selected Window

Term: Close Workbook

• Ctrl + F4 closes the current workbook.