logo
  • Home
  • About Us
  • Products
  • Services
    • Microsoft Dynamics 365 CRM Training
    • Microsoft Dynamics 365 CRM Configuration
    • Microsoft Dynamics 365 CRM Customization
  • Resources
    • Blog
    • White Paper download
    • CRM for SMB
  • Clients
Contact Us 610.864.8674
Blog
Excel 2016 Hot Keys
Posted on 11/12/2017

Efficiency, efficiency, efficiency – that is the name of the game in business. Microsoft Excel is a fantastic tool for business for a variety of reasons. Here are some of the most popular Hot Keys to help you be more efficient in your us of Excel. 

Please note: 

  • Hot Keys separated by + need to held-down together – Example – First Hot Key Listed – Hold Ctrl down first then hit W 
  • Hot Keys separated by , do not need to be held down, only hit in the correct order – Example – Delete Column – Hold Down Alt then press H, A, and C in that order 
To do this Press 
Close a spreadsheet Ctrl + W 
Open a spreadsheet Ctrl + O 
Go to the Home tab Alt + H 
Save a spreadsheet Ctrl + S 
Copy Ctrl + C 
Cut Ctrl + X 
Paste Ctrl + V 
Paste using the Paste Special dialog box.  Ctrl + Alt + V 
Undo Ctrl + Z 
Redo or Repeat the last command  Ctrl + Y  
Italicize or Remove Italics   Ctrl + I or Ctrl + 3 
Bold or Remove Bold  Ctrl + B or Ctrl + 2 
Underline or Remove Underlining Ctrl + U or Ctrl + 4 
Remove cell contents Delete key 
Delete Column Alt + H, D, then C 
Apply General Number Formatting Ctrl + Shift + ~ 
Apply Currency Formatting Ctrl + Shift + $ 
Apply Percentage Formatting  Ctrl + Shift + % 
Apply Scientific Number Formatting Ctrl + Shift + ^ 
Apply Date Formatting  Ctrl + Shift + # 
Apply Time Formatting  Ctrl + Shift + @ 
Enter Current Time  Ctrl + Shift + :  
Enter Current Date  Ctrl + ;  
Center Align Cell Contents Alt + H, A, then C 
Add Borders Alt + H, B 
Move to the lowest used cell (lowest used row of the rightmost used column) Ctrl + End  
Extend the selection of cells to the last used cell  Ctrl + Shift + End  
Hide Selected Rows  Ctrl + 9 
Hide Selected Columns Ctrl + 0 
Create/Edit a Hyperlink Ctrl + K  
Check Spelling  F7 
Start a new line within selected cell  Alt + Enter  
Go to Formula Tab Alt + M 
Expand/Collapse the Formula Bar Ctrl + Shift + U 
Insert a Function  Shift + F3  
Create, run, edit, or delete a macro Alt + F8  

 

Categories

  • CRM Implementation
  • Database Applications
  • For Your Information
  • Office 365
  • Vet
Address

EBS, Inc.

2855 Dogwood Lane

Broomall, PA 19008

Phone

610.864.8674

    Site Map Contact Us
    logo

    © 2015-2024, EBS, Inc.,

    All Rights Reserved

     

    This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
    Privacy & Cookies Policy

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

    Necessary Always Enabled

    Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

    Non-necessary

    Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.