Welcome to WebmasterWorld Guest from 54.198.93.179

Forum Moderators: incrediBILL & lawman

Message Too Old, No Replies

Excel

whats that short cut?

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

WebmasterWorld Senior Member 10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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)



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)

10+ Year Member



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

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



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]

 

Featured Threads

Hot Threads This Week

Hot Threads This Month