Get instant live expert help on I need help with excel select all rows below

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Select multiple images in rows then left justify them all
Solved by K. H. in 11 mins
My excel sheet keeps returning an error 1004. I'm trying to create an insert button for adding a vehicle to a sales list. below is the code from the macro I created; Range("B3:N3").Select Selection.Copy Sheets("For Sale List").Select Rows("5:5").Select Selection.Insert Shift:=xlDown Sheets("Add New Item").Select Application.CutCopyMode = False Selection.ClearContents Sheets("For Sale List").Select Range("A5").Select End Sub
Solved by D. D. in 27 mins
I have created an Excel table. There are 149 rows so far. When I highlight everything and select sort and filter to alphabetize it only alphabetizes the first 50 rows. The first 50 rows are alternating blue and white. The rows after 50 are not alternating colors. How can I alphabetize all 149 rows (I'll be adding more)?
Solved by M. E. in 13 mins
Strike off all rows below the row where the statement is true till it reaches the row with same value
Solved by M. E. in 12 mins
I have a 1 column excel spreadsheet with over 8,000 rows in the column. Using conditional formatting, I have highlighted about 350 cells that are spread out within the column. I would like to select the cell below every highlighted cell and highlight them also. Any ideas are greatly appreciated! thanks!
Solved by T. Q. in 13 mins