03 and 07 users, rejoice. More

Want to send an Excel 2007 file on, but remove all of your digital fingerprints? More

A reader writes in with the question: “Do you know of any keyboard shortcut to increase and decrease decimal in Excel? I’ve been trying for weeks to find something, but haven’t been able to. I’ve heard its not possible unless you just program a macro.” We come up with a few workarounds… More

SHORTCUT:

=ROUND(A1,A2-1-INT(LOG10(ABS(A1))))
where A1 = cell containing value you want to round and A2 = number of significant digits.

PURPOSE:

Round a number to __ significant digits.

FURTHER EXPLANATION:

ROUND(), ROUNDUP() and ROUNDDOWN() allow you to round but not preserve a specified number of significant digits. Source: OzGrid.

SHORTCUT:
Select entire sheet.
Hit Alt + O + D.
In “Formula Is” type =MOD(ROW(A1),2)=0
Select pattern/shade for every other row

PURPOSE:
Use conditional formatting to shade every other line.

FURTHER EXPLANATION:
You can also just do an even number of lines and paste format, but this does the entire sheet. Source: GRBPS.

SHORTCUT:
Courtesy of OzGrid and the Mr. Excel message board, create the following macro, run it, then look at the sheet that it creates call “Link List.”

Copy all between the rows of ***
**********************************
Dim sht As Worksheet
Dim LinkCells As Range, Cell As Range
‘Add a new sheet to list all external links.
On Error Resume Next
Sheets.Add().Name = “Link List”
Application.DisplayAlerts = False More

SHORTCUT:
Mouse over to the left and right arrows in the lower left-hand corner of your workbook. Right click. A menu should appear of all of the workbook’s sheets.

PURPOSE:
Quickly find a tab if you have a workbook with tons of sheets.
FURTHER EXPLANATION: Ctrl + Page Up and Ctrl + Page Down are quick, if you know where the sheet is that you are looking for, but if you don’t, this method will give you a menu of all of the tabs in your sheet.

It’s not “copying” when it’s Excel. More

Where o where is that link? More

Because a picture is worth a thousand formulas. More

Got a burning urge to fill an entire worksheet with some value? This’ll do the trick. More

Need to break up with your girlfriend, but don’t know quite how to do it? No girlfriend? How about tell someone he’s a jackass? More

SHORTCUT:
Alt + E + S + L

PURPOSE:
Paste as Link.

FURTHER EXPLANATION: Pastes cell as link. For instance, if you copy A1, then go to A2 and hit AESL, “=A1″ will appear.