I'm not a huge fan of subtotals in Excel -- they're quite high-maintenance. Add a line or field and there's a good chance things won't add up anymore. Here's how to get rid of them so you instead put …
Shift + F11: Insert New Workbook
Use shift + F11 to insert a new worksheet in Excel.A pretty self-explanatory one -- but also a huge time-saver, and also proof that Excel is magic :) PS: A reader mentioned to me that some GIFs …
Avoid the Dread GETPIVOTDATA
It has a purpose, but GetPivotData has confused and frustrated many Excel users. You want to write a formula using PivotTable cells and get a clunky, inflexible result. Here's how to stop …
Quickly Fill Blanks Cells in Microsoft Excel
Hello Readers, Happy New Year!I've been unusually silent lately, in between the holidays and a nasty virus. Avast! I am back with more.I'm trying a new medium: YouTube video. This is a great platform …
Continue Reading about Quickly Fill Blanks Cells in Microsoft Excel →
Scratch that!
Ctrl + 5 applies a strikethrough line to selected cells in Excel. This can be useful if you are collaborating with colleagues on a list-type project and want to clearly show when projects have been …
Open Borders?
Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel. …