Subscribe to our Blog

JUL
02

Split Screen in Excel 2010

When dealing with large amounts of data in an Excel worksheet, you often need to use the Split Screen item on the ribbon or menu. This option divides your screen into 4 sections and allows you to scroll through these sections while keeping other sections of your worksheet visible.

Continue reading
  5453 Hits
5453 Hits
JUL
02

Freeze Panes in Excel 2010

When dealing with large amounts of data in an Excel workbook, you often need to use the Freeze Panes item on the ribbon. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet. You can freeze rows, columns or both rows and columns.

Continue reading
  12544 Hits
12544 Hits