Though the 2007+ versions have been making it easy to use, rather than adding new functionality to it, a few Excel shortcuts may come handy at time. I personally use many of them and F4 is my personal favorite as it will repeat your last action. Think of it when you are editing a messy workbook and you need to insert few rows, delete a few, format few cells etc. Below are most of them, starting with Ctrl + key
Thursday, December 12, 2013
Related Posts
Using Nested 'IF' function in Excel
If you understand the IF function in Excel then please continue to understand how to use nested IFs. Otherwise please...Perform Basic Mathematical Calculations
One of the basic usage of Excel is performing simple calculations. This is the first step to perform complex analysis ...Implementing IF-ELSE logic in Excel
Like any programming language, you can implement IF-ELSE logic in Excel. The only difference if the way it is impleme...Using 'IF' function in Excel
In Excel you can make use of IF function to test a condition and return the value based on whether the condition was ...Import Text Data (Delimited) to Excel
In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful whe...How to add a trend or Moving Average line to a chart in Excel
In statistics, a moving average (rolling average or running average) is a calculation to analyze data points by creat...Cricket Score Sheet - 50 Overs
If you play professional cricket every now and then, you will also love to maintain the scorecards in an organized ma...Currency Exchange Rate Reporter
Do you regularly keep check on the currency rates? If the answer is yes, the below will prove more than useful to you...Get Special Folders Path in VBA
While writing small or big applciations in Excel, you might come across a need to get the path of Special folders in ...Using 'CONCATENATE' function in Excel
The CONCATENATE in Excel function is used to join two or more cells values, text strings or words. One can CONCATENATE...
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
Click to see the code!
To insert emoticon you must added at least one space before the code.