Due to popular demand, here are some more fabulous keyboard shortcuts that will increase your speed enormously by avoiding use of the mouse! Today’s shortcuts are from visiting spreadsheeter Miles Hunter. Thanks Miles!

1. Select an entire row – place the cursor on any cell in the row… and
PC shortcut: hold Shift and select Space Bar
Mac shortcut: hold Shift and select Space Bar
2. Select an entire column – place the cursor on any cell in the column… and
PC shortcut: hold Control and select Space Bar
Mac shortcut: hold Control and select Space Bar
3. Delete cells with – place the cursor on any cell(s)… and
PC shortcut: hold Control and select –
Mac shortcut: hold Control and select –

by selecting:
Shift cells left – will delete the selected cell(s) AND shift the cell(s) to the right of the deleted/selected cells to the cells to the left (where the deleted cells(s) were)
Shift cells up – will delete the selected cell(s) AND shift the cell(s) just below the deleted/selected cells up (where the deleted cells(s) were)
Entire row – will delete the entire row(s) of the selected cell(s)
Entire column – will delete the entire column(s) of the selected cell(s)
4. Add cells with – place the cursor on any cell(s)… and
PC shortcut: hold Control and hold Shift and select +
Mac shortcut: hold Control and select I

by selecting:
Shift cells right – will move the selected cell(s) to the right of the area of the selected cells will now be empty and ready for business
Shift cells down – will insert blank cells where the selected cell(s) were AND shift the original cell(s) down
Entire row – will insert row(s) above the selected cell(s). The number of rows inserted will correspond to the number of vertical cells selected (going up and down).
Entire column – will insert column(s) the left of the selected cell(s). The number of columns inserted will correspond to the number of horizontal cells selected (going across).

We would love to know your favorite shortcuts or things to do in excel… just post them on our facebook page so we can share the knowledge with other spreadsheeters! Love it!

Small Biz Spotlight
Guess who’s the newest contributor to Amex OPEN Forum?!? Moi!
Check out my 1st article, Selling Others: A Subtle Way To Promote Your Business. It features 2 small businesses that are near and dear to my Excel Rain Heart:
Lock and Mane: Best hair products around, coolest gifts, free shipping on orders of $25 and above, great samples in the packages, and you will get a kick out of their fabulous blog as well…
Callie’s Biscuits: Artisanal biscuits that should be stocked in your freezer at all times and there Pimento Cheese is off the hook! My family is also obsessed with Carrie’s blogs that always has the yummiest recipes that anyone can do!
So go love on these businesses and like my 1st article. As someone who always disliked writing, this is a big day for me 🙂
Also, check out Amex OPEN forum. It is a great community for small businesses to learn, share and network with others. It has provided so much opportunity for Excel Rain Man. Thanks Amex!!

If Excel is bumming you out, just Submit a Request and we will show that spreadsheet of yours who’s boss.

Don’t forget to become a fan of Excel Rain Man on facebook and follow us on Twitter.

Until next time,
Jen Portland

The Excel Rain Diva 🙂