Microsoft Excel keyboard shortcuts

Use keyboard shortcuts to speed things up in Excel

By Jim Lynch, ITworld | Software, microsoft excel keyboard shortcuts Add a new comment

February 17, 2012, 3:37 PM — Here are some helpful keyboard shortcuts for Microsoft Excel 2010.

CTRL+PgUp Switches between worksheet tabs, from left-to-right.
CTRL+PgDn Switches between worksheet tabs, from right-to-left.
CTRL+SHIFT+( Unhides any hidden rows within the selection.
CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.
CTRL+SHIFT+~ Applies the General number format.
CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+% Applies the Percentage format with no decimal places.
CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.
CTRL+SHIFT+# Applies the Date format with the day, month, and year.
CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+: Enters the current time.
CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells.

For more shortcuts, see the original article at the link below.

Keyboard shortcuts in Excel 2010 | Microsoft

Jim Lynch is a technology analyst and online community manager. Jim has written for many leading industry publications and sites over the years.

He also writes the Desktop Linux Reviews blog, the Eye On Linux blog and writes his own tips blog Technology Tips and Tweaks.

You can also read many original columns, reviews and roundups on JimLynch.com. These articles include some excellent free software roundups for the iPhone, iPad, Mac and other platforms.

Jim also runs two discussion forums of his own. You can visit the Desktop Linux Reviews Forum and the Collective Forum. The DLR forum focuses mainly on Linux, and the Collective is a general technology and off-topic forum. Please drop by and say hello.

From CIO.com

From CSO Online

iPhone 5 growing up, but not out, this fall

10 comments
Java creator unhappy with Oracle trial outcome

5 comments
What would a post-e-mail world look like?

4 comments
Fired: 7 large lay-offs by tech companies

4 comments
Install MATE on your Linux Mint 13 Cinnamon system

3 comments

Older
|
Newer

ITworld LIVE

The White Paper Breaking Down Virtualization Barriers was viewed
The White Paper Activities Streams Base An Integrated Social Layer was viewed
The White Paper A Business-Driven Approach to Legacy Modernization: Rapid Service Enablement via Small, Orchestrated Steps was viewed
The White Paper RHEV for Servers Feature Comparison was viewed
The White Paper Top 10 Best Practices of Windows Server Backup for Virtual and Physical Servers by Don Jones, Microsoft MVP was viewed
The White Paper Unified, scale-out NAS for virtual workloads: Dell EqualLogic FS7500 was viewed
The White Paper Start Small, Grow Tall: Why Cloud Now was viewed
The White Paper VMware Backup: 5 Misperceptions of Agentless Backup was viewed
The White Paper The Essential Guide to Choosing a Web Analytics and Online Marketing Solution was viewed
The White Paper HP Virtualization Smart Bundles with VMware: Simple, Cost-effective Virtualization Solutions was viewed
The White Paper The Essential Guide to Choosing a Web Analytics and Online Marketing Solution was viewed
The White Paper Forrester: Formulate A Database Security Strategy to Ensure Investments Will Actually Prevent Data Breaches and Satisfy Regulatory Requirements was viewed
The White Paper Turning Financial Mainframe Applications into SOA Building Blocks was viewed
The White Paper Microsoft Open Value Program Guide was viewed
The White Paper Proven strategies for uncovering cost savings with IBM DB2 was viewed
The White Paper SANS Institute: Oracle Database Vault Review - Controlling Privileged User Access to Sensitive Application Data was viewed
The Webcast Enterprise Mobile Computing: BlackBerry PlayBook tablet 2.0 was viewed
The White Paper BI Optimization: Building a Better Business Case for BI was viewed
The Webcast Seven Deadly Sins of Cloud Security (Video) was viewed
anthony11 has just joined ITworld
The White Paper Why Unified Storage? was viewed
The White Paper 11 Key Marketing Trends was viewed
roony2111 has just joined ITworld
The White Paper Five Myths of Cloud Computing was viewed
The White Paper Forrester Whitepaper: IT Operations Managers Must Rethink Their Approach to Private Cloud was viewed
The White Paper IT Consolidation with HP and VMware for the Midmarket was viewed
The White Paper eGuide: 8 Reasons Why you Need Hosted VoIP was viewed
The White Paper Using BD for Smarter Decision Making was viewed
Bernard Swiss has just joined ITworld
The White Paper Enable a world where people can choose how they want to work with a user managed applications solution was viewed

SoftwareWhite Papers & Webcasts

White Paper

Activities Streams Base An Integrated Social Layer

The enterprise social software market is exploding thanks to converging trends of consumerization, cloud, and mobile. In this must-read report, "The Forrester Wave: Activities Streams, Q2 2012", Forrester Research Inc. evaluated five social software vendors with core strengths in the stream based on the overall strength of vendors' current offerings, a clear product strategy, and vendor market presence. In a detailed look at the space, Forrester named Yammer as a leader.

White Paper

ESG Lab Review: HP 3PAR Peer Motion Software

This ESG Lab review sponsored by HP + Intel documents hands-on testing of HP 3PAR Peer Motion Software's distributed volume.Intel and the Intel logo are trademarks of Intel Corporation in the U.S. and/or other countries.

White Paper

ESG Lab Review: HP 3PAR Peer Motion Software

This ESG Lab review documents hands-on testing of HP 3PAR Peer Motion Software's distributed volume management with a focus on federated workload balancing, asset management, and thin provisioning.Intel and the Intel logo are trademarks of Intel Corporation in the U.S. and/or other countries.

White Paper

Deliver Cost-Effective Business Continuity with Extreme Capacity

IBM DB2 provides application cluster transparency technology that equips organizations running OLTP applications with the ability to deliver high availability and continuous uptime for transactional data, plus the flexibility and capacity they need to remain competitive.

White Paper

What Developers Want: The End of Application Redeploys

Eliminate application restarts in Java with JRebel! JRebel is a JVM plugin that eliminates application redeploys from the Java development cycle, a process that takes over 10 minutes of coding time away from developers each working hour, according to a recent survey. Just code, refresh and see everything instantly.

See more White Papers | Webcasts