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

select all blank cells of a specific column (go to special)

i need to fill in the blank "barangay" cells with the value in column1. i learned about the go to function but that selects all blank cells of the table, including column 1. i just need the blank cells in "barangay". i tried selecting the barangay column before selecting "go to" but excel just freezes

https://preview.redd.it/2khowvadqm1h1.png?width=590&format=png&auto=webp&s=fad5ffb404611c4829f1b0c41bd24062275eb92a

submitted by /u/hhhhhhhhello
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#barangay
#blank cells
#Excel
#column1
#go to function
#select all
#selecting
#filling in
#specific column
#freeze
#table
#function
#issues
#value
#cells