Category Archives: Microsoft Excel

Excel: Freeze Panes

Freeze panes is a great feature to use with larger worksheets.  It locks down the titles on the screen, allowing you to scroll through the data area with [..]

Microsoft Excel , , , , , ,

Excel: Print Titles

Print Titles is a great feature for larger worksheets.  What print titles does exactly what the feature name says,  you specific which row across the top a worksheet [..]

Microsoft Excel , , , , , , ,

Microsoft Excel: Scaling a Two Page Sheet to Print on One Page

Here is a great command to use when you want to fit your worksheet onto one page. This feature will take your two page sheet and print it [..]

Microsoft Excel , , , , , , ,

Microsoft Excel: Setting Print Areas

Print Areas allow you to specify the exact area of worksheet to print out. Setting Print Areas in a Sheet: 1.  Select the are of the sheet you [..]

Microsoft Excel , , , , ,

Display or hide all zero values on a worksheet

 This is a common question we get asked from a lot of Excel users, how do you not display a zero in a cell.  It very simple [..]

Microsoft Excel ,