EXCEL: 11 very useful excel keyboard shortcuts

Leave a comment

11 very useful excel keyboard shortcuts

EXCEL: Double Click Tricks

Leave a comment

  1. Double Click on the XL logo on the very top left corner to Close Excel.
  2. Adjust column widths by selecting multiple columns and double clicking on the separators (the thin line between the column letters).  This method also works for the rows.
  3. Auto-fill a series of cells with data or formulas using the double-click. Lets say you have a table where in one column you have some data and in the next you have written a formula in the first row. Simply, select the one cell then double click on the autofill box which can be found at the bottom right corner of the cell.  The mouse converts to a skinny black cross. The trick works for formulas, auto-fills (of numbers, dates, what not) as long as the adjacent column has data.
  4. Jump to last row/column in table with double-click. Just select any cell in the table and double click on the cell-border in the direction you want to go.
  5. Lock a particular feature and reuse them with double-click. You can lock any repeatable feature (like format painter, drawing connectors, shapes etc.) by just double clicking on the icon (in Excel 2007 this works for format painter, but for drawing shapes you need to right click and select lock drawing mode). This can save you a ton of time when you need to repeat same action several times.

EXCEL: Insert Multiple Columns at Once

4 Comments

Suppose you have three columns (Column B, Column C, and Column D) that contains information, then you want to insert blank columns in between these columns here is how to do it:

  • Hold down control key.
  • Select one column at a time
  • Right click and choose Insert
  • Done!

Suppose now you want to insert three blank columns to the left of columns Column B,  here is how to do it:

  • Select column B, C and D at a time
  • Right click and choose Insert
  • Done!

Announcing my new app: Ease-eKeys

2 Comments

I am proud to announce my apps for the iPhone and iPod. It called Ease-eKeys. Everyone always asks what is that shortcut command in Word that does…well, my apps does just that. For 99 cents you will get all the shortcuts and keyboard commands for Word Excel PowerPoint and OneNote. The iPad apps will come down the road. Send me your comments. Thank you!

Ease-eKeys photo 1 Ease-eKeys photo 2 Ease-eKeys photo 3 Ease-eKeys photo 4