flevyblog

Flevy Blog is an online business magazine covering Business Strategies, Business Theories, & Business Stories.
MANAGEMENT & LEADERSHIP STRATEGY, MARKETING, SALES OPERATIONS & SUPPLY CHAIN ORGANIZATION & CHANGE IT/MIS Other

Tips from a Consultant: Some Not-so-Obvious Excel Shortcuts

Editor's Note: Take a look at our featured best practice, Project Management Workbook (Excel workbook). This is a functional workbook that allows users to plan and track projects against requirements gathered as part of a program. It is versatile enough and customizable to be useful for any type of project. For example, it can be used to document strategic initiatives, define governance and [read more]

* * * *

There are 3 things that separate the struggling Excel monkey from the seasoned one.

  • Keyboard Shortcuts.  Knowing your keyboard shortcuts will dramatically accelerate the speed and efficiency of your work.  It also makes you look like a real pro when your colleagues see you jump from cell to cell, sheet to sheet without ever touching the mouse.
  • Pivot Tables and Formulas.  
  • Visual Basic Programming.  A little bit of VB programming knowledge goes a long way. VB can be used to automate calculations, which, in many cases, becomes necessary, as the model becomes too bulky to “calculate” within a bearable amount of time.

This article will discuss the first group–shortcuts.  I’ve compiled a short list of “not-so-obvious” Excel shortcuts.  These are also the shortcuts I find myself using most often.

Navigation Shortcuts

Ctrl + arrow This is the shortcut I use most frequent. Hold down “CTRL” and hit the arrow key to jump to the edge of the next data region (in the direction of the arrow key). If you’re unfamiliar with this shortcut already, test it out. It’s a bit difficult to articulate in words.
Ctrl + Shift + arrow Achieves the above, while highlighting your selection. This is most often used in conjunction with other shortcuts (e.g. preceded with Copy and proceeded with a Paste).
Ctrl + Page Up
Ctrl + Page Down
Jump to the previous sheet (to the left).
Jump to the next sheet (to the right).
Ctrl + Home Jump to the top-left cell of the sheet. In most cases, this is “A1.” Exceptions include if rows/columns are hidden or the sheet has frozen panes.

Custom Quick Access Shortcuts

One of the greatest improvements in Excel 2007+ is the ability to customize the Quick Access Toolbar. The Quick Access Toolbar refers to the section at the top-left corner of the Excel interface (see screenshot below). You can customize this toolbar by right clicking on it and selecting “Customize Quick Access Toolbar…” From there, you can add, remove, and re-order shortcuts. I’ve only added 2 shortcuts here.

excel_quickaccess

formatpainter Alt + 1 This is the “Format Painter” shortcut.
I often use this shortcut in conjunction with “Ctrl + Shift + down arrow” to extend the formatting of a cell down the column.
pastevalues Alt + 2 This is the “Paste Values” shortcut.
Prior to this trick, accessing the “Paste Values” function was a fairly cumbersome process.
pasteformulas Alt + 3 This is the “Paste Formulas and Number Formatting” shortcut.
This functions allows you to copy and paste everything, except the cell formatting (e.g. borders, background color, font color).  This is useful if you already have your spreadsheet nicely formatted and just wanted to overwrite or extend some existing formulas.

Random Shortcuts

Ctrl + click sheet name + drag tab Many times, you will need to duplicate a full sheet. The easiest way to do this is to hold down “Ctrl,” click the sheet name (i.e. click the tab), then drag it.
Ctrl + click sheet names + make edits Sometimes, you may want to make the same changes across multiple spreadsheets. Prior to knowing this method, I would replicate the change across the multiple sheets manually.  With this shortcut, you can make changes across the sheets simultaneously.  Once you have the multiple sheets selected (note the color of the tab will lighten), pick any one of these sheets and make your edits.
Alt + H, M, C
(Letters pressed consecutively)
Merge and center selected cells.
Alt + H, O, R Rename sheet.

Use a shortcut that’s missing from our list?  Please share in the comments section below.

A great way to learn Excel–including pivot table usages, advanced formula nesting, and VB programming–is by studying robust models that have been built by other business professionals.  You can find Excel models of all shapes and sizes on Flevy here.  Here are a few examples:

For a comprehensive list of Excel shortcuts, check out this page: http://shortcutworld.com/en/win/Excel_2010.html.  Also, if you are an avid user of PowerPoint, read my list of Not-so-Obvious PowerPoint Shortcuts.

Excel workbook
///////////////////////// Project Management PMO Excel Toolkit / Workbook ///////////////////////// Attention all Project Management Office (PMO) professionals! Are you looking for a world-class solution to streamline your project management processes and enhance your [read more]

Do You Want to Implement Business Best Practices?

You can download in-depth presentations on Excel Project Plan and 100s of management topics from the FlevyPro Library. FlevyPro is trusted and utilized by 1000s of management consultants and corporate executives.

For even more best practices available on Flevy, have a look at our top 100 lists:

These best practices are of the same as those leveraged by top-tier management consulting firms, like McKinsey, BCG, Bain, and Accenture. Improve the growth and efficiency of your organization by utilizing these best practice frameworks, templates, and tools. Most were developed by seasoned executives and consultants with over 20+ years of experience.

Readers of This Article Are Interested in These Resources


39-slide PowerPoint presentation
This PowerPoint template is both editable and easy to use and offers a very quick way to construct a Plan On a Page (POaP) for both internal and external stakeholders. 8 time out of 10 in my 20+ years as Project Manager, a Plan On a Page was the go to item for reporting on project status [read more]


 
Excel workbook
 
 
Excel workbook

About David Tang

David Tang is an entrepreneur and management consultant. His current focus is Flevy, the marketplace for business best practices (e.g. frameworks & methodologies, presentation templates, financial models). Prior to Flevy, David worked as a management consultant for 8 years. His consulting experience spans corporate strategy, marketing, operations, change management, and IT; both domestic and international (EMEA + APAC). Industries served include Media & Entertainment, Telecommunications, Consumer Products/Retail, High-Tech, Life Sciences, and Business Services. You can connect with David here on LinkedIn.

, , ,



Complimentary Business Training Guides


Many companies develop robust strategies, but struggle with operationalizing their strategies into implementable steps. This presentation from flevy introduces 12 powerful business frameworks spanning both Strategy Development and Strategy Execution. [Learn more]

  This 48-page whitepaper, authored by consultancy Envisioning, provides the frameworks, tools, and insights needed to manage serious Change—under the backdrop of the business lifecycle. These lifecycle stages are each marked by distinct attributes, challenges, and behaviors. [Learn more]

We've developed a very comprehensive collection of Strategy & Transformation PowerPoint templates for you to use in your own business presentations, spanning topics from Growth Strategy to Brand Development to Innovation to Customer Experience to Strategic Management. [Learn more]

  We have compiled a collection of 10 Lean Six Sigma templates (Excel) and Operational Excellence guides (PowerPoint) by a multitude of LSS experts. These tools cover topics including 8 Disciplines (8D), 5 Why's, 7 Wastes, Value Stream Mapping (VSM), and DMAIC. [Learn more]
Recent Articles by Corporate Function

  

  

  

  

  

The Flevy Business Blog (https://flevy.com/blog) is a leading source of information on business strategies, business theories, and business stories. Most of our articles are authored by management consultants and industry executives with over 20 years of experience.

Flevy (https://flevy.com) is the marketplace for business best practices, such as management frameworks, presentation templates, and financial models. Our best practice documents are of the same caliber as those produced by top-tier consulting firms (like McKinsey, Bain, Accenture, BCG, and Deloitte) and used by Fortune 100 organizations. Learn more about Flevy here.
  


OUR CORE OFFERINGS
Flevy Marketplace: Top 100
· Strategy & Transformation
· Digital Transformation
· Operational Excellence
· Organization & Change
· Financial Models
· Consulting Frameworks
· PowerPoint Templates
FlevyPro (Subscription Service)
KPI Library
Streams (Functional Bundles)
Flevy Executive Learning (FEL)
PowerPoint Services

FREE Resources

About Flevy
Management Topics
Marcus (AI-Powered Consultant)
Partner Program
LinkedIn Influencer Marketing
FAQ / Terms / Privacy / Blog
Contact Us: support@flevy.com



CONNECT WITH US!
       
TOP 100 TRENDING TOPICS
Acquisition Strategy
Agile
Analytics
Artificial Intelligence
Balanced Scorecard
Best Practices
Big Data
Breakout Strategy
Business Continuity Planning
Business Plan Financial Model
Business Transformation
CMMI
COBIT
Change Management
Cloud
Communications Strategy
Company Financial Model
Competitive Advantage
Competitive Analysis
Consulting Frameworks
Continuous Improvement
Core Competencies
Corporate Culture
Cost Reduction Assessment
Customer Experience

BROWSE BY FUNCTION
Strategy, Transformation, & Innovation
Digital Transformation
Operational Excellence and LSS
Organization, Change, & HR
Management Consulting

Customer Journey
Customer Service
Cyber Security
Data Privacy
Decision Making
Digital Marketing Strategy
Digital Transformation
Digital Transformation Strategy
Due Diligence
ESG
Employee Engagement
Employee Training
Enterprise Architecture
Growth Strategy
HR Strategy
Hiring
Hoshin Kanri
ISO 27001
ITIL
Information Technology
Innovation Management
Integrated Financial Model
Kaizen
Kanban
Key Performance Indicators

ADDITIONAL RESOURCES
Business Strategy Frameworks
Case Studies
Consulting Training Guides
COVID-19 Trend Data
Digital Transformation
Financial Advising Services (FAS)

Knowledge Management
Leadership
Lean
Lean Manufacturing
Logistics
M&A (Mergers & Acquisitions)
Manufacturing
Market Research
Marketing Plan Development
Maturity Model
McKinsey PowerPoint
McKinsey Templates
Operational Excellence
Organizational Change
Organizational Design
Performance Management
Post-merger Integration
Pricing Strategy
Process Improvement
Process Maps
Procurement Strategy
Product Launch Strategy
Product Strategy
Project Management
Quality Management


Free Resources
KPI Library
Lean Management
Lean Six Sigma Training Guides
Marcus Insights
Operational Excellence

Real Estate
Remote Work
Restructuring
Risk Management
Robotic Process Automation
SWOT
SaaS
Sales
Scrum
Service Design
Six Sigma Project
Social Media Strategy
Strategic Planning
Strategic Thinking
Strategy Development
Supply Chain Analysis
Sustainability
Target Operating Model
Team Management
Total Productive Maintenance
Value Chain Analysis
Value Creation
Value Stream Mapping
Visual Workplace
Workplace Safety


Product Strategy
Small Business Owner
Startup Resources
Strategic Planning
Strategic Planning Process
Value Innovation Strategy


© 2012-2024 Copyright. Flevy LLC. All Rights Reserved.