Category: Office

  • Message rules to filter automated messages and subscriptions

    My word/phrase list: unsubscribe to stop receiving subscription preferences as a web page this message has been sent to like to opt out online privacy policy do not want to receive you no longer wish prefer not to receive to opt out this email was sent to Advice: The space allowed for rules is VERY […]

  • 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 […]