complete blank cells

  • Thread starter Thread starter Mery
  • Start date Start date
M

Mery

itanje
I have some blank cells which have to be complete once. Example, same
people
have a keys, but all cells doesn't complete,

358 John John
"
423 Mery Mery
"
Can somebody help to solve the problem,
Thanks very much
Mery
 
I'm not exactly sure what you want to do, but give this a try.
Select your data range with your mouse, hit Ctrl + g, then click 'Special',
click 'Blanks', Click OK, type the '=' sign, hit the up arrow key, hold down
the Ctrl key and then hit enter.

Regards,
Ryan---
 
Korisnik "ryguy7272" napisao je:
I'm not exactly sure what you want to do, but give this a try.
Select your data range with your mouse, hit Ctrl + g, then click 'Special',
click 'Blanks', Click OK, type the '=' sign, hit the up arrow key, hold down
the Ctrl key and then hit enter.

Regards,
Ryan---
Click to expand...

Thanks Ry Guy, you solved my problem!
 

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

complete blank cells 2
complete blank cells 2
compare workbook 2
page setup 3
contents embed 3
Set print area 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How to convert numbered cells into blank 2

Back
Top