excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Carolyn has attended:
Excel Intermediate course

Excel

When I want to copy the format from a dated cell by dragging from above why does it sometimes copy exactly and other times advance the date by one day for each cell?

RE: Excel - Copying format

Dear Carolyn

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

When you use the dragging method as mentioned in your query you are normally using an alternative method to copying and pasting.

But with certain data such as dates, Name of days (Mon, Tue) or Name of Months (Jan, Feb) they have been programmed to update as they are part of the custom lists.

The only time I believe you get the same thing is when you have not entered the date in the correct format or have extra spaces before or after the entry!!

If you have to copy just the format and not the content then the best feature to use is the Format Painter. If you need help with that please let me know and I should be able to guide you through.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.08 secs.