The structure of your worksheets in Excel can become quite complex. Sometimes you may only need to work with certain portions of a worksheet, clean up its organization, or restructure it entirely. Learn how to do those things and more with the following articles about worksheet structure in Excel.
Tips, Tricks, and Answers
The following articles are available for the 'Worksheet Structure' topic. Click the article''s title (shown in bold) to see the associated article.
Deleting Blank Columns
Import data from another program, and you could end up with a lot of blank columns in your data. Here's the quickest way to get rid of these empty columns.
Floating Information in a Frozen Row
You can freeze information in rows or columns using one of the built-in features of Excel. As you move up or down in the worksheet, the information in the first rows can remain visible. If you want something in a row to always remain visible as you move left and right, the proposition becomes a bit trickier. This tip explains a couple of ways you can approach the problem.
Inserting and Copying Rows
Want an easy way to insert a new row in a worksheet and copy everything from the row above? (You end up with two identical rows this way.) Here's a handy macro that can do this edit in one quick step.
Linked Combo Boxes
Want to add a great way to interact with your worksheet users? Try adding combo boxes that can modify the information shown to the users. Here's how to do it.
Making a Named Range Non-Scrollable
Excel provides a few ways that you can freeze or split what you see in your worksheet. The appropriateness of these tools to a particular task depends entirely on what you want to see happen with your data.
Spreading Out a Table
If someone sends you a worksheet that has lots of data in it, you might want to "spread out" the data so you can have some blank rows included between each existing row. This is easy to do using the handy macro in this tip.