How can I insert a row without is taking the attributes of the row above it?
Also, what is the short cut to "Sort"?
Please help.
limbo
9:16 am on Nov 11, 2004 (gmt 0)
Don't know if you can insert a row without taking on its parent? alt + d then s > short cut to sort.
edit_g
9:31 am on Nov 11, 2004 (gmt 0)
Copy a blank row from further down in the sheet and 'insert copied cells' (does that make sense?).
The_Expert
2:35 am on Nov 15, 2004 (gmt 0)
Excel? that shouldn't be a problem. Just select insert row from drop down menu. That's it.
Milamber
6:25 pm on Nov 15, 2004 (gmt 0)
right click on the row number, below where you want to insert it -> insert
fashezee
9:11 pm on Nov 15, 2004 (gmt 0)
If you were to color a row and insert a row right under it; the new row would take the color of the top row. This is driving me crazee!
Milamber
9:21 pm on Nov 15, 2004 (gmt 0)
If you were to color a row and insert a row right under it; the new row would take the color of the top row. This is driving me crazee!
If you're using Excel 2003 there should be a small paintbruish that appears after you insert the new row. click on in and you will see a drop-down box. Then select "Clear Formatting"
[Edit]Not sure if older versions have this feature[/Edit]