Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel. …
Hell…
Escape Hell...Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook! …
Time for an Excel Timestamping Shortcut
Time for another Excel shortcut, of course! This is related to Ctrl + ; which will give you today's date (demonstration on my Instagram -- be sure to follow @gjmount!)Ctrl+Shift+; will give you …
Continue Reading about Time for an Excel Timestamping Shortcut →
Multiply a Whole Range by the Same Cell
Here's a feature that takes advantage of the powerful "Paste Special" features in Excel. Say you've got a list of sales by employee and week. The sales reps get a 10% commission. You can easily …
Continue Reading about Multiply a Whole Range by the Same Cell →
Exc-elf?
Harry Potter fan? Think of Excel as your data's house elf. An Exc-elf, as I say.Tonight I am reading Guerilla Data Analysis Using Microsoft Excel. Excellent book: you can tell the authors have been …
Add Hyperlink in Excel
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site! …