1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need Keyboard-Only Method for Drag-Copying Formulas

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.

submitted by /u/Future-Disastrous
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#keyboard-only