Category: Excel

  • Every time you make an Excel spreadsheet this big, a kitten meets its maker

    I’m not really that elitist about non-programmers using applications in an advanced way the programmers could find a better way to do. I’ve never had to port functionality from an Excel spreadsheet that was 2 MB in size prior to data being added–at least not more than once. However, I am a bit disturbed that…

  • Miscellaneous Excel tricks that I needed today.

    How to hide gridlines on an Excel Worksheet. Select a Worksheet.Select Tools->Options…On the [View] tab, un-check Gridlines under the Window Options section. Row and column headers, scroll bars, and sheet tabs are also hideable through this tab. How to Split and Freeze Panes Freeze panes makes very nice title rows (the bottom pane does not…