Summary of Cells Containing Data

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there a way to have excel search through a large range and display
on a separate sheet all the cells in that range that contain data?
 
Is there a way to have excel search through a large range and display
on a separate sheet all the cells in that range that contain data?
Click to expand...

Some thoughts ..

Press F5 > Special >Check "Constants"> OK
will select all data-only cells in the sheet at one go.
You could then format the fills a certain color

Press F5 > Special >Check "Formulas"> OK
will likewise select all formula cells in the sheet

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Data from Summary Sheet 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Help to create a macro 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Getpivotdata with a lookup functions 1
Hyperlink References 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Invalid cell reference 1

Back
Top