Many tips are interchangeable between Word and Excel and this tip is one of them. Most of us know that CTRL + Z is a nifty tool for undoing a keystroke – it’s much easier than using the mouse and hunting for that dastardly undo arrow. Likewise, rather than searching the world over for the redo arrow, press CTRL + Y!
Archive for the ‘Microsoft Excel’ Category
Excel
Thursday, December 29th, 2011Tips & Tricks
Tuesday, December 20th, 2011Excel – Looking for a keyboard shortcut to paste special values into your spreadsheet? Press Alt + E +S + V.
Excel Tip: Copy From Above
Saturday, November 5th, 2011Do you need to quickly copy an “above” cell value to a current cell? All you have to do is press CTRL + SHIFT + ” to copy the above cells contents into the current cell.
Microsoft Excel Tip: Easy Sum
Thursday, July 14th, 2011Excel – Add Current Time
Friday, July 1st, 2011Need to add the current time to your Excel document? Hit the “Control” button and the colon key at the same time.
Excel Tip: Multi-Cell Select
Friday, February 18th, 2011Save some time! To select multiple cells with the keyboard (instead of the mouse), simply hold down the Shift key and use your cursor keys.
Microsoft Excel Tip: Format Painter
Saturday, January 8th, 2011Need to copy some complex formatting? Use the Format Painter (the little paintbrush button on the Standard Toolbar). Find the formatting you want to copy. Click the Paintbrush and then click the cell you want apply it to.
Microsoft Excel Tips: Keyboard Shortcuts
Sunday, December 12th, 2010To quickly go to the last cell with data in it, hit CTRL-END. CTRL-HOME always takes you to cell A1. Very helpful in HUGE spreadsheets!
Microsoft Excel Tip: Activate Cell
Saturday, November 27th, 2010To edit the active cell, hit F2. It’s much faster than double-clicking on it.
Microsoft Excel Tip: Gridlines
Tuesday, November 23rd, 2010Need to see the gridlines on a printed copy of your spreadsheet? Don’t draw borders. Just pull down the File menu, choose “Page Setup,” click the “Sheet” tab, and check “Gridlines” under the Print heading. In Excel 2007, click Page Layout, and check the Print Box under Gridlines.









