•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need Keyboard-Only Method for Drag-Copying Formulas
Our take
If you're looking for a keyboard-only method to extend formulas in your report spreadsheet, you're in the right place. While dragging the cell border is a common approach, keyboard users can achieve the same result efficiently. Start by selecting the last cell with the formula and then use the appropriate keyboard shortcuts to fill down the formula into the desired number of rows. This method not only streamlines your workflow but also ensures that cell references update automatically, enhancing your productivity.
I've created a report spreadsheet that uses formulas. I'm also writing a process document detailing how to use the spreadsheet.
If a user needs to extend the number of rows that contain a formula, they can click in the last cell that contains the formula, then drag the cell border down to add the formula to however many rows they need, automatically updating cell references.
Pretty standard stuff, but what I need is the way for keyboard-only users to do this.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- is there a way to modify formulas based on inputs?let's say i want to sum 4 rows in one column. so i'd type something like =SUM(A1:D1) but what if i want to suddenly sum 10 rows? i'd have to go in and re-type the formula to =SUM(A1:J1) or drag that box to sum more rows. i'm wondering if there's a way i could type in a number in a cell, and a formula could use that to determine how many rows to select. submitted by /u/badabingbadaboomie [link] [comments]