JUL
02
0

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
  5062 Hits
5062 Hits
JUL
02
0

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
  11115 Hits
11115 Hits