You may not realize it, but clicking around an Excel spreadsheet with your mouse is wasting time—your precious time. There are hundreds of Excel shortcuts that you can use to complete a task without ...

Alright, so here is a weird one that has hit me several times. Some hotkey (or combination of keys) while I am copying/pasting formulas in Excel basically 'locks' the formulas so they do not calculate ...

; Win+7 hotkey - Assigns the active cell to the same address on Sheet2. ; Ctrl+7 hotkey - Assigns a range of cells from the active worksheet to Sheet2. ; Win+8 hotkey - Assigns the active cell to the ...

This is a little set of 3 macro VB scripts I created in 2018 and have used daily since. It allows me to keep a daily timesheet of billable work organized via excel, including: Setup: create a ...