MENUMENU
  • FREE RESOURCES
        • Accounts Payable
          Finally! The trick to securing greater T&E compliance
          Benefits
          Rooting out folks who don’t belong on your health plan: A 6-point dependent audit checklist
          IT
          3 costly misconceptions about biz email compromise
          Credit and Collections
          Collecting via email: 4 must-make moves in your subject line
          Accounts Payable
          5 Tough-to-spot signs that an invoice is fake
  • PREMIUM CONTENT
        • Staff management
          120 Proven Communications Tips for Today’s CFO
        • Payroll
          Handling Nonexempt Employee Pay: Stay Compliant and Avoid DOL Audits
          Accounts Payable
          T&E Best Practices: Complete Guide to Ensure Compliance
          Payroll
          Payroll Best Practices: 4 Ways to Save Time and Money
        • Staff management
          Email Best Practices: A 6-Question Quiz
          Staff management
          Innovative Communications Strategies: An Email Case Study
          Staff management
          A 5-part Framework for Successful Workplace Communications
        • SEE MORE
          PREMIUM RESOURCES
  • CORONAVIRUS RESOURCES
  • LOGIN
  • SIGN UP FREE

CFO Daily News

MENUMENU
  • FREE RESOURCES
        • Accounts Payable
          Finally! The trick to securing greater T&E compliance
          Benefits
          Rooting out folks who don’t belong on your health plan: A 6-point dependent audit checklist
          IT
          3 costly misconceptions about biz email compromise
          Credit and Collections
          Collecting via email: 4 must-make moves in your subject line
          Accounts Payable
          5 Tough-to-spot signs that an invoice is fake
  • PREMIUM CONTENT
        • Staff management
          120 Proven Communications Tips for Today’s CFO
        • Payroll
          Handling Nonexempt Employee Pay: Stay Compliant and Avoid DOL Audits
          Accounts Payable
          T&E Best Practices: Complete Guide to Ensure Compliance
          Payroll
          Payroll Best Practices: 4 Ways to Save Time and Money
        • Staff management
          Email Best Practices: A 6-Question Quiz
          Staff management
          Innovative Communications Strategies: An Email Case Study
          Staff management
          A 5-part Framework for Successful Workplace Communications
        • SEE MORE
          PREMIUM RESOURCES
  • CORONAVIRUS RESOURCES
  • Accounts Payable
  • Credit and Collections
  • Payroll
  • Accounting
  • Benefits
  • Finance Technology
  • More
    • Employment Law
    • Strategy
    • Policy and Culture
    • Fraud
    • Payments and Transactions
    • Budgeting and Forecasting
    • Banking
    • Staff Management
    • Cost Control
    • Supply Chain
    • IT

Excel 2013 is here – and so are the shortcuts

Rich Coleman
by Rich Coleman
February 21, 2013
2 minute read
  • SHARE ON

You can never have enough shortcuts – especially when it comes to Excel.

A few years ago, we posted the 21 best Excel shortcuts, but times change and so do Excel versions. After revisiting the 21 best shortcuts, take a look at these additions and add it to your shortcut list.

Also note that, while all CTRL (Control key) shortcuts still work in newer versions of Excel, you’ll need to recall the ALT (Alternate key) shortcuts from memory. There are no more screen reminders mid-typing. If you can’t remember a certain shortcut, press ALT and on-screen key tips will appear.

Most valuable ALT shortcuts

  1. ALT+= – Summing is probably Excel’s most used task, so this can save you some time. To sum a column of numbers, select the cell at the bottom of the column, then key the command to insert the sum function.
  2. ALT+E+D – This will fully delete a cell. Though it may be easier to right click and select “Delete,” it’s probably better to get your hands accustomed to staying on the keyboard as much as possible. Here’s a trick: Think “Express Delete” to remember the shortcut.
  3. ALT+ENTER – Enter a new row in a single cell. Helpful when you need to write data paragraph  by paragraph.
  4. ALT+F1 – This creates a chart out of the data in selected cells. This is probably one of the most commonly used features of Excel.
  5. ALT+F4 – Close all open workbooks. Remember to save when prompted!

Most valuable CTRL shortcuts

  1. CTRL+ ~ (tilde key) – This will show all the formulas in a workbook. To get in the habit of keeping your hands at your keyboard, use this shortcut instead of going back and clicking on every cell to see its formula. (By the way, the tilde key is in the top left of your keyboard)
  2. CTRL+space bar – This will select an entire column. Use SHIFT+space bar to select a single row.
  3. CTRL+F9/CTRL+F10 – These commands minimize and maximize, respectively, the active workbook.
  4. CTRL+Home/CTRL+End – Takes you to the beginning and ending cells, respectively, of the spreadsheet.
  5. CTRL+SHIFT+7 – Applies a border to selected data. This is helpful  with designing templates, too.

Know any helpful shortcuts we haven’t mentioned yet? Let us know about them in the comments below.

Keep Up To Date with the Latest Finance News

With CFO Daily News arriving in your inbox, you will never miss critical stories on accounting, benefits, payroll & employment law strategies.

Sign up for a free CFO Daily News membership and get our newsletter!
  • This field is for validation purposes and should be left unchanged.
CFO Daily News Logo
  • ABOUT CFO DAILY NEWS
  • ADVERTISE WITH US
  • WRITE FOR US
  • CONTACT
  • Accounting
  • Benefits
  • Payroll
  • Policy and Culture
  • Employment Law
  • Fraud
  • Finance Technology
  • Accounts Payable
  • Credit and Collections
  • Strategy
  • Payments and Transactions
  • Budgeting and Forecasting
  • Banking
  • Staff Management
  • Cost Control
  • Supply Chain
  • IT

CFO Daily News, part of the SuccessFuel Network, provides the latest Finance and employment law news for Finance professionals in the trenches of small-to-medium-sized businesses. Rather than simply regurgitating the day’s headlines, CFO Daily News delivers actionable insights, helping Finance execs understand what Finance trends mean to their business.

Privacy Policy Terms of Service
Copyright © 2021 SuccessFuel

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

preloader