Essential keyboard shortcuts

-

Essential keyboard shortcuts

Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.
  1. Ctrl +[Down|Up Arrow]: Moves to the top or bottom cell of the current column and combination of Ctrl with Left|Right Arrow key, moves to the cell furthest left or right in the current row
  2. Ctrl + Shift + Down/Up Arrow: Selects all the cells above or below the current cell
  3. Ctrl+ Home: Navigates to cell A1
  4. Ctrl+End: Navigates to the last cell that contains data
  5. Alt+F1: Creates a chart based on selected data set.
  6. Ctrl+Shift+L: Activate auto filter to data table
  7. Alt+Down Arrow: To open the drop down menu of autofilter.  To use this shortcut:
  8. Alt+D+S: To sort the data set
  9. Ctrl+O: Open a new workbook
  10. Ctrl+N: Create a new workbook
  11. F4: Select the range and press F4 key, it will change the reference to absolute, mixed and relative.
Note: This isn’t an exhaustive list. Feel free to share your favorite keyboard shortcuts in Excel in the comments section below. Literally, I do 80% of excel tasks using shortcuts.

Comments

Post a Comment

Popular posts from this blog

FACTS ABOUT CLOUD COMPUTING

-
CLOUD COMPUTING Cloud computing is the use of computing resources (hardware and software) that are delivered as a service over a network (typically the internet). PUBLIC CLOUD Public cloud is one based on the standard cloud computing model, in which a service provider makes resources, such as applications and storage, available to the general public over the internet. Public cloud service may be free or offered on a pay per usage model. PRIVATE CLOUD Private cloud (also called internal cloud or corporate cloud) is a marketing term for a proprietary computing architecture that provides hosted services to a limited number of people behind a firewall. A COMMUNITY CLOUD A community cloud is a multi- tenant infrastructure that is shared among several organizations group with common computing concerns There are also the most distinctive features of Cloud Computing: In order to approach the architecture of cloud computing, one can imagine a simple Calculator. Processor cor...
Read more

Save a Workbook in another File Format

-
Image
  Save a Workbook in another File Format When you save an Excel 2013 Workbook, by default it saves in the  .xlsx  format. Excel 2013 supports saving in other formats, but whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved. File Formats (File Types) that are supported in Excel 2013 − Excel File Formats Text File Formats Other File Formats Excel File Formats Format Extension Description Excel Workbook .xlsx The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). Strict Open XML Spreadsheet .xlsx An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code) .xlsm The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm) Excel Binary Workbook .xlsb The binary file format (BIFF12) for Excel 2007-2013. Template ...
Read more

Healthcare Industry in India

-
Image
Healthcare Industry in India Latest update: October, 2017 Healthcare has become one of India's largest sectors both in terms of revenue & employment. The industry is growing at a tremendous pace owing to its strengthening coverage, services and increasing expenditure by public as well private players During 2008-20, the market is expected to record a CAGR of 16.5 per cent The total industry size is expected to touch USD160 billion by 2017 & USD280 billion by 2020 As per the Ministry of Health, development of 50 technologies has been targeted in the FY16, for the treatment of diseases like Cancer & TB Government is emphasising on the eHealth initiatives such as Mother & Child Tracking System (MCTS) & Facilitation Centre (MCTFC) Indian companies are entering into merger & acquisitions with domestic & foreign companies to drive growth & gain new markets. Source:  Frost & Sullivan, LSI Financial Services, Deloitte ...
Read more