|
|
|
 |
Inserting rows and columns |
| Excel tries hard to make it easy for you to add
labels, numbers, and formulas to your worksheet -- and then move them around to revise the
sheet as necessary. For example: Shortcut menus (and inserting/deleting rows or columns). You can select any worksheet cell then click the right mouse button to get a shortcut menu of useful commands. You can also select entire rows or columns by clicking on the row or column header. Once again, the right mouse button gets you a shortcut menu (which, in this case, allows you to insert or delete rows or columns easily). Column widths. If you type a long label into a worksheet cell (so that it overlaps into the next column), you can double-click the right border of the column header to make the column automatically assume the width of the label. The cursor changes to a double headed arrow to indicate when you can execute this command. Automated series. Excel knows about certain common series that you may use as column headers (for example, Monday, Tuesday, Wednesday...). The worksheet cell cursor includes a drag handle at its lower right hand corner that tries to make it easier to enter such series in the sheet. |
| Learn more |
 |
These ideas are perhaps best shown by
example, and are used in the following 1.3 MB video file. Click on the link to start the video: [1] inserting a row, [2] "best-fit" column width; [3] drag handle for extending known series |