Excel scorecard

G

Guest

how do I shift the contents of a row down to add another name & data to a
list without changing the row fill colour pattern?
 
M

MartinW

Hi Sue,

You could use 'copy' and then 'paste values' instead of 'paste'.
Then just delete your original data.

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet macro stopped working! 5
Sheet name determined by cell value in INDEX/MATCH 2
COUNTIF - Three criteria? 3
Question about conditional formatting of zeros in Excel 0
Summary worksheet Scorecard 1
Locking only borders and patterns 2
Excel Excel 2013 conditional formatting 1
Need Help with Formula 2

Top