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
Split Cell Data to Columns
In this tutorial, I will be walking through another fantastic facility provided by MS Excel. You may have encountered...VLOOKUP Function in Excel
While working with Excel, quiet often you will feel the need the search a table in excel and get some value from it...Using 'COUNTIF' function in Excel
The COUNTIF function counts the number of cells within a range meeting the specified criteria. For example, you can c...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 ...Import Text Data (Delimited) to Excel
In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful whe...Create Directory Tree
When you are dealing with too many files at a time, sometimes you feel the need to list them. One way of doing so and...Color Palette in Excel VBA
Many a times you will need to show colors at run time for your cool Excel application. A good mix of Colors can make a...Import Web Data to Excel
MS Excel allows you to import content from almost any website you want to. Once you provide a link, it will look for ...Enable or Hide Fill handle for Drag and Drop Editing
The Fill handle in excel is used for drag-and-drop editing. By default it is turned on in Excel so that you can drag t...Conditional Formatting of Cells
Have you ever felt the need to highlight different cells with different colors in Excel based on some criteria. If th...
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.