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
Browse a Folder in VBA
In many applications or tools you will build with Excel VBA, you will often come across a need to browse a folder. On...Split Cell Data to Columns
In this tutorial, I will be walking through another fantastic facility provided by MS Excel. You may have encountered...Read/Parse a Text file line by line using VBA
There are a couple of inbuilt features in Excel to import data from text files Import Text Data (Delimited) to...Import Text Data (Delimited) to Excel
In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful whe...Set "Enter" Key Direction
You might have noticed that whenever you press "Enter" key, the cell below is always selected. This is be...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...Get List of Files and Sub-Folders in a Folder
While working with VBA, one of the many common things to do will be, getting a list of files and sub-folder in a folde...Import Text Data (Fixed length) to Excel
In this tutorial, I will demonstrate the "Import Text Data" facility of Excel. This facility is useful when...Excel Macros - Hello World
Macros is one of many things which makes an application great. MS Excel also contains this feature. If you have a&nbs...Using 'OR' function in Excel
The 'OR' function is one of the basic logical functions in Excel. It returns either 'TRUE' or 'FALSE' like most logic...
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment