Skip to main content

10 Must useful Microsoft Excel Shortcuts

Anurag

1) Addition: Alt + =
Adding or Sum is being used quite often. To ease out your work you can get to the end of a column or Row of your data and type ALT + symbol, a SUM function will appear with selected Row/Column. You just need to press ENTER to get the desired result.
2) Quick Access Functions: Shift + F3
This to INSERT FUNCTION without using a Mouse button clicking on (fx).
3) Reveal Formula: Ctrl + ~
If you’d like to get a quick view of the formulas that are being used in your Excel sheet, ‘Ctrl and ~’ will quickly reveal all. And to get Excel Back in a normal press the combination key again.
4) Turn Filters On/ Off: Ctrl + Shift + L
The more data an Excel sheet has, the more sensible it is to use filters to classify and analyze them easily. To turn on and off filters simply press: Ctrl + Shift + L (make sure the data you want to filter is highlighted/ selected).
5) Add Comments in a Cell: Shift + F2
To Insert a Comment to particular cell use SHIFT + F2.
6) Insert the Date & Time:
For the current time: CTRL + SHIFT + :
For the current date: CTRL + :
7) create a Chart: Alt + F1
This shortcut creates a chart out of the data in the current range (selected cells). Alt + F1 create a chart on the current sheet. F11 creates a chart in a new sheet.
8) Format a Cell: Ctrl + 1
If you need to format a cell or a group of cells but do not know the specific shortcut, hold ‘Ctrl and 1’ to open the “Format Cells” command box. From here, you can select the necessary formats.
9) Navigate between Worksheets: Ctrl + Page Up, Ctrl + Page Down
One way to save time when working in Excel is to move from worksheet to worksheet without using the mouse. Press ‘Ctrl and Pg Up’ to move one worksheet forward and press ‘Ctrl and Pg Dn’ to move one worksheet backward.
10) Apply the Currency Format: Ctrl + Shift + $
This shortcut applies the currency format to the selected cells – very useful when making financial reports.

Comments

Post a Comment

Popular posts from this blog

Standard and Formatted Input / Output in C++

The C++ standard libraries provide an extensive set of input/output capabilities which we will see in subsequent chapters. This chapter will discuss very basic and most common I/O operations required for C++ programming. C++ I/O occurs in streams, which are sequences of bytes. If bytes flow from a device like a keyboard, a disk drive, or a network connection etc. to main memory, this is called   input operation   and if bytes flow from main memory to a device like a display screen, a printer, a disk drive, or a network connection, etc., this is called   output operation . Standard Input and Output in C++ is done through the use of  streams . Streams are generic places to send or receive data. In C++, I/O is done through classes and objects defined in the header file  <iostream> .  iostream  stands for standard input-output stream. This header file contains definitions to objects like  cin ,  cout , etc. /O Library Header Files There are...
Post a Comment
Read more

locking

DBMS Locking Part I (DBMS only) TECHNICAL ARTICLES -> PERFORMANCE ARTICLES [  Back  ] [  Next  ] DBMS is often criticized for excessive locking – resulting in poor database performance when sharing data among multiple concurrent processes. Is this criticism justified, or is DBMS being unfairly blamed for application design and implementation shortfalls? To evaluate this question, we need to understand more about DBMS locking protocols. In this article, we examine how, why, what and when DBMS locks and unlocks database resources. Future articles will address how to minimize the impact of database locking. THE NEED FOR LOCKING In an ideal concurrent environment, many processes can simultaneously access data in a DBMS database, each having the appearance that they have exclusive access to the database. In practice, this environment is closely approximated by careful use of locking protocols. Locking is necessary in a concurrent environment to as...
Post a Comment
Read more

DATA WAREHOUSE VERSUS DATA MART: THE GREAT DEBATE

DATA WAREHOUSE VERSUS DATA MART: THE GREAT DEBATE Customers exploring the field of business intelligence for the first time often lead with: What is the difference between a data warehouse and a data mart? The next question follows as predictably as night follows day: which one does my company need? Let me start by saying that the two terms are often confused. Indeed, some people in the industry use them virtually interchangeably, which is unfortunate, because they do reflect a valuable hierarchical difference. The Data Warehouse A "data warehouse" will typically contain the full range of business intelligence available to a company from all sources. That data consists of transaction-processing records, corporate and marketing data, and other business operations information; for example, a bank might include loans, credit card statements, and demand deposits data, along with basic customer information. This internal data is frequently combined with statistica...
2 comments
Read more