Wednesday, September 5, 2012

Excel Tip of the Week - 9/5

I've noticed that a lot of people have some difficulties with Excel, and even people who have been using it for a while don't know everything about it (myself included). I have a nice little certificate that says I'm certified in Excel, Word, and PowerPoint, but mostly I've just picked up a few things that I think are worth sharing.
Most of the time when I'm using Excel, I'm at work, and my work computer runs Windows (super up-to-date... Windows XP) that has Excel 2007. Most things carry over to Excel 2010, which is the version I used for my Excel certification test, and I'll try and include tips for the Mac version because that's what I use at home.
Today's tip is a short and easy one that I use all the time.

Excel Tips & Tricks
To select consecutive cells that have data in them, start at one side and use the keyboard shortcut ctrl, shift, arrow key (in whichever direction the rest of the text is). On a Mac, I think it's command, shift, arrow. It will select everything in that row or column until it comes to a blank cell.
I also found this cool site that's like a wiki for keyboard shortcuts, ShortcutWorld.com.

No comments:

Post a Comment