98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Pasting formulas
excel in courses - Pasting formulas
Resolved · Low Priority · Version Standard
Thu 22 Mar 2007, 10:02Delegate Miriam said...
Miriam has attended:
Excel Intermediate course
Pasting formulas
Hi,
Is there a quick way on the keyboard to paste formulas without having to go to copy, paste special, paste formulas?
Thanks
Fri 23 Mar 2007, 14:07Trainer Tracy said...
RE: pasting formulas
Hi Miriam,
Thanks for the question
If you want to create the same formula in lots of different sheets you can group the sheets together by holding the shift button down and clicking on the tabs, this way you can input a formula on the first sheet which will be the same on all the sheets.
Does that answer your question?
Thanks
Tracy
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. |
Excel tip:Keyboard Shortcuts to Add Rows or ColumnsCouple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns. |
