Miscellaneous Excel tricks that I needed today.Posted: February 11, 2008 | Author: tech0x20 | Filed under: Excel, Microsoft, Office | Leave a comment »
How to hide gridlines on an Excel Worksheet.
Select a Worksheet.
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 scroll into the title row).