How To Microsoft Excel Tips & Tricks

Excel: Quickly remove blank cells

From time to time, Excel worksheets fill up with blank cells interspersed among the content. While the judicious use of whitespace can be useful, it may also make reading the worksheet somewhat challenging. Luckily, Excel has a tool to help us get rid of the blank cells. Here’s how:

Microsoft Excel

MS Excel: Create PDF of active worksheet

I recently had a user call in and ask me how he could export the contents of a single worksheet to PDF while working in Microsoft Excel 2010. As I told him, that is a simple feat to achieve. Here is how:

Microsoft Office

Decrypting Windows’ Minidump files

When a Windows computer crashes, it will, if possible, write a minidump-file (filetype *.dmp) to the hard drive. These files are usually located in %SYSVOL%\Minidump, and they are usually called something like Mini042809-01.dmp. The problem with these files is that they are not exactly easy to read; here’s a small extract of my last minidump:

Luckily, Microsoft has made a set of tools to help us decrypt them. Debugging Tools for Windows are available for most versions of WindowsSimply download, install, and enjoy.
After installing the toolkit, and the symbolset that follows my install of Windows, the minidump is readable, and the conclusion is found at the end, and can look something like this:
Probably caused by : wanarp.sys ( wanarp+1d9b )
or like this:
Probably caused by : USBSTOR.SYS ( USBSTOR+4980 )
or even like this:
Probably caused by : win32k.sys ( win32k+3445 )