excel

MS EXCEL Keyboard ShortcutsWe all have our good days and bad days with Excel. But with these 40 keyboard shortcuts, you can be assured that your session with Excel will all mean business.

Here are 40 of the most awesome Excel keyboard shortcuts to enable you to sail through all your regular and reptetive tasks like an Excel Spreadhseet Ninja.

For your convenience, I have divided them into 5 broad sections viz. – Selection, Switching, Creation, Formatting and Formula.

So here it is: 40 Excel Keyboard Shortcuts

[Continue Reading]

{ 0 comments }

Microsoft Excel TipsIn the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!

Keyboard shortcuts are like the secret tools of every power Excel user. If we use too much of Excel in our day-to-day work, these handy Keyboard shortcuts on Excell cell selection will save a lot of time, and also save you from dragging the mouse into frustration land.

So here, we go.

Selecting entire Column (vertical ) : – Ctrl + Spacebar

Selecting entire Row (horizontal ) : – Shift + Spacebar

Selecting all rows & columns : – Ctrl + A

Selecting first active cell  : Ctrl + Home

Selecting last active cell : Ctrl + End

Selecting all columns from a particular cell to the beginning of the column: Ctrl + Shift + Left

Selecting all columns from a particular cell to the end of the column: Ctrl + Shift + Right

Selecting all rows from a particular cell to the beginning of the row : Ctrl + Shift + Up

Selecting all rows from a particular cell to the end of the row : Ctrl + Shift + Down

Selecting first active cell in a row: Ctrl + Left

Selecting last active cell in a row: Ctrl + Right

Selecting first active cell in a column: Ctrl + Up

Selecting last active cell in a column: Ctrl + Down

Do let us know if these simple tips helped you out, and leave your comments. :) Cheerio and happy exceling.

{ 0 comments }

In the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!

Here we’ll be focussing on how to select a range dynamically and perform further operations to it etc.
For e.g. If we have a Sheet “Input” of which one cell is required say column B, and we need to perform some kind of mathematical operation on them – viz. average, sum, etc. we need to do that by selecting the entire range of non-empty values of those two cells.

The problem here is that the number of entries in column A will vary from time to time, but we want a command button which automatically knows the amount of non-empty values and accordingly runs the mathematical operation. This is known as Dynamic Range Selection.

[Continue Reading]

{ 3 comments }