Call Today

+1 440-322-ILER(4537)

}
Hours

Mon – Fri, 9am to 5pm

Tech Blog

your go-to resource for all things tech! Stay updated on the latest trends, industry insights, and expert tips to navigate the ever-evolving world of technology.

Microsoft Excel Shortcuts

by | Jul 30, 2019

Here are some shortcuts that you can use to maximize your workflow to maintain an efficient Excel experience.

General Program Shortcuts

  • Press: Ctrl+N: To create a new workbook
  • Press: Ctrl+S: To save a workbook
  • Press: F12: To open the Save As dialog box
  • Press: Shift+F11: To insert a new worksheet
  • Press: Shift+F9: To calculate active worksheets
  •  
  • Press: Ctrl+Z: To undo an action
  • Press: Ctrl+Y: To redo an action
  • Press: F1: To open the Help pane
  • Press: Alt+Q: To go to the “Tell me what you want to do” box
  • Press: F7: To check spelling
  • Press: F11: To create a bar chart based on selected data (on a separate sheet)
  • Press: Ctrl+F: To search in a spreadsheet, or use Find and Replace
  • Press: Alt or F10: To turn key tips on or off
  • Press: Alt+P: To go to the Page Layout tab
  • Press: Ctrl+Tab: To switch between open workbooks
  • Press: Alt+F8: To create, run, edit, or delete a macro
  • Press: Alt+F11: To open the Microsoft Visual Basic for Applications Editor

Borders & Appearance

  • Press: Ctrl+Shift+A: To apply a border to all of a cell’s edges
  • Press: Alt+R: To only add a borderline to the right edge of a cell
  • Press: Alt+L: To add a border to the left edge of a cell
  • Press: Alt+T: To put a border on the top edge of a cell
  • Press: Alt+B: To apply a border to the bottom edge of a cell
  • Press: Ctrl+Shift+_: To remove borders from a cell
  • Press: Ctrl+B: To have data appear in a bold font
  • Press: Ctrl+I: To type in italics
  • Press: Ctrl+U: To underline the contents of a cell
  • Press: Ctrl+5: To strikethrough the contents of a cell
  • Press: Alt+H+H: To select a fill color
  • Press: Ctrl+Shift+$: To apply currency format
  • Press: Ctrl+Shift+%: To apply percentage format
  • Press: Ctrl+9: To hide the selected rows
  • Press: Ctrl+0: To hide selected columns

Editing Cells

  • Press: F2: To edit a cell
  • Press: Shift+F2: To add or edit a cell comment
  • Press: Ctrl+X:  To cut contents of a cell, selected data, or selected cell range
  • Press: Ctrl+C or Ctrl+Insert: To copy contents of a cell, selected data, or selected cell range
  • Press: Ctrl+V or Shift+Insert: To paste contents of a cell, selected data, or selected cell range
  • Press: Ctrl+Alt+V: To open the Paste Special dialog box
  • Press: Alt+Enter: To insert a hard return within a cell (while editing a cell)
  • Press: F3: To paste a cell name (if cells are named in the worksheet)
  • Press: Alt+H+D+C: To delete a column

We at Iler Networking and Computing hope you find use for these Excel shortcuts! Call us at 440.322.4537, for ALL your computing needs. We look forward to hearing from you!

AT&T Attack Reveals 73 Million Customer Records Exposed On The Dark Web

In a statement released by the largest telecommunications company in the United States, AT&T, they shared that they recently discovered a dataset for sale on the “dark web” that contained information for about 7.6 million current AT&T account holders and 65.4...

10 Things Great IT Providers Always Do

What sets high-quality, reliable IT support apart from mediocre or substandard support? Is it lower prices? Flat-fee service? At Iler Networking & Computing, we believe there are many deciding factors that separate even the good from the great providers, but when...

Cyber-Attack Takes Omni Hotels & Resorts Offline; Here’s How To Travel Safely

Another day, another cyber-attack! In early April, Omni Hotels & Resorts was the victim of a cyber-attack that brought down the entire IT system and led to a company-wide outage. The organization took immediate action and brought the entire network offline to...
Data Backups

Why 60% Of Data Backups Fail Businesses When They Need Them Most

From natural disasters and cyber-attacks to accidental deletion, there are many reasons a business needs to back up its data. However, Avast’s latest findings on disaster recovery highlight an alarming issue for small and medium-sized businesses (SMBs): 60% of data...

What Is Bad IT Support Costing Your Business?

In our technology-driven world, efficient IT support is the backbone of any successful business. From ensuring seamless operations to safeguarding sensitive data, reliable IT services are crucial for maintaining productivity and protecting your bottom line. However,...