In Excel, I'm trying to figure out how to highlite an entire range of cells, but I only want to copy/paste cel

Question

In Excel, I'm trying to figure out how to highlite an entire range of cells, but I only want to copy/paste cells which have text. Would that be consolidate?

Answer 1

I don't know If I got you here:
- If you want to select the whole sheet, it is CTRL +A, or press the empty space between the A in column heads and 1 in Row titles.
- If you want to select only text cells (Cells with text result, you can use:
Edit > Go To > Special
There you can select only the cells that its resulat are in text, numeric etc
- If you want to select only text cells in a certain range of cells, then, select that range then go to (Edit > Go To > Special) and select your criteria there.

I told you, I am the VBAXLMan

Answer 2

an much less stressful thank you to do it is to easily positioned and equation in a 2d cellular that references the time interior the 1st cellular and subtracts. No "if" fact is needed. i'm questioning the way you enter the time however. Do you have 2 separate cells for the hours and minutes? Or are you putting a initiate time and a end time and then popping out with the kind of hours and minutes? the two way, I nonetheless stand by using what I suggested. do no longer use an IF fact here. in simple terms use a separate cellular to subtract 8 hours from the enter.

Answer 3

Hold CTRL while highlighting cell. That will let you selectively choose which ever cells you would like

Answer 4

You need to write a macro for that. Check out Application.Union keywords