Freeze First Two Column In Html Table

Freezing columns locks the column and disallows editing. Provides access to two distinct features depending upon the output type that you have selected. How do you half a page in columns in Word doc. I’m a cognos solution expert and want to use one script of you for freezing columns in a cognos report. Linq; using System. Freeze Columns in Google Sheets. This article will show you methods of reordering position of columns in a table in details. Tested in IE6+, FF2+, Safari3+. To see the rest of the data the user would have to scroll. Fix columns in horizontal scrolling. Freeze columns in Office UI Fabric table component In the last blog post on how to use the Office UI Fabric table and showed how making the table responsive too. Apart form that the trade off is between arranging for the browser to apply the same row and column widths and heights (because all three tables are. To freeze the top row, open your Excel spreadsheet. Afterwards I'm also going to show you, how to do some more elaborate things such as having rows and colums spend multiple cells as well as orienting tables sideways on the page (useful for tables with many columns) and how to have tables span multiple pages (useful for tables with many rows). If I put a value in D10 eg : 30 , then I want it selects its value and put it in E10 from another table which also contain two column “M” and “N”. js is a set of components for building semantic and easily stylable data grid widgets. Go to Solution Explorer > Right Click on App_Data folder > Add > New item > Select SQL Server Database Under Data > Enter Database name > Add. Note pane is freezed at 2nd column and second row. Will that freeze the first row and column in a table? NC. You can either freeze headers but not columns in HTML or you can freeze a column but not headers in AHTML. though the column widths of 25% in your first header table and the 25% column widths in second data table do not strictly have to be the same actual width when resolved to pixels. RWD Table with freezing head and columns for jQuery. Repeat as often as needed. Don't hesitate to check the demos out in their new location along with exhaustive documentation in the project's WIKI. How to use it: Import the ‘GridViewScroll. You can click the Freeze Top Row or Freeze First Column command in the Freeze Panes drop-down menu to freeze just the top row or first column in the worksheet, without regard to the position of the cell cursor in the worksheet. js; Touch-enabled Drag'n'drop Table Ordering Plugin With JavaScript - table-dragger; Fix Table Header And Column In Pure JavaScript - fixed-table; JavaScript Library For Performant Scrollable Table - Smart Table Scroll; Simple Table Paginator In Pure JavaScript. fixed Table and column widths are set by the widths of table and col elements or by the width of the first row of cells. fixed-table is a small and very easy-to-use JavaScript plugin that makes the header and first column of your HTML table sticky on horizontal and vertical scroll. Re: freeze first table row not completly all the cell in that row When you freeze titles, then all the cells in that row (or column) are frozen, thats just the way it works If you have titles in row 1 and freeze those, then all of row 1 is frozen. Select the first row of your table, and then from the Table menu, choose Headings (it's called Heading Rows Repeat in Word 2000). Specify the cell width for all the columns in the ODS output. Sometimes programmer need to customize the layout of application they are developing. Scroll down to the rest of the worksheet. click(); I had to hack your code to fix the offset problem. The words on this page began on the pillow of my bed, wrapped deep in sheets and a blanket, tucked into the darkness of the night. I want to be able to freeze the first 2 columns, can I make my first 2 columns freeze? this webpage to PQ but the Navigator lists no tables at all. th is for table column headings, which can span multiple columns. Freeze panes in JavaScript and CSS. In this jquery plugin table is used and i have used gridview. Out-of-the-box the SharePoint XsltListView webpart does not provide this functionality. Android Scrolling Table with Fixed Header Column, Fixed Row , Header Spans and Pagination Hello coders, I will share another android code. Documentation. It keeps the table header visible if the top of the table is scrolled out of view. On the editor pane, click Insert. The columns won't unhide. Other options are Freeze Top Row and Freeze First Column. Whereas that post was about getting data from multiple TXT files within one folder, this one will tell you how to get data from folder full of Excel files. Now let's suppose that you want to freeze a specific area of the worksheet. Pivot table: 3. Also, simple tables are much better supported by tools to create web content, including WYSIWYG (“What you see is what you get”) editors. My next task is to Freeze the first columns, so when user scrolls to the right, the first column is always displayedsimilar to freeze pane in "Freeze columns" inside of a Table. There is probably a way to automate the freezing of the column(s) so you can freeze and. Click Freeze. Or when added to the table new lines (on ajax), and the width of the columns changes slightly I see the decision to add an event handler to change the width of columns in a table, but it was necessary to add plugin jquery. That is followed by creating a new query using the Get Data From Folder command and getting to our Excel files and the right sheets by using filters. x, the first question raised in my mind is “Why there is no feature of setting the column widths in percentage as we do in HTML?”. The one of our analysissaid that Ice Age 1 x 1 Glass Mosaic Tile in Freeze by. Exporting Html Tables To CSV/XLS/XLSX/Text - jQuery TableExport 107173 views - 12/24/2018; jQuery Plugin For Fixed Table Header, Footer and Columns - TableHeadFixer 104483 views - 09/08/2018; Simple jQuery Plugin To Freeze Header Row In Table - freezeheader 86819 views - 01/06/2017. Freeze Plastic Pint Glass (Set of 2) By HOST If you are looking for Freeze Plastic Pint Glass (Set of 2) By HOST Yes you see this. If you want to freeze the top row or first column, just go to View> Freeze Panes, and then click on either Freeze Top Row or Freeze First Column. Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML. This time I like to show what can be done to make the checkboxes fixed in its position. Python has names that point to objects. Once we implement the jQuery code we will have. In the PivotTable Options dialog, under Layout & Format tab, uncheck Autofit column widths on update option, see screenshot: 4. Any help is greatly appreciated! Reply Delete. Did you know that you could make the top row of a table frozen dynamically in the browser and have the other rows scroll in IE? How to freeze the Top Row. Here all new features are listed, which have been integrated between 2. In the Tables group, click the Table command. Need to freez first row and first 2 columns. In our example, we'll check Total Row to automatically include a total for our table. Related jQuery Plugins. You can also make your header row stand out by centering the text in these cells, applying bold text, or adding a background color. Hi guys, Is possible to merge two columns in Pivot Table? I've a Indicator which aggregates two values by priority and I want to show the two values on same column father. Even when I move the vertical line to required width. Result: Note: to unhide a row, select the rows on. On this worksheet here called HR table. You can freeze row(s) at top or column(s) at left of a worksheet using the freezing panes features. Disclaimer: This site is started with intent to serve the ASP. Select the columns on either side of the hidden column. Exception: IE7 and lower allow all declarations. Reply Delete. Set Excel Row Height and Column Width in C#, VB. In the Excel worksheet, select the upper-left corner of the worksheet area where you want to paste the Word table. on your link the description is to create the html using right and left table. index]) Out[30]: array([0, 3, 1], dtype=int64) The above will work with even if the columns in y are a different order than x column order. If necessary, you can adjust the range, and check box. > > Make sure that "Name" is in the first column, and select the option to > Lock the First Column. Choose the first option which will freeze the columns and rows to the left and above your selection. Hello: Is it possible to Freeze the Pivot Table Data? I would like to give the table data only. Freeze First Row & First Column. Trying to freeze headers of a table in Visualforce page. Indeed with a pixel border your solution is already slightly misalligned. NET MVC Posted on April 16, 2013 by mtryambake One of the very common and useful functionality is to keep fixed header for grid, when we have number of rows on page, Webgrid does not provide fixed header. Imagine your spreadsheet has values in cells A2 through to B16. jasperreports. Press CRL+V (paste). How to Give the Cells of a Table the Same Width in HTML (HTML/CSS) by Christopher Heng, thesitewizard. Is it possible to freeze the first column and top row at the same time? When I scroll downwards, I should be able to see the top row always. This is to specify the columns to stay in its place while scrolling. You can change this behaviour to allow cells to span multiple columns. When I scroll the data from F1, the range from A1:D40 should not more. Page 11: Helpful Hints And Tips. Freeze Rows AND Columns at the Same Time. Make sure you put a background color on the fixed TD's or it will not be readable. The 3 elements altogether is redundant if you are using IE. Basically, I'm trying to replicate the pane freeze feature in excel but am experiencing alot of difficulty achieving this. Sign up Freeze column and fixed header in Table or GridView. When users view data displayed in a Windows Forms DataGridView control, they sometimes need to refer to a single column or set of columns frequently. In the Tables group, click the Table command. Next, click the Apply to drop-down and choose T his point forward. Step-3: Create table for fetch data. I am trying to create a custom column/col using bootstrap. This is a light weight plugin for rendering HTML table to an scrollable table the fixed header and configurable number of fixed columns. i was wondering…if the number of columns are less(say about 7 columns) then there is no need for the horizontal scroll bar, so if I have dynamic data which create the columns…a situation can come where I have only 7 or 8 columns, in this case the horizontal scroll bar should not be there. Overloaded methods For methods with same name but different parameters, only the first method overload retains the original name. In Outline Form, each Row field is in a separate column, as you can see in the pivot table below. By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. Select a column, then click the Freeze button. The dialog shrinks so that you can see more of the sheet. Freeze first column of a HTML table in IE7 Freeze header rows in HTML table: Works in Firefox but not IE Is this possible to set the header rows, right and left of the table columns as fixed by using HTML alone. Is it possible to freeze two rows in an html table? I can freeze one rowbut not sure how to freeze two (without placing a table containing several rows within a single row of the main table and locking this row) - column alignment issues ocurr when placing a table within a row. Thanks Angelo. Freeze header rows in HTML table: Works in Firefox but not IE. Those standard HTML elements are not accepted even in their HTML or. Click a cell in the pivot table. Click on the first cell of the data sequence you want to select. HTML preprocessors can make writing HTML more powerful or convenient. At the surface, an Excel table just sounds like a way to organize data. Select the first cell that you want to be unfrozen. com is a great guide for web developers. Then right click, and choose PivotTable Options from the context menu, see screenshot: 3. Hi All, I have a table that displays more than 50 columns. Therefore, in this case, the function returns the column number of the first cell in the supplied range (i. Note that the "Freeze Panes" command is a toggle command. XL2HTMLX (extended) , converts selection on an Excel sheet to an HTML Table, including row/col headers The selection to be converted may comprise the entire page. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. NOTE: Freezing panes only works when you are in Normal View. Hello, Can anyone please tell me how to freeze headers of a table, I am using tag to create the table and to name the headers. 0 release of ASP. Then click on Content Editor Web Part and add the below script by clicking on 'Edit Source' from the Ribbon. The first example will be locking a table's header. When you freeze a column, Access moves it to the far left side of your table. Freeze Panes-Freeze The Data You Need When you have a huge amount of data under a common heading you are unable to see the heading when scrolled down the worksheet. Sure that does not apply directly to your special problem, but It might give you a starting point in dynamic table manipulation through JavaScript. Added scroller_rowHighlight which adds a hover highlight class name to the row in both the fixed column and main table (see options section for more details). Columns with geometric or user-defined data types are not eligible as. Below are my columns of the report 1) Employee Id 2) Employee name 3) Salary 4) Address 5) Date of Birth 6) column 6 7) column 7 8) column 8 9) column 9 and so on My requirement is to freeze the first 2 columns (1) Employee Id (2) Employee name. The second row are substitles. Setting the 'split' mode in the XML configuration. This is a light weight plugin for rendering HTML table to an scrollable table the fixed header and configurable number of fixed columns. For columns that include header rows, define the parameters for datasets (e. The code worked for me too but I also have the same question as above. Since having 10 columns on page, I have to scroll down right to see last column and vice versa. If multiTemplateDataRows is false, which is the default value, then each dataobject will render the first row that evaluates its when predicate to true, in the order defined in the table, or otherwise the default row which does not have a when predicate. Here is the sample code which used _internal index, myTable is the table id, and using hidden html style applied the css. Hold down CTRL + SHIFT. To prevent this, manually resize the first column to its desired width or set its width using the Width option in the series menu. How to: Freeze Columns in the Windows Forms DataGridView Control. How to Add Columns in Microsoft Word. Indeed with a pixel border your solution is already slightly misalligned. My Gridview takes 6-7 minutes to bind. The process to select the Freeze or Unfreeze option to make sticky header row in Excel might be little different for you if you have a excel version different than mine. I selected J125 and did a Ctrl-Shift-Left to grab all Columns then Ctrl-Shift-Up to grab all Rows. Empno, Ename) and have a group name above them (e. Scott Walker in the 2013-14 school year following outrage over the system’s cash reserves. Android Scrolling Table with Fixed Header Column, Fixed Row , Header Spans and Pagination Hello coders, I will share another android code. Once we implement the jQuery code we will have. Pages On Demand. HTML preprocessors can make writing HTML more powerful or convenient. Also, users can freeze specified rows or columns in one area. Reply Delete. Can Excel show column headers on every screen? Yes, in Excel it's called Freezing Panes, which can be applied to columns or rows (or both), and it's super-simple. You can use the database sheet to give you what you want. Then, follow these steps if you are using Word 97: Select the cells you want to "freeze. I have to create a table which gets data dynamically. In the following sections, I will demonstrate how to freeze Excel panes in WPF. Up to now, I used solution with two tables, first having just the same header content as second one, plus setting first table over the second one's header! Plus a lot of javascript to equal columns width of each table! Your idea to position:absolute the header is great. Below you will have two tables with 20 columns and 30 rows. 9% for the first principal component (PC1) and 17. When I try to merge them, I. Test your JavaScript, CSS, HTML or CoffeeScript online with JSFiddle code editor. Header rows, table summary rows and row header are frozen regardless of FrozenRowsCount and FooterRowsCount. For example F1 to P 80. This code does the following: It makes sure, that an Table with 3 columns always looks like that: The first and last column have the same size, and the center column has a width of 120 pixels. HTML - Table - freeze multiple columns in table Watch this example on youtube; this code will produce simple table with first 2 column frozen while scrolling. By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. Help → OpenOffice Help → Index → Search Term → freezing rows or columns. Because we often use HTML in our table cells, we need to specify something else for the export to make sense. RWD Freeze Table. How to fix/freeze first three columns in a table? 0. I yet to see a good and solid solution for this, please help if you can. As I said, it is not an approach that will be viable if more than two copies of the table are going to be needed, so fixing more than one header column and one header row would not be a good idea. 3) use of col tags to designate column widths Make sure the value of the width attribute of the table tag is equal to the total of the width attributes of the col tags. Click the Add Data button ( ) and navigate the location where your file is stored. You can also use panes to freeze headings in the top rows and first columns so that the headings stay in view at all times, no matter how you scroll through the worksheet. You can freeze row(s) at top or column(s) at left of a worksheet using the freezing panes features. Of course the headers must be consecutive starting with the first row (e. First, insert a pivot table. Wells' War of the Worlds as the content. (I have created this demo using simple html table and the output will be the same in asp. By default, most browsers use an automatic table layout algorithm. Country field to the Rows area. To implement the html table above you would have to use the tr td:nth-child(odd) selector to define all the cells in odd columns in a table and the tr td:nth-child(even) selector to define all the cells in the even columns of a table. Author(s): Vinod Kumar T. Smart Marker. Step 2: create the matrix Manufacturing date in the column and machines in the raw (it can be done vise-verse also). Scott Jehl cooked up two clever ideas. However, to get this behavior for both first row and first column, you need to separate the first row, first column, and first cell from the table, and then continuously set the position of these elements based on the scrolled position of the table body, upon a scroll event. It is articles like yours that don't use general verbiage without telling something concrete and useful, that I need to make it through "CSS rehab". There are several options: Header Row, Total Row, Banded Rows, First Column, Last Column, Banded Columns, and Filter Button. the table at first appears with horizontal and vertical. >> 20 Excel Keyboard Shortcuts that will Impress Your Boss If you work with Excel day in and day out, Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time. Could use a frozen:true option in the colModel, but I did this and it works fine: $("#data_table_timestamp img. Now you can see the company or product names beyond the first screen; that is. Allows you to change the label of a Header. Just select the column you wish to convert into two columns, navigate to the Data tab at the top of the screen and click the Text-to-Columns button. Is it possible (with php) to "freeze columns" while scrolling across so you don't lose the original 2 columns?. In this lesson, we'll look at how to align text vertically in cells. In making large tables for my Senate preference explorers, I wanted to freeze the top row and first two columns, as with a "freeze panes" in Excel. Freeze Column. It enables you to arrange children elements in cells defined by rows and columns. You can choose from two ways to set up your table so that its header row or rows repeat. This code does the following: It makes sure, that an Table with 3 columns always looks like that: The first and last column have the same size, and the center column has a width of 120 pixels. The attribute is applied both horizontally and vertically, to the space between the top of the table and the cells of the first row, the left of the table and the first column, the right of the table and the last column and the bottom of the table and the last row. I am attempting to create a simple HTML table, but I need the first two columns to freeze, and stay on screen if the user has to scroll to see the rest of the columns. We use cookies to give you the best possible experience on our website. There is probably a way to automate the freezing of the column(s) so you can freeze and. Freeze Pane in HTML Table If this is your first visit, be sure to check out the FAQ by clicking the link above. Calling freeze() on an object makes the object immutable, like const in C++. Hi, I would like to create a freeze pane like this example image from a table. It’s renewable, portable and storable with zero loss of power. FedEx won’t renew Amazon’s ground-delivery contract when the agreement expires at the end of this month, the company said in statement first reported by Bloomberg News on Wednesday. Fixed Header and Fixed First Column of a HTML Table using jQuery Sometimes when designing a table in html page we find a lot of columns for a table which exceeds the width of the page. Now do one of the following: To freeze one row only, click Freeze Top Row. Sticky columns/headers (Freeze pane) in tables through jQuery Many times you have seen that the columns or headers freezes when you scroll horizontally or vertically respectively in a table. Click on the first cell of the data sequence you want to select. When users view data displayed in a Windows Forms DataGridView control, they sometimes need to refer to a single column or set of columns frequently. So here is the solution (apologies as I've not covered the negative cases in code, and I hope you all are smart enough to take care of that). How to Freeze the column header in ireport/japser reports. Test your JavaScript, CSS, HTML or CoffeeScript online with JSFiddle code editor. header with scrollable body and aligning columns. Once we implement the jQuery code we will have. Is it possible to freeze headers or columns in Active reports? Assuming that it's not, aside from pagination, has anyone come up with a creative solution for this issue? Frozen headers would complement the ability to work with relatively large data sets in active reports. The name column is the first column in the report. In the Image below you can See that I have an Excel sheet of which I want to freeze top row and first two columns. Freeze First Row & First Column. To remove sorting and show the data in the order R sees it, click the empty cell in the upper left. TableLock example Updated 2016-01-05. The following illustration shows the factory default Freeze Column Line for the Storage Group Volumes object:. I selected J125 and did a Ctrl-Shift-Left to grab all Columns then Ctrl-Shift-Up to grab all Rows. You could firstly export the list to spreadsheet, and update the list item in Excel, but any changes that you make in Excel2007 are not reflected in the list on the SharePoint site, you should export the excel table to SharePoint list again. JavaScript. Thanks in advance. Welcome to 2011…. A bottom row that will be further split into two framed columns. A scroll user input is detected and columns in the content section are scrolled without scrolling the header section. Select the columns on either side of the hidden column. If the column name list of the new table contains a column name that is also inherited, the data type must likewise match the inherited column(s), and the column definitions are merged into one. Cells in other rows do not affect column widths. Pages On Demand. Hmm, maybe you could look at this thread from earlier this year: IR Report Freeze Column Header Row A blonde goes to the doctor and as she touches each part of her body with her finger she says: Doc it hurts everywhere. A menu appears. NET Mostly likely, we need to change the column width and row height when creating a spreadsheet with Microsoft Excel. It’s not a huge problem, more of a cosmetic eyesore. All other columns scrolled. Column mode, also referred to as block mode or block editing, allows you to select columns of data (as opposed to rows) by changing the way you can select text in the editor. Its rows and columns are populated dynamically and I am using Pageblocktable. js is an easy-to-use JavaScript plugin which makes any number of table columns and rows to be fixed in place as you scroll. The original idea is from question on SO Large Dynamic Table with Fixed Rows and Fixed Columns. The raw data will be delete to min. This new version has lot of bug fixes, better browser compatibilty, performance improvements, code optimization, sorttable table, new colModal options and more options to come. Below are my columns of the report 1) Employee Id 2) Employee name 3) Salary 4) Address 5) Date of Birth 6) column 6 7) column 7 8) column 8 9) column 9 and so on My requirement is to freeze the first 2 columns (1) Employee Id (2) Employee name. ) and some script was not multi browser capable. add_table (table) [source] ¶ append (iterable) [source] ¶ Appends a group of values at the bottom of the current sheet. js is a set of components for building semantic and easily stylable data grid widgets. 9% for the first principal component (PC1) and 17. If there is no conflict, then the duplicate columns are merged to form a single column in the new table. All other columns scrolled. GridViewScroll. But because of performance our report is scheduled and saved as HTML report. Add the ‘GridViewScrollHeader’ class to the table header which should be frozen on scroll. In addition, two main dialog boxes help you format the table itself: Table Options and Cell Options. The score plot obtained by PCA is shown in Figure 2. and the other half of doc. In an Office 365 installation, is there anyone that has found away to freeze the left most column of a custom list. Web; namespace MVCTblScroll. This is possible without sorttable using some advanced CSS. Freeze Columns in Google Sheets. Sticky Table Headers & Columns A tutorial on how to create sticky headers and columns for tables using jQuery. Pivot Table. Net Mvc Webgrid Using jQuery Like Excel Sheet 7/23/2014 - By Pranav Singh 0 This article will demonstrate you how you can provide frozen rows and columns functionality like excel sheet in asp. Set Excel Row Height and Column Width in C#, VB. One of the most intriguing features added in April 2017 is the Column From Examples functionality. html) so that anyone can view your Excel data on the web. That is the easy part, I created 2 tables that share a table model. The current selection and selection data is wr= itten back to the table components property tree. To create a two variable data table, execute the following steps. To freeze columns: Select the columns you want to freeze. Often, it is one or two tables in need of vacuuming. The first version of Fixed Table RC was neat but it had some limitations such as nested div structures, breaks on well formatted table and the hanging scrollbars. Freezing specific rows make spreadsheets a delight to scroll around in. row/column are implemented for Excel export because Excel reads these settings ate export time, and process them internally to freeze rows or columns. You can also paste tabular data into an existing table widget. I want to freeze the first column in this Grid (I will always know what this column is). In the column or row you want to delete, select one cell. The row heading or row header is the gray-colored column located to the left of column 1 in the worksheet containing the numbers (1, 2, 3, etc. Next, click the Apply to drop-down and choose T his point forward. Click on a column that’s already sorted to reverse the sort direction. Reply Delete. There are several ways of going about this, as various Stack Overflow pages attest; the one that my brain liked the most is based on this answer, but there were a couple of gotchas in implementing it, and this page explains them (as much for my. That is followed by creating a new query using the Get Data From Folder command and getting to our Excel files and the right sheets by using filters. com is a great guide for web developers. Now go to the View ribbon and click Freeze Panes. We add a table visual, and add some of the fields like address, street number, and Amenities to it. This makes the information easier to understand for everyone and easier to code. Sticky columns/headers (Freeze pane) in tables through jQuery Many times you have seen that the columns or headers freezes when you scroll horizontally or vertically respectively in a table. Freeze columns in a table If this is your first visit, be sure to check out the FAQ by clicking the link above. How to Freeze the column header in ireport/japser reports. Activate the Home tab. Based on Office Open XML specs, allowed values for outline levels are positive integers from 1 to 7. I generate a JSP report which got more than 1000 rows. Make Table Resizable, Scrollable And Sortable With jQuery - jsRapTable 01/09/2019 - Table - 1929 Views. I want to freeze the first column in this Grid (I will always know what this column is). If you need to present a lot of table based data, but you don't want to spoil your page layout with a very long table, you can use the following trick to create a scrollable table with a fixed header. This is to specify the columns to stay in its place while scrolling. Documentation. I have many columns out to the right. I’m a cognos solution expert and want to use one script of you for freezing columns in a cognos report. Then, in Axure RP, right-click the canvas and select Paste Special > Paste as Table. Freeze Columns in Google Sheets. Smart HTML Elements v4. Locked Table Headers. Details of the APARs listed below can be accessed by clicking the link for the APAR number. How to freeze or lock header columns in Google Spreadsheet? Explanation. Using a separate sorter script for table sorting. Good News: there are some nice jquery scripts out there which will do it for you if you want to use them, just search "HTML table fixed column header" (without quotes) Bad News: Only IE will do exactly what you want and possibly only IE6 & IE7 at that, as they are taking advantage of something that. > > Make sure that "Name" is in the first column, and select the option to > Lock the First Column. All the other columns do line up. The White Columns Historic Home We are having some mild but dull weather. add_table (table) [source] ¶ append (iterable) [source] ¶ Appends a group of values at the bottom of the current sheet. To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the Cells group. What seems to happen is whichever selection I make last (freeze or split).