| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 100396 | 2009-06-06 03:03:00 | XCEL Question | prefect (6291) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 780032 | 2009-06-06 03:03:00 | I have version 4 and I am trying to insert another column to the right of the last column but it wont let me. Its for stocktake and I want 3 lines of part number and a space to hand write in the quantity. like this border part no column column part no column column part no column border. |
prefect (6291) | ||
| 780033 | 2009-06-06 04:36:00 | Are you trying to set up a template for stocktaking or are you using an existing spreadsheet? . I usually left click on the column ref . e . g . A, then right click and click on insert, if more than the one column then just drag the numbers required . Lurking . This is Excel 2002 help: Insert a single column Click a cell in the column immediately to the right of where you want to insert the new column . For example, to insert a new column to the left of column B, click a cell in column B . Insert multiple columns Select columns immediately to the right of where you want to insert the new columns . Select the same number of columns as you want to insert . On the Insert menu, click Cells, Rows, or Columns . If you are moving or copying a range of cells, and not a row or column, in the Insert Paste dialog box, click the direction to shift the surrounding cells . Tip If there is formatting, you can use Insert Options to choose how to set the formatting of the inserted cells, rows, or columns . |
Lurking (218) | ||
| 1 | |||||