21 Excel Shortcuts for HR: Boost Your Efficiency Instantly
By

As an HR practitioner, your days are often packed with a wide range of responsibilities — from managing employee data and tracking leave records to preparing reports and analyzing workforce metrics. Excel is likely one of your go-to tools for organizing and analyzing a lot of that information. But even if you’re comfortable navigating spreadsheets, there’s always room to work smarter — not harder.
Save Time in Excel
Knowing the right Excel shortcuts can save you valuable time, reduce repetitive tasks and make your workflow significantly more efficient. Whether you’re inputting dates and times, formatting data for reports, hiding rows and columns for cleaner presentations, or switching between multiple workbook windows, there’s a shortcut to help you get it done faster.
We’ve compiled 21 essential Excel shortcuts tailored to make your day-to-day work more productive. From inserting timestamps with a keystroke to toggling between formulas and values, these shortcuts can help you avoid unnecessary clicks.
You’ll also learn how to quickly insert new worksheets, format data as currency or dates, and even create charts on the fly — ideal for those HR reports that need a visual edge.
The goal here isn’t just to impress your colleagues with lightning-fast keystrokes (though that’s a bonus), but to free up time you can better spend on more strategic HR tasks. These shortcuts are especially useful if you find yourself handling large data sets or juggling multiple Excel files at once.
So, whether you’re new to Excel or looking to level up your existing skills, these shortcuts are worth keeping at your fingertips. Bookmark this list, print it out, or better yet, practice a few each day until they become second nature. Small efficiencies can lead to big results, and mastering these Excel shortcuts is one easy way to get ahead in your HR role.
21 Common Commands
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.
Want to Take Your Excel Skills Further?
Shortcuts get you moving faster. Knowing how to turn dense data into clear, scannable visuals – without a single chart object – is what makes your reports stand out.
Join HRMorning for a free webinar, Powerful Excel Visuals Without Charts, on Tues., June 16, 2026. Sessions are available at 9 a.m., 12 p.m., and 3 p.m. EDT. Register here.
Further Reading
Is Employee Monitoring Software Worth the Security Risks?
Many HR departments rely on employee monitoring software, sometimes called bossware, to track how remote teams spend their time. However, this monitoring often requires storing screenshots, keystrokes and messages in systems that can become attractive targets for attackers. 6 Key Risks Tied to Employee Monitoring Software Before relying on such bossware, HR teams benefit from […]
Which HR Tasks Should Never Be Fully Replaced by AI?
AI is now a bigger part of everyday operations, including taking over some HR tasks. Automating resume screening, scheduling interviews, workforce analytics, and performance reporting genuinely frees HR teams to spend more time where it matters most. For organizations trying to move faster and operate more efficiently, these tools have real value. But there is […]
Connecticut Joins States Regulating Workplace AI: 7 Compliance Steps
Connecticut is putting employers on notice over workplace AI. Effective Oct. 1, 2026, SB 5 clarifies that Connecticut employers facing a discrimination claim can’t blame the artificial intelligence (AI) tools they use to make hiring, promotion, discipline or termination decisions. Other changes that kicked in the same day: And there’s more coming. The law’s second […]
AI Helps and Hinders, but Employees Can Get the Most Out of It With These 6 Skills
AI helps employees do their jobs: On average, they spend an hour and a half each day using AI. But it’s not all good productivity: Employees spend about half an hour of that time troubleshooting AI errors and on prompt iteration, according to BambooHR’s report, Redesigning Work: AI’s Performance Review. This hasn’t stopped employees’ enthusiasm […]
California’s New Workplace AI Laws: 8 Takeaways for HR
California is again the testing ground for workplace technology rules. On Sept. 30, 2026, Gov. Gavin Newsom signed a group of laws that limit how employers use artificial intelligence (AI) to monitor, evaluate and lay off workers. Together, they reach discipline, surveillance and reductions in force, three areas where HR decisions increasingly run through software. […]
3 Ways HR Can Co-Author Your AI Strategy, Not Just React to It
Most organizations approach their AI strategy the same way they approach every major technology rollout: They build the system, train the users and measure adoption before finally moving on. But AI is fundamentally different. It changes how work gets done, how teams make decisions, and shifts what skills matter most for long-term success. That requires […]