microsoft excel freeze panes

Transferred from: HTTP://WWW.GOCALF.COM/BLOG/PYTHON-READ-WRITE-EXCEL.HTML#XLRD-XLWTAlthough working with data every day, and frequently using Excel to do some simple data processing and display, but has long been careful to avoid using Python

Although working with data every day, and frequently using Excel to do some simple data processing and display, but has long been careful to avoid using Python directly read and write Excel files. I usually save the data as a tab-separated text file

In the daily work, we all like to use Excel to make forms, in the sense that it brings convenience, fast, at the same time, have you ever thought that you can use Excel in the function keys and shortcuts, you can make daily work more efficient,

Excel Web Access Error:Unable to Load Workbook The workbook that selected cannot is loaded because it contains the following features that is not supported by Excel Services: Comments,activex controls, Shapes, Text Boxes, Pictures, WordArt,

It is also necessary to merge the worksheets together to form a summary table. At this time more trouble is also more prone to error, because each table of the number is not necessarily consistent, aligned. Because there may be a lack of test,

1. Select a cell--and view--split--freeze panes--Freeze splitter panes2, data--Sort by column--key--options--Sort by columns--by alphabetical order-OK3, start-to-format, auto-adjust row height/column width4, start-to-format (set to a fixed value)