Welcome to WebmasterWorld Guest from 54.166.48.3

Forum Moderators: incrediBILL & lawman

Message Too Old, No Replies

Excel

whats that short cut?

     
2:14 am on Nov 11, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 12, 2002
posts:1141
votes: 0


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.

9:16 am on Nov 11, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 4, 2002
posts:2204
votes: 0


Don't know if you can insert a row without taking on its parent? alt + d then s > short cut to sort.
9:31 am on Nov 11, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:July 3, 2002
posts:1590
votes: 0


Copy a blank row from further down in the sheet and 'insert copied cells' (does that make sense?).
2:35 am on Nov 15, 2004 (gmt 0)

Junior Member

joined:Oct 25, 2004
posts:56
votes: 0


Excel? that shouldn't be a problem. Just select insert row from drop down menu. That's it.
6:25 pm on Nov 15, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 13, 2004
posts:77
votes: 0


right click on the row number, below where you want to insert it -> insert
9:11 pm on Nov 15, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 12, 2002
posts:1141
votes: 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!
9:21 pm on Nov 15, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 13, 2004
posts:77
votes: 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]