• FREE RESOURCES
  • PREMIUM CONTENT
        • SEE MORE
          PREMIUM RESOURCES
  • HR DEEP DIVES
        • Coronavirus (COVID-19) Resources for HR Professionals
          Employment Law
          Labor Law Posting Requirements: Everything You Need to Know
          Recruiting
          businesswoman selecting future employees on digital interfaces
          Recruiting Resources for HR & Hiring Managers
          Performance Management
          vector image of young female making star rating
          Performance Review Resources
          Employment Law
          Understanding Equal Employment Opportunity and the EEOC
          Recruiting
          Onboarding Resources for HR & Hiring Managers
  • CORONAVIRUS & HR

  • LOGIN
  • SIGN UP FREE

HR Morning

  • FREE RESOURCES
  • PREMIUM CONTENT
        • SEE MORE
          PREMIUM RESOURCES
  • HR DEEP DIVES
        • Coronavirus (COVID-19) Resources for HR Professionals
          Employment Law
          Labor Law Posting Requirements: Everything You Need to Know
          Recruiting
          businesswoman selecting future employees on digital interfaces
          Recruiting Resources for HR & Hiring Managers
          Performance Management
          vector image of young female making star rating
          Performance Review Resources
          Employment Law
          Understanding Equal Employment Opportunity and the EEOC
          Recruiting
          Onboarding Resources for HR & Hiring Managers
  • CORONAVIRUS & HR
  • Employment Law
  • Benefits
  • Recruiting
  • Talent Management
  • Performance Management
  • HR Technology
  • More
    • Leadership & Strategy
    • Compensation
    • Staff Administration
    • Policy & Procedures
    • Wellness
    • Staff Departure
    • Employee Services
    • Work Location
    • HR Career & Self-Care
    • Health Care
    • Retirement Plans

Top 21 Excel shortcuts

Avatar
October 27, 2009
2 minute read
  • SHARE ON

Few people enjoy working in Microsoft Excel. Unfortunately, HR folks often have to.
To make it easier on yourself, here are keyboard shortcuts for 21 common commands:
CTRL — Shift & Outline border to the selected cells.
CTRL Shift # — Change Date format with day, month and year.
CTRL Shift @ — Change Time format with hour and minute, AM or PM.
CTRL Shift : – For the current time.
CTRL ; — For current date.
CTRL 9 — Hide selected rows.
CTRL 0 — Hide selected columns.
CTRL ` — Display Formulas/Alternate in the worksheet.
CTRL+K — To insert Hyperlink.
CTRL+H — Opens up the Find and Replace dialog box.
CTRL+R — Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+7 — Hides or displays the standard toolbar.
ALT+F1 — This creates a chart out of the data in the current range (selected cells). This is the most well-known feature of Excel, and now you know a new way to use it!
ALT+SHIFT+F1 — Inserts a new worksheet into a workbook.
F6 — Switches between the worksheet, Ribbon, task pane, and Zoom controls. This is probably the most useful shortcut of all. This cool shortcut is also the most beloved to all the anti-mouse users out there.
SHIFT+F6 – The reverse of the F6 shortcut.
CTRL+F6 – Switches to the next workbook window when multiple workbook windows are open.
CTRL+SHIFT+$ – Applies the currency format to the selected cells.
CTRL+`– Alternates between showing the value of a cell and the formula in the worksheet. Great for complex worksheets.
CTRL+D – Fill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.
CTRL+R – Fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right.

Get the latest from HRMorning in your inbox PLUS immediately access 10 FREE HR guides.

I WANT MY FREE GUIDES

Keep Up To Date with the Latest HR News

With HRMorning arriving in your inbox, you will never miss critical stories on labor laws, benefits, retention and onboarding strategies.

Sign up for a free HRMorning membership and get our newsletter!
  • This field is for validation purposes and should be left unchanged.
HR Morning Logo
  • Facebook
  • Twitter
  • Linked In
  • ABOUT HRMORNING
  • ADVERTISE WITH US
  • WRITE FOR US
  • CONTACT
  • Employment Law
  • Benefits
  • Recruiting
  • Talent Management
  • HR Technology
  • Performance Management
  • Leadership & Strategy
  • Compensation & Payroll
  • Policy & Culture
  • Staff Administration
  • Wellness & Safety
  • Staff Departure
  • Employee Services
  • Work Location
  • HR Career & Self-Care

HRMorning, part of the SuccessFuel Network, provides the latest HR and employment law news for HR professionals in the trenches of small-to-medium-sized businesses. Rather than simply regurgitating the day’s headlines, HRMorning delivers actionable insights, helping HR execs understand what HR 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

During your free trial, you can cancel at any time with a single click on your “Account” page.  It’s that easy.

Why do we need your credit card for a free trial?

We ask for your credit card to allow your subscription to continue should you decide to keep your membership beyond the free trial period.  This prevents any interruption of content access.

Your card will not be charged at any point during your 21 day free trial
and you may cancel at any time during your free trial.

preloader