•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Copy and paste in filtered sheet
Hello!
I have a heavily filtered excel sheet with hidden rows that I do a Vlookup in to update inventory. I want to replace the formula with just value. When I go to copy and paste it won’t allow it due to the hidden cells. I’ve tried find&select visible cells and many other shortcuts but nothing has worked besides manually copying and pasting each small set of rows. Does anyone have a trick?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#AI formula generation techniques
#formula generator
#filtered excel sheet
#Vlookup
#Excel
#hidden rows
#copy and paste
#replace formula
#find and select
#update inventory
#visible cells
#value
#shortcuts
#cells
#trick