98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » AutoFill Using Shortcut keys
AutoFill Using Shortcut keys
Resolved · Urgent Priority · Version 2003
Debbie has attended:
Excel Advanced course
AutoFill Using Shortcut keys
I have made a note from my training that Crtrl + Enter performs the autofill function without copying cell formatting, but I can't get it to work. Have I noted it down incorrectly?
RE: AutoFill Using Shortcut keys
Hi Debbie
The Ctrl+Enter shortcut performs an autofill function as explained below:
1. Highlight the area which is to receive the data.
NB. After highlighting the area don't click anywhere on the spreadsheet
2. Type the data that you want to appear in the selected cells (e.g. "March"). You will notice that the text you write appears in the "white" cell of the selected area
3. On the keyboard press Ctrl+Enter
4. The text you typed is copied to all selected cells
Hope this helps
Carlos
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |