Advance an Excel formula via keyboard shortcut while in edit mode

0 votes

In order to incorporate the December number in the calculation, the SUM formula in the screenshot below must be "advanced" by one column. Is there a keyboard shortcut in Excel that will move this SUM function by one (moving to the right) once it is in edit mode to capture the value of the following column? I am seeking a keyboard shortcut to move the blue box to the right even though I am aware that I can do it with my mouse.

Naturally, I'm assuming the solution, if it exists, would be applicable to more Excel formulas than just SUM.

My Question:

While in Edit Mode in Excel, for any formula that requires an array for an argument (e.g. SUM, MIN, MAX, etc.), can I expand the existing array using a keyboard shortcut?

For example, in my screenshot below, I would like to expand EC64:EM64 to EC64:EN64 using just a keyboard shortcut. Is this possible? If so, how?

Excel screenshot

Nov 29, 2022 in Others by Kithuzzz
• 38,000 points
442 views

1 answer to this question.

0 votes

As requested, you can carry out the following actions with only your keyboard:

Press F2 when you are on the cell that contains your formula (EO64 in your example). Now that you are in Edit Mode, you should be able to see it at the bottom left of your Excel window. If it doesn't, right-click Excel's status bar and choose Cell Mode if it isn't checked.

Next, highlight the portion of the range you want to alter using Shift + left arrow (EM64 in your example).

Now press F2 again to activate Enter Mode. Use the arrow keys to move the "marching ants" into the cell you want to modify the existing range with (you'll notice that Enter Mode now changes to Point Mode). In your example, it appears to be EN64. Press Enter.

I hope this helps you.

answered Dec 10, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
0 answers

How to remove formula in excel shortcut

What is the Excel shortcut key for ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
291 views
0 votes
0 answers

How to open a new tab or a new window while writing an exam in AI - Onlime Remote Proctored

How to open a new tab or ...READ MORE

Jul 20, 2020 in Others by vimalkamal
• 120 points
3,673 views
0 votes
0 answers

Excel 2010, how to keyboard shortcut to filter dropdown checkboxes?

how do I get to the filter ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,690 points
335 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
4,107 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
988 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
2,064 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
1,781 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,600 points
1,293 views
0 votes
1 answer

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 63,600 points
492 views
0 votes
1 answer

How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 63,600 points
1,513 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP