MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat

Sat, May 12, 2012 4:16 pm

Keep Header Row Visible in Excel When Scrolling

If you have an Excel spreadsheet with many rows, you may want to keep the header row visible even when you scoll far down through the rows of the spreadsheet, so you know what the values in each column represent. This can easily be done, if you have headings for each column in the top row of the spreadsheet, or near the top row, by going to the top of the spreadsheet, so that the header row is the top row of the Excel window. Then click on the cell in column A just below the header row to make it the current cell. Then click on Window and select Freeze Panes. Now, when you scroll down through the spreadsheet, the header row will "float" at the top of the Excel window, so that it is always visible and you don't have to scroll back to the top again to remind yourself what data is found in each column. If you have other rows above the column heading row you selected, those will remain visible as well as everything above the row you were on when you selected Freeze Panes.

If you later want to turn the display of the header row or rows when you scroll through the spreadhseet, click on Window and select Unfreeze Panes.

Note: this works in Microsoft Excel 2000 and later on Microsoft Windows systems and Microsoft Excel 2008 for Mac and should work on other versions of Excel as well.

[/os/windows/office/excel] permanent link

Sat, May 12, 2012 2:25 pm

Determining the Package for a File on a Ubuntu Linux System

To determine which installed package provides a file on a Ubuntu Linux system, you can use the command dpkg -S filename. If you need a particular file, but the package providing it is not installed, you can install the apt-file package and then use the command apt-file search filename to determine which package or packages provide it.

[ More Info ]

[/os/unix/linux/ubuntu] permanent link

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo