We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Two Excel Shortcuts
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Morning All,
I'm looking for two shortcuts on Excel that I think are possible, they are as follows:
1. Copying a formula from row F2-H2 to the bottom of the page of data, I know selecting cell F2 and then hitting control, alt and side arrow, takes me to cell H2 (this is the end of the row), however is it possible to quickly copy the formula from these cells to the bottom of the page?
2. Finally I'm updating the source data in a series of pivots, at the moment I seclect change date source, select the spreadsheet the date is in and then manually select the relevant colums so if it's for example A-C my fomula would be $A:$C as I want the pivot to pick up on extra columns added without needing to change the formula. Is there a fast way of doing this without having to input the formula manually?
Thanks
I'm looking for two shortcuts on Excel that I think are possible, they are as follows:
1. Copying a formula from row F2-H2 to the bottom of the page of data, I know selecting cell F2 and then hitting control, alt and side arrow, takes me to cell H2 (this is the end of the row), however is it possible to quickly copy the formula from these cells to the bottom of the page?
2. Finally I'm updating the source data in a series of pivots, at the moment I seclect change date source, select the spreadsheet the date is in and then manually select the relevant colums so if it's for example A-C my fomula would be $A:$C as I want the pivot to pick up on extra columns added without needing to change the formula. Is there a fast way of doing this without having to input the formula manually?
Thanks
0
Comments
-
1. Once you have highlighted those cells, double click on the bottom right hand corner of the last one - that will copy them down.1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0 -
For question 2, do you mean you are adding new columns into the data, or you are adding new rows?
If it's new columns, then rather than setting the pivot to A:C, set it to A:Z, then when you add new data, you just need to refresh the pivot.1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0 -
For question 2, do you mean you are adding new columns into the data, or you are adding new rows?
If it's new columns, then rather than setting the pivot to A:C, set it to A:Z, then when you add new data, you just need to refresh the pivot.
Adding new rows, I just wondered if there was a fast way to do this rather than manually inputting $A-$G each time?0 -
If you are adding new rows, you just need to refresh the pivot - no manual input required.
When you are in the worksheet with the pivot table on it, either look for the Refresh button at the top, or press Alt+F5 (that works on Excel 2007 onwards, not sure about earlier ones)1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0 -
Did this work or not?1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards